2899152 - The data in the "Sales Order Volume with Price Components" or "Customer Invoice Volume with Price Components" report is incorrect

The fields "Value of Cost", "Net Profit Margin", "Net Profit Margin (%)", "Gross Total", "Gross List Price" have the same value in the report: Sales Order Volume with Price Components or Customer Invoice Volume with Price Components.

SAP Business ByDesign

This issue can occur in either Sales Order Volume with Price Components or Customer Invoice Volume with Price Components. To view Sales Order Volume with Price Components report, follow the steps below:

1. Go to Sales Orders Work Center.
2. Select the Reports View.
3. Open the standard report Sales Order Volume with Price Components.
4. Set the value of Employee Responsible to blank.
5. In the View Settings, set "Sales Order" as the Row Fields and "Net Value" and "Price Component" as the Column Fields.
6. The report shows the same value, XYZ (where XYZ represents the amount), for the following fields: Value of Cost, Net Profit Margin, Net Profit Margin (%), Gross Total, and Gross List Price.
7. However, these fields have different values in the corresponding Sales Order.

The issue was identified as being caused by an incorrect configuration of the Sales Order Volume with Price Components report. 

The Price Component field was not a key value in the Column Fields. Adding Price Component as a key field in the Column view resulted in an ambiguous view and caused the report to display incorrect values.

To obtain the correct view, right-click Price Component and select Move to Rows.

Additionally, the following fields must be fulfilled to obtain the correct Price Components

• Effective Indicator: True
• Inactivity Reason Code: NOT Assigned (indicating that the price is active)

How to Set the Effective Indicator to True

How to Set the Inactivity Reason Code to NOT Assigned

This will provide the correct and desired view of the Price Components.

Sales Order Volume with Price Components; key value; Column Field; Customer Invoice Volume with Price Components; Incorrect; Wrong; Amount , KBA , AP-PRC-PC , Calculation , Problem