Re: Rounding issues on vendor invoices

[Charley Tiggs <..hidden..>]

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