Unable to remove an erroneously matched advance invoice

Hi @simonpowell,

When an advance invoice is matched against a final invoice it gets offset and a supplier offset payment U voucher is created instantly. And therefore, the status of the final invoice will have ‘Paid’ indicated. That is the reason why you can’t simply remove or edit a matched advance invoice from a final invoice. Because from the system backend it is already booked.

If it is required to remove the connection of the advance invoice from the final invoice, it can be done through supplier payment rollback window, by selecting relevant payment voucher which payment type code indicated as “Supplier Offset” and performing rollback complete payment on the same.

If you can’t find the Supplier offset U voucher, search the supplier ID in the “Supplier Analysis” window and there under payments tab you can find the Supplier Offset U voucher, final invoice created date or the advance invoice attached date will be the payment date of the Supplier Offset U voucher.

Once you rollback the U voucher, the status of the final invoice will be changed from “PartlyPaidPrelPosted” to “PrelPosted” and there won’t be any advance invoice attached in the Advance Invoices window.

Hope the above clearly explains as to why the advance invoice that was matched cannot be removed/edited straight through the final invoice window.

Please let me know the results

Best Regards,

Peshala