Hello all,
I've finally reached the end of my database design and need to create a report to print customer statements. I have created a union query from the invoices table, credit notes table and payments table to show the current transactions for the customer. The problem starts afte this.....
1. How do I actually calculate and use the opening balance on the statement so that the query can include it in the running balance?
2. How on earth do I calculate the 30 days, 60 days and 90+ days sections?
I' ve tried searching youtube for videos but alas....nothing lol