Skip to Content
Sep 01, 2009 at 02:51 AM

Line Total has decimals value differences


Hi All,

The Decimal Places setup for Price and Amount are set to 2.

I have an sales quotation (same for other sales and purchase documents) with any item.

Eg. Item ABC

Qty 6.00

Unit Price (bef Disc) SGD 63.68

Item Discount 70.01

Price After Discount SGD 19.10

Line Total (sys calc) SGD 114.59

It seems that the system is using Unit Price (bef Disc) x (100 - Item Discount) / 100. It gives Price After Discount as SGD 19.10. This is correct.

But the Line Total is SGD 114.59.

The Line Total should be SGD 114.60 <-- (qty 6 x SGD 19.10)

The printout and display shows such differences.

Please advise on how I can get the system to show 114.60 rather than 114.59 (since I have already set the amount decimal to 2).