SAP Knowledge Base Article - Public

2920741 - Invoiced Amount and Invoiced Quantity Key Figures Are Appearing as 0.00 in Sales Order Volume Report

Symptom

Invoiced Amount and Invoiced Quantity Key Figures Are Appearing as 0.0 in Sales Order Volume Report for some Sales Orders and you expect to see value there

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Search for the Sales Order Volume report.
  4. Open it.
  5. Run the report.
  6. Use as Row Fields: Sales Order Key Figure.
  7. Use as Column Fiels: Invoiced Amount and Invoiced Quantity Key Figures.
  8. 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 status Inpreparation, Open or In Process show the value as 0.00.
  • Sales Orders which are in status Completed show the value as expected - this behavior does not apply for cancelled Sales Orders.

Resolution

This is the expected behavior.

Once the Sales Order 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 , KBA , SRD-CRM-ORD , Orders & Contracts , AP-SLO-SO-ANA , Analytics , How To

Product

SAP Business ByDesign all versions