E1: 41: Item Ledger/Account Integrity Report (R41543) (Doc ID 625476.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version XE and later
JD Edwards EnterpriseOne Inventory Management - Version XE and later
Information in this document applies to any platform.

Purpose

Overview

The inventory balance fluctuates with manufacturing, purchasing, sales, and inventory transactions. Any time this occurs a corresponding journal entry should reflect the change in the general ledger inventory account.

The Item Ledger/Account Integrity (R41543) report will print discrepancies between the Item Ledger or Cardex (F4111) and the inventory entries in the Account Ledger (F0911) tables. Based on the Item Ledger (F4111), the Item Ledger/Account Integrity (R41543) report will use the current AAIs to determine which Account Ledger entries are for the Inventory account, and will check to make sure that the amounts match the Item Ledger entries. If the amounts are different, the difference will appear in the reports as a Variance Amount.

For most transactions, there will be one record in the Account Ledger (F0911) file corresponding to each record in the Item Ledger (F4111) file.

It is NOT necessary to run the Item Ledger As Of Record Generation (R41542) report before running the Item Ledger/Account Integrity (R41543) report.