3742289 - How to Exclude Freight from Net Value in Invoice Volume Report.

In the Invoice Volume Report, the Invoice Net Value for each Product includes the Freight.

You expect it to be without Freight Value added with Invoice Net Value.

SAP Business ByDesign

1. Go to Customer Invoicing Work center
2. Click on Reports View
3. Open the Report Invoice Volume (CRMCIVIB_MQ0001)
4. Execute the Report
5. Navigate to the View
6. In the Rows add the fields
   Invoice
   Month/Calendar Year
   Product
7. In the Column Fields add the Key figure
   Invoiced Net Value

Observe that the Net Value includes Freight Value.

This is an expected behavior.

The calculation elements of the key figure "Invoiced Net Value" under Invoice Volume Report takes all rebates, discounts, freight, or any other credits/adjustments into consideration.

As a workaround to filter the values excluding freight, you can add the field "Net Value without Freight" under the Sales Order Item section in the Rows of the Invoice Volume Report as follows.

1. Go to Customer Invoicing Work center
2. Click on Reports View
3. Open the Report Invoice Volume(CRMCIVIB_MQ0001)
4. Execute the Report
5. Navigate to the View
6. In the Rows add the fields
   Invoice
   Month/Calendar Year
   Product
   Net Value without Freight under the Sales Order Item section

     7. In the Column Fields add the Key figure
         Invoiced Net Value

NOTE: The Invoiced Amount and Net Value Without freight field values in the Invoice Volume Report actually fetches its values from the corresponding Sales Order and not the Invoices.

Invoice Volume Report; Freight; without freight; sales Order; Invoices , KBA , SRD-CRM-INV , Customer Invoicing , How To