Skip to Content
0

Calculation after Discount is not matching Net Value

Feb 19 at 11:59 AM

69

avatar image
Former Member

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 left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Veselina Peykova
Feb 19 at 12:50 PM
1

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Veseline,

Basically you are correct but there are some business legal issues so i cant convenience them .

My user is applying this formula

NTP = TP - (TP * Discount %)

NTP = 441.86 - (441.86 * 0.06)

NTP = 441.86 - (26.5116)

NTP = 415.3484 here client is rounding to this 415.35

NOW = 415.35 * 200 = 83070

Waiting for your reply.

Thanks

0

Have you gone through the OSS notes referred here? Before posting further queries, please go through the OSS note where it has been recommended for configuration change. Try in your system by changing the configuration as recommended by SAP, create a test scenario and see how it works.

0

What does the user expect to see as amount in the subtotal? Is it 415.3484? Or is it something else?

And why this is a legal issue? If you use the subtotal amount in printouts - you can adjust the logic of the print form.

As https://people.sap.com/lakshmipathi.ganesan noted, you can implement the suggestions from 80183 if the expected outcome is to have net price* quantity = value.

If the user insists to see 415.3484 or 26.5116 in a pricing subtotal or condition, you cannot do it with PKR. You could store the non rounded result multiplied by some parameter in a statistical condition or subtotal, or if they are happy with just 4 decimals - force a suitable currency in the statistical condition+a formula. I would not go via this route unless this is unavoidable, because it is really difficult for many business users to understand and interpret the pricing result and on top of that they will start asking for report adjustments, which makes the change request rather expensive...

0
G Lakshmipathi
Feb 19 at 12:33 PM
1

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Lakshmipathi for the reply.

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 ???

Thanks in Advance

0