My Oracle Support Banner

E1: 41: Item Balance\Ledger Integrity Report (R41544) Shows Incorrect Quantity in Item Ledger Column of the Report (Doc ID 2948827.1)

Last updated on JUNE 17, 2024

Applies to:

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

Symptoms

After running Item As Of Processing (R41542) for the first time in their company, their Item Balance\Ledger Integrity Report (R41544) reporting variances on all items with lots that have had Transfer Order (ST) transactions in the year 2021 that were never processed through Sales Update (R42800).

Steps to Duplicate

  1. Item Availability Inquiry (P41202) shows one item number/location/lot with zero on-hand.
  2. Item Ledger (F4111) shows two entries for Item, Branch, Location and Lot
    1. Reclassification IU for +4 Units, Posted to As Of Table (F41112) PC = Y, G/L Date = 5/14/2021
    2. Ship Confirm on Transfer Order (ST) for -4 units NOT Posted to As Of Table (F41112) PC = S, No G/L date because Sales Update (R42800) was never run.
    3. Both transactions are from 2021
    4. There have been no additional transactions since May 2021
    5. The two transactions +4 and -4 sum to zero which matched the Item Location Quantity of 0
  3. Item Balance\Ledger Integrity Report (R41544) shows the following for the same item/branch/location/lot show:
    1. Item Balance Column of the report is 0
    2. Item Ledger Column is -4 when it should be 0.
    3. The report seems to pick up the Ship Confirm Transaction (-4) and not the Reclassification transaction (+4)

Cause

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
Symptoms
Cause
Solution
References


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