I have a report I created which pulls all data by month by category and
gives me running totals month by month. My problem is I need the ending
balance running total to move down to the next line in the report as a
beginning balance. How can I set that up in the report? I also need to put
a zero in the Jan06 Beginning Balance column.
Example:
Period Begin Bal Accruals Pymts
Rcls WO Ending Bal
Jan06 0 1000.00 500.00
100.00 50.00 350.00
Feb06 (need to put 350.00 here from previous month ending bal)
Any suggestions would be appreciated.
Thanks,
Tom