Discrepancy between Inventory Value Report and Material Account Distribution Report. (Doc ID 2260247.1)

Last updated on JULY 23, 2024

Applies to:

Goal

Material Account Distribution Report is run for Inventory Value Account and summarized it by Subinventory. Then quantity of some subinentory is not matched with quantity of Inventory Value Report - By Subinventory.

• On Material Account Distribution Report, total quantity of ItemA on SubinventoryA = 1.
• On Inventory Value Report - By Subinventory, quantity of ItemA on SubinventoryA = 2.

Steps:

1. Run Material Distribution Report for Inventory Value Account with Transaction To parameter = "28-Feb-2017".
2. Summarize the report output by Subinventory and check total quantity for ItemA on SubinventoryA.
3. Run Inventory Value Report - By Subinventory with As of Date parameter = "28-Feb-2017 00:00:00".
4. Check the quantity for ItemA, SubinventoryA.

Solution

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