Re: Rounding issues on vendor invoices

["Chris Travers" <..hidden..>]

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