SAP Knowledge Base Article - Public

2794944 - Difference Between Stock Overview and Product Planning

Symptom

You notice that the reported Quantity for a Product XXX (XXX represents the Product ID) in the Planning Area YYY (YYY represents the Planning Area ID) in the Stock Overview and in the Product Planning Details screens do not match. The On-Hand Stock and the Available Stock are not the same.

Environment

SAP Business ByDesign

Reproducing the Issue

To check the On-Hand Stock, you can follow the below steps:

  1. Go to the Supply Planning work center.
  2. Select the Stock Overview under Common Tasks.
  3. Enter the relevant Product ID.
  4. Enter the relevant Supply Planning Area ID.
  5. Click Go.
  6. You can see there is an X On-Hand Quantity displayed.

To check the Available Stock, you can follow the below steps:

  1. Go to the Supply Planning work center.
  2. Select the Products view.
  3. Select the Advanced Search.
  4. Enter the relevant Product ID.
  5. Enter the relevant Supply Planning Area ID.
  6. Click Go.
  7. You see the Available Quantity is displayed as Y which is different from the Quantity X displayed as On-Hand Stock in the Stock Overview.

Cause

Sometimes when you finish an Outbound Delivery, an Inbound Delivery or a Warehouse Order, and the quantity is only updated in one of these views, it generates this inconsistency.

Resolution

You can create a Data Flow Verification Run to fix the inconsistency:

  1. Go to the Application and User Management work center.
  2. Select the Data Flow Verification Runs view.
  3. Select New.
  4. Enter the Run ID.
  5. Select the Evaluation Two specific business documents.
  6. Click Next.
  7. Select the Business Document One: Inventory.
  8. Select the Business Document Two: Planning View of Inventory.
  9. Click Next.
  10. Enter the Product ID as equal to XXX.
  11. Enter the Supply Planning Area ID as equal to YYY.
  12. Click Next.
  13. Check the box "Automatically correct differences (recommended)".
  14. Click Next.
  15. Click Finish.
  16. Go to the Application and User Management work center.
  17. Select the Data Flow Verification Runs view.
  18. Find the Run ID which you just created.
  19. Select Change Status.
  20. Choose Set to Active.
  21. Select Schedule.
  22. Choose the Schedule Start Immediately.
  23. Select Save and Close. 

Keywords

Quantity, mismatch, difference, Overview, Product, Planning, Details, Supply, Available, Stock, On-Hand , KBA , dfv result , data flow verification result , process dfv run result , process dfv result , AP-SDM , Supply and Demand Matching , How To

Product

SAP Business ByDesign all versions