My Oracle Support Banner

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

Last updated on MAY 20, 2022

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.



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.

The Item Ledger/Account Integrity Report does have limitations.

An alternate, more robust feature rich process to reconcile inventory to the General Ledger is available beginning in release 9.1.  Our document 1678098.1 - E1: 41: Inventory to G/L Reconciliation Process (P41500/R41500/R41501) outlines the functionality for the reconciliation process.

An advisor webcast recording outlines and demonstrates the process. See  Advisor Webcast Recording:JD Edwards EnterpriseOne: 9.1 Enhancement - Inventory to G/L Reconciliation Process on November 2014[Video] (Doc ID 2724003.1).




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
 Summarizing Inventory Entries
 Reviewing the Report
 Report Logic
 User Defined Code Table 41/IN
 Rules Used To Determine Inventory Accounts
 Inventory to GL Reconciliation Functionality Available
 Data Selection
 Account Summarization in Manufacturing (Connecting F3106 and F0911)
 Account Ledger Column Calculation
 Steps to Determine a False Variance
 False Variance Example
 Classifying Accounts Used in Inventory Transactions
 Frequently Asked Questions

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.