3412311 - Material XYZ Has Different Inventory Quantities in Different Reports

You observe the Inventory Quantity of a material XYZ (XYZ refers to material ID) is different in SCM and Financial Reports.

SCM Report: Inventory Report (Report ID: SCMINVV02_Q0001)..

FIN Reports: Material Inventories - Balance Summary (Report ID: FININVU14_Q0001).

                      Material Inventories - Balance History (Report ID: FININVlJ14_Q0002).

SAP Business ByDesign

1. Open the Work center Business Analytics and view Design Reports.
2. Search Inventory Report (Report ID: SCMINVV02_Q0001), open it, enter XYZ in filter Material, click Apply, in the result the On-Hand Stock is PQR (PQR Refers to Quantity 1).
3. In report Material Inventories - Balance Summary (Report ID: FININVU14_Q0001), enter XYZ in filter Material, click Apply, in the result Inventory Quantity is ABC (ABC Refers to Quantity 2).
4. In report Material Inventories - Balance History (Report ID: FININVU14_Q0002), enter XYZ in filter Material, click Apply, in the result Ending Quantity is ABC again.

SCMINVV02_Q0001 derives quantity from on-hand stock which is PQR.

FININVU14_Q0001 and FININVU14_Q0002 - Both financial reports works on dates, meaning that Key Date and Accounting Period/Year are considering, and hence based on the selected dates, data will be shown appropriately. To understand further, for both the reports add 'Accounting Period/Year' as a Row Field and you can see the period wise quantity movements.

Correct system behaviour.

Material Valuation, Quantity , KBA , SRD-FIN-INV , Inventory , How To