Dennis,

I had this problem years ago. I started storing values using 4 decimal places and then rounding the result. Sales tax was the biggest problem. I hate storing totals.



>I have always been of the opinion that invoice totals should be calculated when needed rather then stored. The problem is that I get a different result, the so called penny difference, when comparing different types of reports.
>When I review others code I see most people are storing the invoice total and sales tax total and using those totals on reports.
>Any ideas as to what the best approach might be?