When I create a running balance on a report. How do I bring the opening balance into the calculation? I.e.
Debtor account Statement from 1Dec17 to 31 Dec17. Opening balance was derived through complicated calculated field in a query.
Running Balance(should be)
Opening balance 30 Nov 1000.00
Debit in Dec Invoice 700.00 1700.00
Credit in Dec Payment 500.00 1200.00
Closing balance 31Dec17 therefor 1200.00
Thank you.