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

Last updated on MAY 18, 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.

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.

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).