It seems that the work stopped because David suggested to consult an accountant
before...
Jacques
From: "Scott Gray" <[EMAIL PROTECTED]>
I do intend to do this if no one else does, unfortunately time is not on my
side at the moment.
Regards
Scott
On 14/02/2008, Rashko Rejmer <[EMAIL PROTECTED]> wrote:
Hi Evangelina,
Thread that may help you:
http://ofbiz.markmail.org/message/72j6aakesmglucrs?q=jacopo+gl+posting
Regards,
Rashko Rejmer
On Wed, 2008-02-13 at 15:09 -0800, Evangelina Bowman wrote:
> Hello Scott and Rashko,
>
> I'm having the same issue with the rounding of the taxes. This is
affecting
> my GL postings. My total debit amount (Accounts Receivable for $30.35)
does
> not match my total credit (Sales of $27.98 plus sales tax of $2.36 =
> $30.34). I'm off by a penny. The GL transaction does not post since
debits
> and credits must match.
>
> Thanks,
> Evangelina Bowman
>
>
> Rashko Rejmer wrote:
> >
> > Skott,
> >
> > I think that you are right.
> > I was investigating Order total and order components(Items SubTotal,
> > Total Other Order Adjustments, Total Shipping and Handling, Total
Sales
> > Tax) rounding.
> >
> > When order tax adjustments are calculated they are rounded for every
> > item.
> > Exactly what you provided
> > - 6.497 + 1.04 = 7.537 (rounded 7.54)
> > - 4.997 (rounded 5.00)
> > I saw your commit that changed that - r602011
> >
> > but when order grand total is calculated then tax adjustments are
> > rounded together
> > - 6.497 + 1.04 + 4.997 = 12.534 (12.53)
> > this is performed in OrderReadHelper.getOrderItemsTotal
> >
> > I was willing to check also how ShoppingCart.getGrandTotal calculates
> > order total before order creation.
> >
> > About the second problem I also think that it is impossible to solve
it
> > in usual way.
> > When invoice total is calculated, the tax items are calculated
> > separately and rounded after that, so the rounding that was made in
the
> > order(on the order item basis) is lost.
> > On the other side(exactly what you said) if the order is invoiced to
few
> > invoices then there will be situations when the tax roundings will be
> > inaccurate.
> > I very loved your idea about additional adjustment to the invoice that
> > will correct the final amount. Can somebody give me some suggestions
how
> > to implement that?
> >
> > I will continue with investigation.
> >
> > Regards,
> > Rashko Rejmer
> >
> > On Fri, 2007-12-07 at 19:10 +1300, Scott Gray wrote:
> >> Hi Rashko
> >>
> >> There seems to be 2 issues going on here, one can be fixed the other
> >> can't.
> >>
> >> The order total is correct at 188.75 but the tax total is incorrect:
> >> 4.997 + 6.497 + 1.04 = 12.534 (rounded 12.53) not 12.54
> >> That can be fixed, I'll commit it shortly.
> >>
> >> The other issue is that the order is then split into 2 invoices:
> >> Tax on invoice #1: 6.497 + 1.04 = 7.537 (rounded 7.54)
> >> Tax on invoice #2: 4.997 (rounded 5.00)
> >> Total tax for both invoices = 12.54 as opposed to the order tax total
> >> which should be 12.53
> >> This one I have no idea how to fix, whenever you split a single order
> >> into multiple invoices there is always the potential for this to
> >> happen because the tax is rounded more often (once for each invoice
as
> >> opposed to once for the entire order).
> >> The only option I can see is to incorrectly round the tax (or create
> >> some sort of tax adjustment) on the invoices so that they stay in
sync
> >> with the order total.
> >>
> >> What do you think?
> >>
> >> Regards
> >> Scott
> >>
> >> On 07/12/2007, Rashko Rejmer <[EMAIL PROTECTED]> wrote:
> >> Hi Scott,
> >>
> >> The problem occurs in very very specific orders. Here are the
> >> EXACT
> >> steps:
> >> Start creating order with DemoCustCompany party
> >> Add to cart
> >> - GZ-1000 x 5
> >> - GZ-1001 x 5
> >>
> >> Then create 2 ship groups for the order - for each of the
ship
> >> groups
> >> chose the second shipping address(US-CA) of the
> >> DemoCustCompany party
> >> Then move to the second shipping group one of the items
> >> GZ-1000 or
> >> GZ-1001.
> >> Then use shipment method for the first shipping group - "UPS
> >> Guaranteed
> >> Next Day - $10.70" and for the second shipping group "No
> >> shipping"
> >> Pay the order with whatever you want(but use only ONE payment
> >> method).
> >> Do NOT add any additional parties.
> >> Create the order.
> >> The total amount of the order should be 188.75(this is with
> >> clean copy
> >> of ofbiz, after run install).If this is the third order you
> >> create with
> >> this party then you might get different grand total, because
> >> the promos
> >> are over and there aren`t any more of them.
> >>
> >> Then "Quick ship entire order".
> >>
> >> The sum of the two invoices is 188.76 but the order grand
> >> total is
> >> 188.75
> >>
> >> I created example on the demo server - order WSCO10009 with
> >> invoices
> >> CI7, CI8
> >>
> >>
> >>
https://demo.hotwaxmedia.com/ordermgr/control/orderview?orderId=WSCO10009
> >>
> >> I will be glad to hear your opinion about this situation.
> >> I have investigated this very deeply and I have idea why this
> >> is
> >> happening but I wanted first to know if this is a bug or not.
> >>
> >> Rashko Rejmer
> >>
> >>
> >> On Fri, 2007-12-07 at 07:43 +1300, Scott Gray wrote:
> >> > Hi Rashko
> >> >
> >> > I think you'll find it's some sort of rounding error in the
> >> order code
> >> > which will need to be tracked down. If you don't have time
> >> to look,
> >> > could you provide some steps to possibly reproduce on a
demo
> >> install
> >> > and I'll take a look when I get a chance.
> >> >
> >> > Thanks
> >> > Scott
> >> >
> >> > On 07/12/2007, Rashko Rejmer <[EMAIL PROTECTED]> wrote:
> >> > I wanted to ask about weird situation that I
> >> noticed.
> >> > I created an order and at the order view screen I
> >> noticed that
> >> > there is
> >> > difference between the order grand total and the
> >> components of
> >> > the order
> >> >
> >> > Items SubTotal =
> >> $183.91
> >> > Total Other Order Adjustments = -$18.39
> >> > Total Shipping and Handling = $10.70
> >> > Total Sales Tax = $12.54
> >> > Sum is $188.76
> >> > __________________________________________
> >> > Total Due
> >> =
> >> > $188.75
> >> >
> >> > The difference is of 0.01$
> >> > Firsth i thought that there is no big problem but
> >> then i
> >> > created 2
> >> > difference invoices for this order and the sum of
> >> the invoices
> >> > was also
> >> > $188.76
> >> > I think that this difference is because of
different
> >> concepts
> >> > for
> >> > invoice and order rounding.
> >> > I wanted to ask if this is normal and how OFBiz is
> >> supposed to
> >> > handle
> >> > that kind of rounding problems.
> >> >
> >> >
> >>
> >>
> >
> >
> >
>