3090712 - Inventory Balance Report Showing Wrong Ending Quantity

You have performed an Inventory Adjustment to zero the Quantity of a Product at a particular Site with a Key Date in the past. However, when you run the Inventory Balance report for the Product and enter the Actual Execution On Date as the Key Date of the Inventory Adjustment, you find that the Ending Quantity of the Product is not the expected Zero Quantity.

SAP Business ByDesign

1. Go to the Physical Inventory work center.
2. Go to the Reports view.
3. Open the Inventory Balance report
4. Enter the Actual execution on date as same as the Key Date maintained in the Inventory Adjustment.
5. Enter the relevant Product ID.
6. Enter the relevant Site ID.
7. Click on Apply.
8. In the result, you can see the Ending Quantity is not zero. You expected the Quantity to be zero, and so you want to know why the system is behaving this way. 

The available Inventory Quantity on the Key Date is greater than the adjusted available Inventory Quantity on the Created On date of the Inventory Adjustment.
On the said Key Date, the Opening Quantity for the Product is X whereas on the Created On date of the Inventory Adjustment, the Quantity available in the Inventory for Adjustment is Y. Therefore, when you performed the Adjustment, you only reduced the available Quantity Y to zero. However, between the Key Date you maintained in the Inventory Adjustment and the Date you created the document, you have consumed the Quantity m in a Sales Order. Hence, when you execute the report, the system is rightfully showing the Ending Quantity as the difference between the Opening Quantity X and the adjusted Quantity Y which is the Quantity m consumed in a Sales Order between the 2 dates.

This is the reason the Ending Quantity is not zero.

 The system is behaving correctly.

 Inventory Balance report, Inventory Adjustment, Zero Quantity , KBA , AP-IP-ANA , Analytics , Problem