Common issues in Rounding in Pricing and group condition rounding issues

[Anurag_Mehta]

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

[AbhijitP]

Good document

151- 0.03 is actually 150.97

[former_member750320]

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]

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