Scott,
that is great, thanks!
For the test case:
https://demo.hotwaxmedia.com/ordermgr/control/orderview?orderId=WSCO10001
I got this order in the following way:
1) removed all the promotions from the store
2) changed the tax percentage for the UT state to 8.63; you can do this
in the following screen:
https://demo.hotwaxmedia.com/accounting/control/EditTaxAuthorityRateProducts?taxAuthPartyId=UT_TAXMAN&taxAuthGeoId=UT
3) in the order manager, start an order for DemoCustomer
4) put one product in the cart and change its price to 11.99
5) select the "UPS Air - $5.80" as shipment method
6) checkout and quickship
Please let me know if you need further information!
Jacopo
Scott Gray wrote:
Hi Jacopo
If you can give me a test case I'm happy to take a look at it.
Regards
Scott
On 23/06/07, Jacopo Cappellato <[EMAIL PROTECTED]> wrote:
Well,
in the order in the demo server the amount invoiced is equal to the
order grand total: $18.83
So, the rounding issues in the payment is leaving the invoice open for
one cent
Jacopo
Jacopo Cappellato wrote:
> Unfortunately, there are still some rounding issues when sales taxes
are
> involved.
> After some research, I think I have found where the problem is:
> OrderPaymentPreference.maxAmount (the field where the auth/captured
> amount is stored) has 2 decimal digits; the field
OrderAdjustment.amount
> has 3 decimal digits; the number of digits (set in the arithmetic
> properties file) for sales taxes is 3.
> My guess is that somewhere we move a 3 decimal number (without proerly
> rounding it as we do with the order grand total) to a 2 decimal field
> (maxAmount) and so the db approximate the number for us (in a different
> way from the grand total).
> The end result is this:
>
>
https://demo.hotwaxmedia.com/ordermgr/control/orderview?orderId=WSCO10001
>
> The order total is $18.83 (rounded from 18.825)
> The amount auth/captured/invoiced is $18.82
>
> Any hints on how we can fix this?
>
> Jacopo
