Can anyone tell me how to create a balance brought forward field like this…
Say I have a report that I run from the 15th of the month, I want a sum of transactions up till that day as a balance brought forward. E.g.
Bal B/f 10,000 -> sum of all transactions till the 15th of the month
Transaction 1 1,000
Transaction 2 2,000
Transaction 3 3,000
Balance C/F 16,000 -> sum of all transactions till say the 30th of the month
Can someone help?
Say I have a report that I run from the 15th of the month, I want a sum of transactions up till that day as a balance brought forward. E.g.
Bal B/f 10,000 -> sum of all transactions till the 15th of the month
Transaction 1 1,000
Transaction 2 2,000
Transaction 3 3,000
Balance C/F 16,000 -> sum of all transactions till say the 30th of the month
Can someone help?