My Oracle Support Banner

E1: 41: Item Balance / Ledger Integrity Report (R41544) (Doc ID 625472.1)

Last updated on MARCH 04, 2020

Applies to:

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

Purpose

Overview

The system maintains a current on-hand inventory balance for each stock item. When a transaction is performed that affects inventory for an item, the system interactively updates the on-hand balance and creates a record detailing the transaction.

The purpose of the Item Balance/Ledger Integrity (R41544) UBE is to compare the current on-hand balance and inventory valuation of an item to the cumulative quantity and cost of all transactions that have occurred. The report identifies discrepancies between the two so changes necessary to resolve the discrepancies can be made.

For additional insights on how the Item Balance/Ledger Integrity (R41544) report columns are calculated, why variances occur and how to resolve common variances, please review KM document 1599285.1 Case Study - How to resolve Item Ledger-Item Balance Integrity Problems.

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
 Program Functionality
 Item Balance, Item Ledger and Cost Files
 "As Of" Processing File (Required)
 Updating Balance Forward Records for Inactivity in the Fiscal Year
 Processing Options
 Integrity Issues
 Working with dates in the Future
 Deleting Records from Item Balance (F41021) file
 Weighted Average Costs
 Miscellaneous Issues
 Outside Operations Items (*OP)
 Ledger Quantity Column is blank
References

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