My Oracle Support Banner

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.

Details

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
Purpose
Details
 Summarizing Inventory Entries
 Reviewing the Report
 Report Logic
 User Defined Code Table 41/IN
 Rules Used To Determine Inventory Accounts
 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
References

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