Symptom
You observe Product KLM quantities are not matching in Report Inventory Balance with Report Physical Inventory Count for Site id DEF.*KLM refers to Product Id, *DEF refers to Site id
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics Work Center
- Navigate to Design Reports View
- Search for Physical Inventory Count
- Pass Selection parameters such as product Site id
- We could see Product Actual quantity
- Go to Business Analytics Work Center
- Navigate to Design Reports View
- Search for Inventory Balance Report
- Pass Selection parameters such as product, Site id
- We could see Ending quantity
Cause
There is a difference of quantities between the two reports due to backdated posting of warehouse confirmation.
Resolution
Inventory Balance report works on the actual execution date and not the creation date, hence you’d see the difference quantities which is valid behaviour.
Keywords
Product Quantities are not matching in Report Inventory Balance with Report Physical Inventory Count,Report Inventory Balance with Report Physical Inventory Count , KBA , report inventory balance , report physical inventory count , product quantities are not matching , AP-IP-INV , Inventory , Problem