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
