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

Re: Rounding issues on vendor invoices

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.


I believe we can agree that the lack of an ability to handle this is a
bug and that we need to have a workaround supported soner than 1.4
(ideally sooner than 1.3).

I am going to propose that we provide some handling for prices with
trailing zeros so that these are rounded out to the last decimal
point.  That way you can define a price as 1.000000 and have qty
discounts working more accurately.

What do people think?

Best Wishes,
Chris Travers


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