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.
Charley
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.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users