I am revisiting this problem. Since the aged statement format hasn't been working all that well (yet), we've had to use the old format BUT:
If I run the statement with balance forward from 1/1/05 I get these numbers:
Current $14024.52
30 Days $12053.98
TOTAL DUE $9087.34
With the Balance Foward thru 1/1/05 21,963.01
this should be $0 since there are no invoices that are past due more than 45day (approx)
If I run the full statement (since we started w/DBA) I get the correct numbers
Current $14024.52
30 Days $12053.98
TOTAL DUE $26078.50 That's $16991.16 OFF
Lynn - I'm emailing you with files to show extactly what it looks like