SAP Knowledge Base Article - Public

3314984 - How Rounding Off Works For Gross Value And Gross Price In Sales Order

Symptom

You find Gross Price calculated in Sales Order is not expected.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Sales Orders work centre.
  2. Select the Sales Orders view.
  3. Open Sales Order ABC (ABC represents the respective Sales Order ID).
  4. Click the View All button.
  5. You can see Price In: Gross
  6. Navigate to the Items tab.
  7. 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:

  1. Go to the Business Configuration Work Center.
  2. Choose respective Implementation Project.
  3. Click Open Activity List and go to the Fine-Tune sub-tab.
  4. 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

Product

SAP Business ByDesign all versions