Financials - Unarchive AP Payments - Invoices
🤔 Problem
Sometimes an AP voucher gets archived by mistake, or a client wants to reverse the archive to pay the voucher. Once archived, the voucher is removed from the active system and excluded from normal payment processes.
🌱 Solution
While it’s possible to unarchive an AP voucher using SQL scripts, it’s not recommended. The system has important checks that scripts can bypass during payment processing. Once archived, vouchers are meant to be fully removed from the system and shouldn’t be reversed this way.
The best practice is to rebook the voucher through the system to ensure everything stays accurate and consistent.
If unarchiving the AP voucher is necessary and the downstream issues are not a concern, you might use the script below.
-- Unarchive in AP Payments table.
UPDATE ap_payments SET STATUS= 'Paid' WHERE voucher_number = 'PY 356791'
-- Unarchive in AP Invoices table.
UPDATE ap_invoices SET STATUS= 'Paid' WHERE voucher_number = 'AP 1113'
Remember to verify this in the Internal project boxes and then non-prod environments before any deployment in Prod.