Customer unpaid tickets total - state

Hi all,

I this video you can see I’m adding a couple of tickets to a customer account entity.


You can see the customer is a credit of 168.20 show account balance.

The total amount owed of tickets unpaid tickets = 27.40.

How do I when selecting a customer with unpaid tickets show the total amount of 27.40 (all combined open tickets for the customer) as a state under the customer credit / debit balance. So that when the customer places another order on there account the casher can see the total amount of unpaid tickets.

Chances are you are going to have to use SQL Report, because you will probably be adding ticket amounts across multiple workperiods.

I don’t have time come up with a solution, but this should get you started in the right direction.