Symptom
You find Gross Price calculated in Sales Order is not expected.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Orders work centre.
- Select the Sales Orders view.
- Open Sales Order ABC (ABC represents the respective Sales Order ID).
- Click the View All button.
- You can see Price In: Gross
- Navigate to the Items tab.
- Find the following values: Quantity, Gross Price and Gross Value.
- List Price= 117.841,40 CNY
- Quantity = 550 XYZ (where XYZ stands for the custom UoM)
- Discount= -13,339%
- Gross Price= 102.122,55 CNY
- Gross Value= 51.000,00 CNY
8. Open Base Price List (Gross), search for Product EFG (EFG represents the respective Product ID)
It is maintained as Amount 117.841,40 CNY for 10.000 kg
9. Open Product: EFG
The Quantity Conversion: 1 XYZ = 9,08 kg
Cause
The calculation of Gross Price and Gross Value follows a certain calculation schema using the assigned currency of the number of decimals and Rounding Value.
This can be found by following the steps as below:
- Go to the Business Configuration Work Center.
- Choose respective Implementation Project.
- Click Open Activity List and go to the Fine-Tune sub-tab.
- Show All Activities and find Currencies.
Based on the assigned currency rules, the System calculates the values as follows [please follow the Example in brackets too]:
- Quantity * List Price (for quantity 1 not rounded) = Total List Price (rounded to 2 decimals). Please note that in case of a quantity conversion between the Sales Unit of Measure and the List Price Unit of measure, the List Prices needs to be converted to the Sales Unit of measure fist.
[550 * 9.08 = 4994
117.841,40 / 10.000 =11,78414
List Price=4994*11,78414=58850]
- List Price * Discount in % = Discount Value (rounded to 2 decimals)
[58850 * 13,339% = 7850]
- List Price – Discount Value (rounded to 2 decimals) = Gross Value
[Gross Value = 58850 - 7850 = 51000]
- Gross Value / Quantity = Gross Price (rounded to 2 decimals). Please note that this net price is for quantity 1 of the sales unit of measure. If there is a quantity conversion for the List Price Unit of measure this has to be taken into consideration.
[(51000(Gross Value) * 10000(Quantity List Price) / (Quantity 550 *9.08) = 102122.5470 (rounded to 2 decimals) = 102122.55. ]
Resolution
This is the current system behavior.
If you want to change the Display Decimals or the calculation formula, it is a system change request and has to be submitted in Customer Influence Portal - SAP Business ByDesign.
See Also
KBA 2596856 - How Rounding Off Works For Net Value And Net Price In Sales Order
Keywords
Rounding, Gross Value, Gross Price, Discount, Quantity Conversion, Quantity List Price , KBA , AP-PRC-PC , Calculation , Problem