SAP Knowledge Base Article - Public

3505932 - Report "Inventory Ageing" Misses Stock

Symptom

In report "Material Inventories - Balance Summary", Material ABC has 2 ea in business residence DEF, but there is no such inventory in report "Inventory Ageing".

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to work center Business Analytics.
  2. Access view Design Reports.
  3. Search "Material Inventories - Balance Summary"(FININVU14_Q0001), open it.
  4. Maintain ABC for filter Material and other filters, click Apply. In the result, there are 2 ea in business residence DEF.
  5. However, in another report "Inventory Ageing" (SCMINVAGV04_Q0001), for material ABC, there is no inventory in site DEF.

Cause

Since 2 ea of product ABC are in "In Transit" status, report "Inventory Ageing" doesn't consider it.

The "In Transit" status is result from unequal issued and received quantity in stock transfer scenario. For example, in a document flow of stock transfer order, 5 ea are issued but only 3 ea are received, then 2 ea will stay in the original ship-from site without logistics area and with status "In Transit".

Resolution

This is system standard behavior.

Keywords

KBA , AP-IP-INV , Inventory , Problem

Product

SAP Business ByDesign all versions