[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Tax rounding error in 1.2.4



Hi all,

I've just loaded the first invoice, and hit upon the first problem. Not sure if this one has been reported already, so here goes.

I loaded the UK default chart of accounts.

Create sales invoice . Two lines on the invoice (both services): item 1 has a qty of 121 @ £35 ea, item 2 a qty of 13 @ £25 ea. Both are taxable at 17.5%.

If I look at the invoice on-screen, I see a subtotal of £4,560 (comprising 35*121 + 25*13), with a VAT element of £798, making a total of £5,368. This is what I expect. My calculator tells me so, and so does the back of an envelope.

If I then run a GL report, I see that the credit to account 2200 is actually £798.01. Yet if I select the invoice I see that the tax is £798.

Off I toddle to the database to find that for this invoice:
ar.amount is 5358.01
acc_trans.amount for the tax element is 798.01

I am reminded of the old Pentium joke ("We are Pentium of Borg: Arithmetic is irrelevant. Division is futile. You will be approximated."). Not sure whether I'm more disturbed about the rounding error or about the fact that calling up the invoice from the web interface is giving me a number which doesn't appear in the GL report or, as far as I can make out, in the database.

Cheers,
Richard

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.