E1: 41: Inbound Cycle Count Interoperability (P4141Z1 / R4141Z1I / R4141Z1P)
(Doc ID 625452.1)
Last updated on JULY 21, 2020
Applies to:JD Edwards EnterpriseOne Inventory Management - Version XE and later
Information in this document applies to any platform.
The definition of Interoperability is enabling applications and technologies to allow one system to share data and/or logic with another system. It is often used to transfer large amounts of data from one system to another.
The Inbound Cycle Count Process can be used to upload information about the actual number of items that are in the inventory at a specific point, into the Cycle Count Transaction File (F4141) and Cycle Count Header (F4140) tables.
- Inbound Flat File Conversion (R47002C) - Use Version XJDE0006
- Flat File Cross Reference (P47002)
- Inbound Cycle Count Inquiry (P4141Z1)
- Cycle Count Inbound Transaction Process (R4141Z1I)
- Inbound Cycle Count Purge (R4141Z1P)
- Cycle Count Unedited Transaction Table (F4141Z1)
- Cycle Count Transaction File (F4141)
- Cycle Count Header (F4140)
The Cycle Count Header (F4140) file stores the Cycle Count Number, Description, Cycle Count Status and the Count Date. As per Bug 11010903: R4141Z1I NO CYLO OR CYIT - SAR: 8929011, it should also store information on the Number of Items selected (CYIT) and Number of Locations selected (CYLO).
The Cycle Count Transaction (F4141) file is shared by both the Cycle Count and the Tag Count programs. It holds information about the items selected for count, including the on-hand value currently in the Item Location (F41021) file. This on-hand value is "frozen" because once the Cycle Count Transaction (F4141) records are created, they do not change regardless of inventory transactions, sales or receipts that occur in the system.
This process can only be used to create secondary locations for items for which primary locations already exist. It is not possible to load all the item locations for a new item and branch using this process. Error 2895 - Cannot add Secondary Without a Primary will be encountered during Cycle Count Update (R41413) if the item does not already have an existing primary location defined.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Flat File Information|
|The Inbound Cycle Count Process|
|Minimum Required Fields in the Cycle Count Unedited Transaction table (F4141Z1)|