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

Target Industry

Any

· 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

403254 – Distribution rules for rounding difference adjustment

2444170 – Tax determination in ERP SD – Guided Answers

Assigned Tags

You must be Logged on to comment or reply to a post.

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.

Anurag Mehta
Blog Post Author

Try with copy control , price without change (copy price)