SAP Knowledge Base Article - Public

2899152 - The data of Report: Sales Order Volume with Price Components or Customer Invoice Volume with Price Components is incorrect

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.

  1. Go to Sales Orders Work Center, Reports View
  2. Open the standard Report: Sales Order Volume with Price Components
  3. Set the value of Employee Responsible as blank
  4. In View setting, set "Sales order" in row fields, set "Net Value" and "Price Component" in Column Fields
  5. 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)
  6. 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

KBA 1.png

How to set the Inactivity Reason code to NOT Assigned

KBA 2.png

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

Product

SAP Business ByDesign all versions