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:

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

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