You run the report Invoice Volume (CRMCIVIB_Q0001) the key figure Freight shows the value zero.
SAP Business ByDesign
Reproducing the Issue
Go to the Business Analytics work center.
Go to the view Design Report.
Open the report Invoice Volume (CRMCIVIB_Q0001).
You see the key figure Freight shows the value zero.
This report only shows the freight if it was added to the preceding sales order items.
To check that follow the below steps.
- Go to the Customer Invoicing work center.
- Go to the view Invoice Document.
- Search for the affected invoice and open.
- 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 .
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