Symptom
You find that these 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.
Environment
SAP Business ByDesign
Reproducing the Issue
This issue can occur in either Sales Order Volume with Price Components or Customer Invoice Volume with Price Components. We will use Sales Order Volume with Price Components as an example here.
- Go to Sales Orders Work Center, Reports View
- Open the standard Report: Sales Order Volume with Price Components
- Set the value of Employee Responsible as blank
- In View setting, set "Sales order" in row fields, set "Net Value" and "Price Component" in Column Fields
- You can see that these fields "Value of Cost", "Net Profit Margin", "Net Profit Margin (%)", "Gross Total", "Gross List Price" have the same value XYZ (where XYZ stands for amount)
- But in the sales order, these fields have different value
Cause
It has been identified to be a wrong configuration of the Report: Sales Order Volume with Price Components.
The field 'Price Component' is not a key value in the Column Fields. So adding it to the key field in Column view resulted in the ambiguous view.
Resolution
To get the proper view you can right click on the options of 'Price Component' and click on 'Move to Rows'.
Also, the following fields must be fulfilled to get the proper view of Price Components
- Effective indicator to: True.
- Inactivity Reason code to NOT Assigned (meaning the price is active).
The steps to set is the following
How to set the Effective indicator to: True
How to set the Inactivity Reason code to NOT Assigned
This will give the proper desired view.
Keywords
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