SAP Knowledge Base Article - Public

3112601 - Product Quantities are not matching with Report Inventory Balance and Report Physical Inventory Count

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

  1.  Go to Business Analytics Work Center
  2. Navigate to Design Reports View
  3. Search for Physical Inventory Count
  4. Pass Selection parameters such as product  Site id 
  5. We could see Product Actual quantity 
  1. Go to Business Analytics Work Center
  2. Navigate to Design Reports View
  3. Search for Inventory Balance Report
  4. Pass Selection parameters such as product, Site id 
  5. 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

Product

SAP Business ByDesign all versions