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
- Go to Customer Invoicing work center.
- Navigate to Reports View.
- Open Invoice Volume Report CRMCIVIB_Q0001.
- In the View section, add the field "Invoiced Quantity(Sales unit of measure)" in row fields.
- Filter for invoice PQR.
You can see the "Invoiced Quantity(Sales unit of measure)" shows "XXX abc" (XXX stands for quantity and abc stands for unit of measure).
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