[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Tax rounding error in 1.2.4
- Subject: Tax rounding error in 1.2.4
- From: ..hidden..
- Date: Fri, 27 Apr 2007 20:51:24 +0100
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.