SAP Knowledge Base Article - Public

2596856 - How Rounding Off Works For Net Value And Net Price In Sales Order

Symptom

You find Net Value calculated in Sales Order doesn't match the calculation formula as:

Quantity * Net Price = Net Value.

For Example:

  • List Price= 1.27 JPY
  • Quantity = 7 EA
  • Discount= 38%
  • Net Price= 0.79 JPY
  • Net Value= 5.51 JPY.

You expect a Net Value as 5.53 JPY [7 * 0.79 JPY].

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 XYZ (XYZ represents the respective Sales Order ID).
  4. Click the View All button.
  5. Navigate to the Items tab.
  6. Find the following values: Quantity, Net Price and Net Value.

When calculating the Net Value as follows:

  • Quantity * Net Price = Net Value
    [7 EA * 0.79 JPY = 5.53 JPY]

OR

  • The Net Price for the same item with the same Discount but different quantities is different for 1 item.

Cause

The calculation of Net Price and Net 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.
    [7*1.27 JPY= 8.89 JPY]

  • Total List Price * Discount in % = Discount Value (rounded to 2 decimals)
    [8.89 JPY * 0.38 = 3.3782 JPY rounded to 3.38 JPY]

  • Total List Price (rounded to 2 decimals) – Discount Value (rounded to 2 decimals) = Net Value
    [8.89 JPY – 3.38 JPY = 5.51 JPY]

  • Net Value / Quantity = Net 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.
    [5.51 JPY / 7 = 0.7871428571428571 JPY rounded to 0.79 JPY ]

This is aimed to minimize the difference between the rounded value with the actual value.

The Total is then calculated as follows:

  • Tax Base Amount considers quality loss fee, surcharge and freight etc.
  • Tax Base Amount * Tax Rate % = Tax Amount (rounded to 2 decimals)
  • Net Value + Tax Amount = Total

Resolution

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.

Keywords

Rounding, Net Value, Net Price, Preise, Rundungsdifferenz, Stückpreis, Netto, Nettowert, Nettopreis, Kundenauftrag , KBA , AP-SLO , Sales Order Processing , AP-SLO-SO , Sales Order , How To

Product

SAP Business ByDesign 1902 ; SAP Business ByDesign 1905 ; SAP Business ByDesign 1908 ; SAP Business ByDesign 1911