Product Information
Common issues in Rounding in Pricing and group condition rounding issues
In this blog post you will get to know about Issues related Rounding in Pricing and group condition rounding issues.
Usually in sales process many customers faces the issues for rounding, how system calculates and perform the rounding in various cases, it is observed that below are the common issues faced by many customers
Ø Billing document condition value is updated wrong, rounding issue
Ø Rounding difference is updated in one of the line item
Ø Rounding difference is updated only in last line item, even though same values are there in all the line item etc.
Ø Group condition type calculation process
Ø Issues in Tax value calculation
Blog Applicability
SAP S/4HANA Cloud Release |
2005 |
Target Audience
Business Users, Key Users, Consultants
Target Industry
Any
Business benefit
· Faster resolution of rounding issue
· Ease of monitoring rounding calculation
· How system calculates the rounding
· Difference between field KDIFF and condition type DIFF calculation
· Concept of Group condition type calculation
· Group condition helps in make rounding as small as possible
Issue details explained with example and calculation
What is a Rounding difference (field KDIFF)
Difference in group condition value , occurs when calculation of header and item level values , for the same group.
Only applicable for condition type where ‘RoundDiffComp’ checkbox is activated and without the use of the group key routine.
Example
At Header Level 20% Discount for a group condition
Header |
Total QTY |
Percentage 20% |
Item Value |
7.57 |
1.514 |
1.51 |
|
|
|
|
At Item level
Item |
Line item |
QTY |
Percentage 20% |
Item Value |
10 |
2.19 |
0.438 |
0.44 |
|
20 |
5.38 |
1.076 |
1.08 |
|
Total |
|
|
|
1.52 |
Now the different in total value from header (1.51) to item (1.52) = 0.01-
If there is a difference this difference (the so-called rounding difference (field KDIFF)) is added to one of the item condition values so the total of the item condition values corresponds to the condition value calculated on document level .
The system displays the rounding difference in the affected condition detail.
Distribution of Rounding difference (field KDIFF)
- Rounding difference is added to the item whose condition has the absolute largest condition value (technically KWERT) in this group (as per example, in line item 20 , so as to ensure no difference between header and item level calculation)
Item |
Line item |
QTY |
Percentage 20% |
KDIFF |
Item Value |
10 |
2.19 |
0.438 |
|
0.44 |
|
20 |
5.38 |
1.076 |
0.01- |
1.07 |
|
Total |
|
|
|
|
1.51 |
- If Condition values of a group are equally, the rounding difference adjustment is assigned to the last item in the group
- If all condition values are equal to zero, the rounding difference adjustment is now added to the item of a group that has the absolute largest condition basis (technically KAWRT).
What is Condition type DIFF?
Total value of the document to be rounded.
Example: the total value must be divisible by 0.05
Item |
Total QTY |
Rate |
Item Value |
|
1 |
151 |
151 |
Net Value = 151 |
|
|
|
|
|
|
Tax |
|
3% |
4.53 |
Tax= 4.53 |
Total Value |
|
|
155.53 |
Total Value = 151+ 4.53 = 155.53 |
Diff |
|
|
0.03 |
Rounding till 0.05 = 155.50, thus Diff = 0.03 |
System adjust the net value to ensure the TAX is not affected, thus condition type DIFF value is added with net value = 151+ (0.03-) = 150.93
Net value (inclusive of Diff condition type) = 150.93 and tax 4.53, Total = 155.30
Item |
Total QTY |
Rate |
Item Value |
|
1 |
151 |
150.97 |
151- 0.03 = 150.93 |
|
|
|
|
|
|
Tax |
|
3% |
4.53 |
Tax= 4.53, Same |
Total Value |
|
|
155.50 |
Total Value = 150.93+ 4.53 = 155.50 |
Diff |
|
|
0.03 |
|
Example for DIFF = group condition
Item |
Total QTY |
Rate |
Item Value |
TAX 3% |
Total Value |
1 |
151 |
151 |
4.53 |
155.53 |
|
1 |
143 |
143 |
4.29 |
147.29 |
|
Total |
|
|
294.00 |
8.82 |
302.82 |
Diff |
|
|
|
|
0.02- |
DIFF Calculation
Values after Calculation of DIFF
Example for DIFF = no group condition
DIFF Calculation
Values after Calculation of DIFF
Related SAP Note / Links
1472505 – Unexpected tax condition value in item of saved document or billing document.
39034 – Group condition routine
1158475 – Rounding differences: Field KDIFF versus condition type DIFF
2537490 – Rounding difference adjustment, group key routine, cumulated scale base value
403254 – Distribution rules for rounding difference adjustment
2444170 – Tax determination in ERP SD – Guided Answers
https://ga.support.sap.com/dtp/viewer/#/tree/390/actions/4031:4034
Good document
151- 0.03 is actually 150.97
The issue is there is a difference between the Sales order and the billing document. the rounding is on the net price condition. the sales order has 247.46 while the billing document has 247.47.
Please do you know how i can fix this?
Thanks very much for your help.
Try with copy control , price without change (copy price)