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]:

  • List Price * Discount in % = Discount Value
    [1.27 JPY * 0.38 = 0.4826 JPY]
  • Quantity * Discount Value (not rounded) = Discount Quantity Value (this value is rounded to 2 decimals)
    [7 EA * 0. 4826 JPY = 3.3782 JPY rounded to 3.38 JPY]
  • Quantity * List Price = Total List Price (this value is rounded to 2 decimals)
    [7 EA * 1.27 JPY = 8 89 JPY rounded to 8 89 JPY]
  • Total List Price – Discount Quantity Value = Net Value
    [8.89 JPY - 3.38 JPY = 5.51 JPY]
  • Net Value / Quantity = Net Price (this value is rounded to 2 decimals)
    [5.51 JPY / 7 = 0.787... JPY rounded to 0.79 JPY]

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

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