SAP Knowledge Base Article - Public

2987086 - Quantity Difference Between the Inbound Delivery and the Inbound Delivery Detailed Line Items Report

Symptom

You have received a Stock of aProduct with an Inbound Delivery. However, when you check the Report "Inbound Delivery Detailed Line Items" (Report ID: SCMCIDB03_Q0001), it is showing a wrong Quantity of the Product.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Third Party Logistics work centre.
  2. Go to the 3PL Inbound: Inbound Deliveries view
  3. Find and select the relevant Inbound Delivery ID.
  4. Click the Edit button.
  5. Navigate to the Line Items and search for the relevant Product ID.
  6. You can see multiple rows of the Product in the Inbound Delivery.
  7. Go to the Business Analytics work centre.
  8. Go to the Design Reports view.
  9. Find the Report: Inbound Delivery Detailed Line Items (Report ID: SCMCIDB03_Q0001).
  10. Open the Report and enter the relevant Ship-to Location and Product ID.
  11. Click Apply to execute Query.
  12. The system returns a result which is at discrepancy with the Quantity received in the above mentioned Inbound Delivery.

Cause

You have not activated the Row "Inbound Delivery Item ID".

Resolution

The system is behaving as designed. To see all Quantity of the relevant Product in the Report, please activate the "Inbound Delivery Item ID" row. Please follow the steps below to do this:

  1. Go to the Business Analytics work centre.
  2. Go to the Design Reports view.
  3. Find the Report: Inbound Delivery Detailed Line Items.
  4. Open the Report and enter the relevant Ship-to Location and Product ID.
  5. Click Apply to execute the Query.
  6. Please click the View button and click the Add Row + symbol beside Add Row Fields.
  7. Please find "Inbound Delivery Item ID" in the Row Selection screen, tick the checkbox.
  8. Click the Ok button and execute the Query again.
  9. Now you should see all the Line Items of the Inbound Delivery containing the Product appear with the correct Quantity.

Keywords

Inbound Delivery, Report, Inbound Delivery Item ID , KBA , AP-IDP-CID , Confirmed Inbound Delivery , AP-SDM-MSD , Material Supply and Demand View , How To

Product

SAP Business ByDesign all versions