Former Member

# Calculation after Discount is not matching Net Value

Hi All,

I have a requirement in which user required below Value. SAP is showing some difference.

As per SAP Standard system shows 83069.68

But when user Calculates Total Net Price with qty then 415.35*200(QTY) = 83070.00

Now here i am facing issue i am not getting desired result as per user.

Need help how to resolve this issue. Thanks

10|10000 characters needed characters exceeded

• Posted on Feb 19, 2018 at 12:33 PM

It is because, system has considered the value of 6% as 26.5116 (441.86*6/100) which comes to 415.3484 and if you multiply by 200, it comes to the value what you have shared. Have a look at OSS note 80183 which explains in detail on how rounding works.

10|10000 characters needed characters exceeded
• Former Member

Any suggestion apart from OSS note 80183 because i am not able to find any code(routine). If i get the code i will apply in condition base value. Can we resolve this issue if we change this 26.5116 into 26.51 ???

• Posted on Feb 19, 2018 at 12:50 PM

I see nothing wrong with the calculation and the setup - you just need to explain to the business user how pricing works in SAP and also a little bit about decimals in currencies.

441.86 *200 = 88 372.00 -> you ask the user: "Do you agree with this?"

-6% * 88 372.00 = -5 302.32 -> you ask him again: "You know that this is correct as well, right?"

Then you say: 88 372.00 - 5 302.32 = 83 069.68 -> you say: "This one is also correct, isn't it?"

Now, if you refer to note 791944 - How is the KBETR determined in a subtotal? you will be able to explain that the amount in the subtotal is the subtotal value (83 069.68) divided by the condition basis (200) which, if you use a calculator, will result in 415.3484. Yes, but we have only two decimals for PKR and when you apply rounding you end up with 415.35.

If the user still does not agree with you - ask him/her to write down for you in Excel an arithmetically correct calculation of base price, discount and subtotal for the amount and the value and use two decimals (with formulas).

Of course, it is technically possible to modify values and amounts in subtotals via routines, but most likely there is no need for that in your case.