SAP Knowledge Base Article - Public

2757954 - In the report invoice volume the freight is missing.

Symptom

You run the report Invoice Volume (CRMCIVIB_Q0001) the key figure Freight shows the value zero.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the view Design Report.
  3. Open the report Invoice Volume (CRMCIVIB_Q0001).

You see the key figure Freight shows the value zero.

Cause

This report only shows the freight if it was added to the preceding sales order items.

Resolution

To check that follow the below steps.

  1. Go to the Customer Invoicing work center.
  2. Go to the view Invoice Document. 
  3. Search for the affected invoice and open.
  4. View All and select the tab Document Flow.

You can see that no sales order was added to this invoice and the same happens with other invoices not showing freight in the report Invoice Volume (CRMCIVIB_Q0001).

Alternatively you can use the report Customer Invoice Volume with Price Components with the Report ID: CRMCIVIPATCB_Q0001

This report shows the values in customer invoices. By default, the year-to-date net values for the current year are displayed. along with details about the price components like price, discount, freight, surcharge, goodwill, warranty, quality loss fee, cost estimate, profit margin. also provides information like is the price component is manually changed or automatically determined, what prices are proposed by the system and which is the active price, base value of each price component calculation for price, discount, freight, surcharge. Calculation of total discount , total tax value .

Keywords

Report invoice volume, CRMCIVIB_Q0001, freight, Sales Order, Key Figure, AP-RC-ANA; Price Components; Freight , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , SRD-CRM-ORD , Orders & Contracts , How To

Product

SAP Business ByDesign all versions