Incorrect subtotal on invoice

[Former Member]

Hello Friends,

I have an invoice showing incorrect totals. Customer is furious.

On eash line item on the invoice, when I multiplied the quantity by the pricing, the total values are always off by about 2 - 5 pence. Which is cummulative on the subtotal.

e.g. quantity is 10, price is 395.45, the total is showing 3,954.59

It seems to be isolated to only this customer and this seems to be the first occurence of something like this.

How do I rectifty this ?

BTW, I searched the forum to see if there were previous threads that addressed similar issues but didn't find one.

[Former Member · Accepted solution]

This sounds like the usual SAP rounding problem. Do you have discounts forming part of your pricing ??

SAP discounts at the extended value level, not at unit price so if you use discounts you can get anomalies :

11 @ 2.23 = 24.53

less 12.6% = (3.09)

Total = 21.44

so unit is 21.44 / 12 = 1.94909 which us rounded to 1.95

But 12 * 1.95 = 21.45 ..... whereas the invoice shows 12 * 1.95 = 21.44

See OSS note 80183.

Regards,

Brian

[Former Member · Accepted solution]

Thanks guys..all of the suggestions were quite helpful in bringing this to resolution.

The rounding problem I found was actually resolved a while back but the resolution was not migrated into production.

But the suggestions helped in identifying that there was a similar one in place.

Thanks again

Cheers

[Former Member]

hello

it seems that you have erron in PRICING

when material is packing in 100 , 20, 50 ... and sales price is calculate on this

you get in pricing wrong values

example

position price q. q. * price invoice

1 320,39 82 26271,98 26271,60

2 241,95 93 22501,35 22501,42

3 42,54 104 4424,16 4424,24

4 35,89 25 897,25 897,34

5 5377,42 10 53774,20 53774,23

6 594,24 12 7130,88 7130,90

7 52,51 4 210,04 210,05

8 141,58 19 2690,02 2690,04

[Former Member]

You can use the functionality of NETP - Rounding Adjustment for this purpose in your pricing Procedure

In your pricing procedure Next to Discount Amount Line

Have Discounted List Pirce

And then in immdeiate next line have NETP - Rounding Adjustment.

Net Value = Discounted List Price + Rounding Adjustment.

This will clear the rounding confusion in Invoice. In our last project we used this and it worked out well

Copy controls from Order/Delivery to Invoice Maintain Pricing Type as Copy Pricing unchanged and redetermine taxes.

Regards

Sai