In JD Edwards EnterpriseOne, transactions impacting inventory must create balanced entries in the Item Ledger (F4111) and the General Ledger (F0911) in order to maintain the integrity between these two tables. Examples of inventory transactions can be: Inventory Adjustments, Inventory Transfers, Sales Update for a Sales Order, the receipt of a Purchase order, the completion of a Work Order, etc.
Sometimes, discrepancies occur. It is important to identify and correct these discrepancies to ensure that the Item Ledger and the General Ledger are kept in balance.
The existing Item Ledger/Account Integrity (R41543) report is based on DMAAI setup, which limits its functionality, as the link between the inventory transactions and the previous G/L accounts is lost if users change the DMAAI setup.
New functionality has been introduced in JD Edwards EnterpriseOne Release 9.1 Update 2 that simplifies the reconciliation process between Inventory and G/L by means of the following key features:
9.1 Enhancement - Inventory to G/L Reconciliation Process (Doc ID 1678098.1)