Skip to main content
Skip table of contents

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.

SQL
-- 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.

📎 Similar tickets

WESS-16168

WESS-3520

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.