I posted this over a year ago and got some helpful answers, but I'm revisiting this question.
I have an invoice table and a payments table.
I want a running balance for clients if they partially pay one invoice…I want the o/s balance to be added to the next invoice.
The relationship between the two is the invoice id + the client id
I have the calulations right to reflect the running balance.
My problem is that the next invoice doesn't reflect the running balance.
The script has to find all that client's invoices to see that there's an o/s balance.
Do I have to incorporate a loop to find the o/s balance?
I'm missing something simple here.
Thanks in advance,