Cycle Counts from Inbound Transactions

You might receive inbound transactions for the F4141 table. Examples include copying initial balances from a legacy system to JD Edwards EnterpriseOne Inventory Management and copying data from hand-held scanning devices that are used to count inventory.

The Interoperability interface table for cycle count inbound transactions is F4141 Cycle Count Unedited Transaction Table (F4141Z1).

The related application table for cycle count inbound transactions is Cycle Count Transaction File (F4141).

For the F4141Z1 interface table, interoperability requires data in these fields:

  • Short Item Number (ITM).

  • Branch/Plant (MCU).

  • Location (LOCN), if used.

  • Lot/Serial (LOTN), if used.

  • Storage Unit Number (STUN), if used.

  • Class Code (GLPT).

  • Total Primary Quantity on Hand (TQOH).

  • Total Primary Amount on Hand (TAOH).

  • Total Primary Quantity Counted (TQCT).

  • Total Primary Amount Counted (TACT)

  • Unit Cost (UNCS).

  • Total Secondary Quantity on Hand (SQOR).

  • Total Secondary Quantity Counted (SQOH).

You run the Cycle Count Inbound Transaction Process program (R4141Z1I) to copy information from the F4141Z1 table to the F4141 table.

After the transaction process is complete, you must run the Cycle Count Update program on the Inventory Count Alternatives menu (G4121) to update the on-hand balances, prepare journal entries, and perform the other functions associated with this program.