My Oracle Support Banner

E1: 41: Quantity and Amount Columns in Item Ledger/Item ASOF Table Integrity Report (R41760) are Incorrect (Doc ID 3019486.1)

Last updated on APRIL 29, 2024

Applies to:

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

Symptoms

The values populated in the As Of File and Item Ledger Columns of the Item Ledger/Item ASOF Table Integrity Report (R41760) do not match the data in the Item As Of File (F41112) and Item Ledger (F4111) Tables that provide the data for the report.

Steps to Duplicate:

NOTE: No sensitive or personal data is presented in the example below:
  1. Run Item Ledger/Item ASOF Table Integrity Report (R41760) with data selection on a specific Item, Branch, Location and Lot.
  2. The ASOF File report columns for Period 3, year 2022 do not match what appears in the As Of File (F41112)
    1. In the report, As Of Data Quantity Column = 0 and Amount Column = 0
    2. In the As Of File (F41112) the Quantity = 74, and As Of Amount = 1,810.50
  3. The Item Ledger report columns for Period 3, year 2022 does not match the sum of the transaction quantities and amounts in the Item Ledger (F4111)
    1. In the report, Item Ledger Quantity Column = -74 and Item Ledger Amount = -1,810.50
    2. In the Item Ledger Table, the sum of the Transaction Quantities with G/L Dates in March 2022 (F4111.TRQT) = 0 and the sum of Transaction Amounts with G/L Dates in March 2022 (F4111.PAID) = 0

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.