Hi, I've got the following layout:
So all invoices for the customer get total up under "total invoices"
All payments added to a job sheet for that customer show under 'JS payments'
However, I want to the outstanding balance to show total invoice payments, take away JS payments. Only when the 'payment banked' box is ticked.
At the moment, it takes away regardless, and when I add the if statement to the outstanding balance calculation, it only takes into account the first check box. I need it on an individual basis. So when I check the top 'payment banked' the outstanding balance should be £700.
Is it a relationship issue causing this? I can't seem to work it out.
Your thoughts and suggestions are appreciated.