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

Re: Rounding issues on vendor invoices

I may try to modify the number parsing routines to handle additional
zeros.  There is no immediate workaround, however.

Best Wishes,
Chris Travers

On 6/25/07, Charley Tiggs <..hidden..> wrote:

Thanks, Chris.  Are there any suggested work arounds until 1.4 rolls
out? I can think of one, which is to apply the discount separately using
either a service or set up an account specifically for discounts and pay
the discounted part of what's due against that.


Chris Travers wrote:
> SQL-Ledger applies the discount to the unit price, not the extended
> price, so you get something like: select (floor(3075*0.95)/100) * 10;
> THis is something we have been looking at changing in 1.4, but it is
> behavior we inherited.
> Best Wishes,
> Chris Travers
> On 6/25/07, Charley Tiggs <..hidden..> wrote:
>> I think I have rounding issues.  Either that, or I'm not understanding
>> how rounding is supposed to work on vendor invoices where a percentage
>> is being taking off of each line item.
>> example:
>> SELECT (30.75 * 10) - ((30.75 * 10) * 0.05);
>>   ?column?
>> ----------
>>     292.1250
>> As you can see, even if I use the floor() function, it would still be
>> 292.12.
>> Yet, when creating a vendor invoice within LSMB, it states that the
>> total should be 292.10.  The greater the number, the larger the discrepancy.
>> Is this a bug or am I just not understanding how rounding should work?
>> Charley

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.
Ledger-smb-users mailing list