Client is invoicing for time, this results in line item amounts that are more than 2 decimals. These are rounded and displayed correctly by Invoices.

Problem is, the subtotal code is adding the unrounded amounts and then rounding, the invoice total code is adding the rounded line amounts.

The law of averages says these two results should be close...but certain hourly rates result in a considerable difference between the totals.

As I'm importing the invoice lines, I've thought about pre-rounding the amounts and using the 'weight' field to calculate the subtotal.

Anyone else experience this? am I missing something (other than my mind)? anyone have a simpler workaround?

Ta everso,

Tony: I have encountered a similar rounding issue in using the Invoices database to create a Crystal report; in my case, it was in calculating the taxes.

As best I can tell, it appears Invoices calculates each line item and displays the calculation result(s) rounded to 2 decimals. However it retains the amounts to four decimals and uses those in calculating the total(s).

I think your idea of "pre-rounding" before the amounts get into Invoices may be a good way to go.