Symptom
Invoiced Amount and Invoiced Quantity Key Figures are appearing as 0.0 in Sales Order Volume Report for some Sales Orders. However, there should be values in these fields.
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.
- Use as Row Fields: Sales Order Key Figure.
- Use as Column Fields: Invoiced Amount and Invoiced Quantity Key Figures.
- The report will update.
For some Sales Order it's able to see value for Invoiced Amount and Invoiced Quantity fields, however, for other Sales Orders, the value appear as 0.00 (zero).
Cause
- Sales Orders with invoice status "In Preparation", "Open" or "In Process" show the value as 0.00.
- Sales Orders which are in invoice status "Completed" show the value as expected - this behavior does not apply for cancelled Sales Orders.
Resolution
This is the expected behavior.
Once the invoice is completed, the value in the fields Invoiced Amount and Invoiced Quantity fields will appear as expected in the report.
Keywords
Invoiced Amount, Invoiced Quantity, Sales Order, Report, Invoice Status, Invoice Status In Line Item , KBA , SRD-CRM-ORD , Orders & Contracts , AP-SLO-SO-ANA , Analytics , How To
SAP Knowledge Base Article - Public