Rebuild Debt

Sorry forget to detail the problem

I have the table client movements where all the customer's receipts are recorded, be it invoices, receipts, NC, etc.

What I want to do is to be able to carry out a reconstruction of the debt according to the filter month and year selected.

The intention is to show both the total debt and the detail per client a kind of account summary of the vouchers NOT collected.

I imagine that for the same I must consider a balance accumulated from the period I select by means of a variable taking into account the voucher date - the canceled date

Thank you for your help thank you very much