SAP Knowledge Base Article - Public

3212908 - Invoiced Quantity (Sales Unit of Measure) does not show the quantity from the Customer Invoice

Symptom

Invoiced Quantity (Sales Unit of Measure) in invoice volume report does not show the quantity from Customer Invoice PQR(PQR stands for Invoice ID)

Environment

SAP Business ByDesign

Reproducing the Issue

1.Go to Customer Invoicing work center.

2.Navigate to Reports View.

3.Open Invoice Volume Report

4.In the View section, add the field "Invoice Quantity(Sales unit of measure)" in row fields

5.Filter for invoice PQR. You can see the "Invoice Quantity(Sales unit of measure)" shows "XXX abc" (XXX stands for quantity and abc stands for unit of measure)

6.But in the invoice: PQR, the value is "YYY abc" (YYY stands for quantity)

Cause

The field Invoiced Quantity (Sales Unit of Measure) in the Invoice Volume Report CRMCIVIB_Q0001 uses the Data Source Sales Order Item (CRMSLOIB) to retrieve the Invoiced Quantity (Sales Unit of Measure) (key Figure IAV_INV_QTY_SU). This retrieves the Invoiced Quantity of the Sales Order Item and not the Invoiced Quantity of the Invoice in Question.

If for e.g. a sales order item is only partially invoiced, the partially invoiced quantity would be displayed as the value for field Invoiced Quantity (Sales Unit of Measure).

Resolution

Filtering for a particular invoice in this report does not have any impact on this field.

This is how the report is currently designed.

If you wish to only display the Quantity in the Invoice you could create a custom Report

There is a field in the CRMCIVIB report that will pull in the invoice data, this is the Invoice Document Quantity (Sales Unit of Measure) which you could use.

Keywords

invoice volume report, invoice volume, report, Invoiced Quantity, Sales Unit of Measure, Invoiced Quantity (Sales Unit of Measure), quantity , KBA , invoice volume , invoiced quantity , sales unit of measure , quantity , invoice volume report , SRD-CRM-INV , Customer Invoicing , Problem

Product

SAP Business ByDesign all versions