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

Re: Tax rounding error in 1.2.4



Thanks Chris,

I've been futzing around with perl (I feel unclean). I was wondering if you had considered the Math::Currency module for currency calculations? I've been having a go myself, but I'm not sure how to access the transaction currency from Taxes::Simple.

I use perl very rarely and only under threat of torture...

Cheers,
Richard


Quoting Chris Travers <..hidden..>:

Hi, I have reproduced this.  Looking into how and why.  May be an
intermediary rounding issue.

Best Wishes,
Chris Travers

On 4/27/07, ..hidden.. <..hidden..> wrote:
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.


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

!DSPAM:3,4632655442021804284693!





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