Symptom
For specific currencies such as Swiss Franc (CHF), Swedish Krona (SEK) or Indian Rupee (INR) , the system performs the rounding of the total amount in a business document when pricing is executed on header level, for example, when saving a document.
When amounts in these specific currencies are rounded, the resulting rounding difference is distributed to the items of the business document with the below standards:
- SEK is rounded to the next full SEK,
- CHF is rounded to the next 5 centimes
- INR is rounded for using one decimal case.
If it is partially invoiced business documents, this can lead to a difference between the sum of the partial invoices and the predecessor business document.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Create a sales order with a business partner that uses the currencies listed (CHF, SEK or INR).
- Add the materials.
- Go to the item level and check the pricing conditions tab.
- See the DRD1 Condition created.
Cause
In the pricing procedure, condition type Rounding Off (DRD1) is used with routine 16 (Rounding the total) in the Alternative Calculation of Condition Amount field. This causes the total amount of the document header to be rounded for certain currencies.
This is automatically determined by the system.
Resolution
Example
A billing document with currency CHF has two items. The amount of the first item is CHF 6.10, the amount of the second item is CHF 6.50. The tax rate is 7.7%. The total amount of the document is calculated as follows:
- The calculation of the total tax amount: (0.077 * CHF 6.10) +(0.077 * CHF 6.50) = 0.9702 = CHF 0.97
- The total amount is calculated as sum of the item amounts and the total tax amount: CHF 0.97 + CHF 6.10 + CHF 6.50 = 13.5702 = CHF 13.57
Finally, for CHF, the system rounds this total amount CHF 13.57 up or down to the next 5 centimes, which results in CHF 13.55.
In this example, the rounding difference is CHF 2 centimes (CHF 0.02). If the calculation type of DRD1 is Fixed Amount (B), the system distributes this difference as follows:
Item 1: CHF -0.02 * (6.10 / 13,57) = 0,00899… = CHF -0.01
Item 2: CHF -0.02 * (6.50 / 13,57) = 0,00957… = CHF -0.01
Accordingly, the net amount of item 1 is CHF 6.09, and the net amount of item 2 is CHF 6.49.
Keywords
Rounding Off, DRD1, net amount, SEK, CHF, INR, standard, pricing, condition, currency, rounded, , KBA , SD-BF-PR-2CL , Pricing (Public Cloud) , How To
SAP Knowledge Base Article - Public