Home General

Running balance calculation

edited July 2011 in General
I am building a statement report.
1) It groups on and starts a new page for each customer
2) The report is laid out as follows

Customer 1
Balance Forward: $100

Description Amount Running Balance
Purchase 1 $50 $150
Purchase 2 $70 $220
Payment -$20 $20

What is the best way to calculate the running balance. I have been using
either the on before printer header or on before generate header events
to recognize when to incorporate the initial balance forward amount into
the running balance(to get $150 in this example) but it is giving me
inconsistent results. Seemingly these events don't always fire.

Tony Peppercorn


This discussion has been closed.