Hi,
I have an export file which contains
a date field,
a bank account
a closing balance
For example
26 september, Bank account 1, Closing balance 50,00
27 september, Bank account 1, Closing balance 100,00
27 september, Bank account 2 Closing balance 150,00
28 september, Bank account 1 Clossing balance 200,00
1 october, Bank account 2, Clossing balance 300,00
How can I report the clossing balance of both the bank accounts on the last day of september (9/30)?
30 september, Bank account 1, closing balance 200,00
30 september, Bank account 2, closing balance 150,00
and so on
Is there a possibility to make a join with the master calendar so I have all the information?
Thanks in advance
John
