Symptom
This SAP Note explains the relevant sources for rounding of prices and the hierarchy between sources in SAP Business One system.
Reproducing the issue
Currently in SAP Business One, three parameters affect the display of prices and rounding in price lists:
- Administration → Setup → Financials → Currencies → Decimals (decimals),
- Inventory → Price Lists → Price Lists → Rounding Method (price list rounding method),
- Administration → System Initialization → General Settings → Display tab, Prices field (general settings default decimals display).
If the decimals field (number 1 above) is defined as ‘Default’, then the prices in the price list for the same currency are rounded according to the price list rounding method (number 2 above), combined with the general settings default decimals display (number 3 above).
If the decimals field (number 1 above) is defined differently than ‘Default’, then it is regarded as a specific definition for the same currency and is considered the highest priority. In this case, the prices in the price list are rounded according to the decimals definition (number 1 above).
Changing the decimals definition (number 1 above) affects prices in the price list only after an active update of the price list.
Example 1:
- Define decimals for USD currency as ‘Default’ (Administration → Setup → Financials → Currencies).
- Define General Settings default Display as 2 digits (Administration → System Initialization → General Settings → Display tab → Prices field).
- Create price list ‘A’ with prices in USD currency (Item ‘A1’ = USD 2.35).
- Create price list ‘B’ based on price list A; set factor as 2 and specify the price list rounding method as ‘Round To Full Amount’.
- Check the prices in price list B.
Actual result: the prices are rounded according to the price list rounded method to the full amount (Item ‘A1’ = USD 5).
- Choose Administration → Setup → Financials → Currencies and set decimal places to a value other than the default (for example, 2 digits) for USD currency.
- Open price list B.
Actual result: prices remain as they are with no change.
Change the price list rounding method for price list B to ‘No Rounding’ and choose the Update option; then change the value back to ‘Round To Full Amount’, and choose the Update option.
Actual result: prices in price list B are rounded according to the new decimals definition of 2 digits (Item ‘A1’ = USD 4.70).
Example 2:
- Define decimals for USD currency as ‘Without Decimals’ (Administration → Setup → Financials → Currencies).
- Create price list ‘A’ with prices in USD currency (Item ‘A1’ = USD 1).
- Create price list ‘B’ based on price list A; set factor as 1.6 and specify the price list rounding method as ‘Round To Full Decimal Amount’.
- Check the prices in price list B.
Actual result: prices are rounded according to decimals definition ‘Without Decimals’ (Item ‘A1’ = USD 2).
- Choose Administration → Setup → Financials → Currencies and set decimal places as ‘Default’ for USD currency.
- Open price list B.
Actual result: prices remain as they are with no change.
Change the price list rounding method for price list B to ‘No Rounding’ and choose the Update option; then change the value back to ‘Round To Full Decimal Amount’, and choose the Update option.
Actual result: Prices in price list B are rounded according to the combination of price list rounding method ‘Round To Full Decimal Amount’ and the general settings default decimals display, as follows:
- General Settings → Prices Decimal Display 0 (Item ‘A1’ = USD 2)
- General Settings → Prices Decimal Display 1 (Item ‘A1’ = USD 1.6)
- General Settings → Prices Decimal Display 2 (Item ‘A1’ = USD 1.60)
- General Settings → Prices Decimal Display 3 (Item ‘A1’ = USD 1.600)