Hi I want to show a form in table view mode that is a list of transactions.
Every record has a date, a concept, a credit amount and a debit amount.
I need to show in everyline the balance, acumulating all the records, just like:
Date Concept Debit Credit Balance
01-01-2011 Invoice 100 0 100
05-01-2011 Invoice 75 0 175
15-01-2011 Payment 50 125
20-01-2011 Payment 100 25
31-01-2011 Invoice 40 0 65
Totals 215 150 65
How can I put that balance field in the list?
Thanks in advance.