Pricing rounding Error

[Former Member]

Dear Guru's,

Total amount is not matching with the per unit price * order Qty. in the invoice / output due to rounding off.

we are using commercial rounding rule for the condition types. System is calculating correct value as per the rounding rule in condition value column and in amount column.

But if we see the final invoice then the Total amount is not equal to per unit price * Qty.

Please refer the below screen shot for batter understanding. Kindly advice how to get the correct price.3

[Lakshmipathi · Accepted solution]

System has calculated as follows which I feel is correct:-

G. Lakshmipathi

[Shiva_Ram]

Check OSS note  80183 - Rounding

Regards,

[srinu_s1]

What the system calculating is correct which is already confirmed by seniors.

System calculate the discount only condition value not on condition amount(1493.10*6%=89.586 and it rounded upto two decimals that is 89.59 which is correct.And the net value also 1493.10 - 89.59 = 1403.51 is also correct.

thanks,

Srinu.

[od_manikandan]

This message was moderated.

[former_member183879]

Hi Shabareesh,

I also checked this and what Lakshmi says is correct.

One additional point though:

Any rounding during pricing happens only ON CONDITION VALUE AND NOT ON CONDITION RATE field.

So in your case, the base price field will be

149.31  * 10 = 1493.10

Now the discount of 6% is calculated on 1493.10 and not on 149.31 (i.e. on condition value and not on the condition rate of the dependent condition type)

So in this case 1493.10 * 6% = 89.586 which when rounded will become 89.59

So net price will be 1493.10 - 89.59 = 1403.51

The calculation is correct. I dont see any problem