Symptom
Missing values for the key figure "Invoiced Amount" in the Sales Order Volume report.
For Sales Order ABC, no invoice amounts are displayed, even though the sales order being in the "In Process" status.
For Sales Order ID DEF, values are displayed in the "Invoiced Amount" key figure, despite the sales order being in the "In Process" status.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to the Design Reports view.
- Search for the Sales Order Volume report.
- Open it.
- Run the report.
- Select Sale Order ABC and DEF
- Use as Row Fields: Sales Order Key Figure.
- Use as Column Fields: Invoiced Amount and Invoiced Quantity Key Figures.
- The report will update.
For Sales Order DEF it's able to see value for Invoiced Amount and Invoiced Quantity fields, however, Sales Orders ABC, the value appear as 0.00 (zero) in the same status.
Cause
- Sales Orders which are in status Completed show the value as expected - this behavior does not apply for cancelled Sales Orders.
- For the Sales Order DEF, some line items have been invoiced, while others remain in the "In Process" state. This results in the report not showing the total invoice amount and total quantity for the sales order.
For the Sales Order ABC, none of the line items have been invoiced, which is why it does not appear in the report.
Resolution
The report displays partial values because some line items have been invoiced, while others remain in the "In Process" state. The report does not reflect the total invoice amount and total quantity until all line items are invoiced.
Please ensure that at least one line item is fully invoiced which the invoice status will change to "Finished" for the sales order to appear in the report.
No further action is required if the behavior aligns with the system's standard design.
This behavior aligns with the system's standard design.
Keywords
missing invoiced amount, sales order volume report, CRMSLOIB_Q0001, invoiced quantity, report missing value, invoiced amount key figure, sales report issue, line items invoiced , KBA , AP-SLO-SO , Sales Order , Problem
SAP Knowledge Base Article - Public