Refund of an advance payment to suppliers

The supplier made a refund in October of an advance that was recorded in August. To cancel the payment, a reconciliation is required and to cancel the invoice, previous periods must be opened, but the client does not want to unbalance a period that has already been closed.
How can refunds be recorded without affecting the reconciliation and previous periods?

The client wants a quick solution to finalize the month-end closing.

The scenario is, I create an advance, I pay it, but the supplier returns it totally or partially, so what happens next in the tool? Do I have to reconcile the advance payment and enter the amount to the bank or is there a way to record that advance return? What should be the correct process in the ERP?