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.
-------------------------------------------------------------------------
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