How to set AP voucher to Paid and change current total to 0.00
WESS-4489
📘 Instructions
In this scenario, two checks that had paid the AP's with voucher numbers AP 82373 & AP 82361 were voided, and subsequently two new payments were created to pay these AP invoices.
Will need to query on the back end for the queries and set status to paid and current total to 0.00
Step1: Verify that the vouchers with voucher numbers AP 82373 & AP 82361 show a status of open, even though they show as being paid on PY 57315 & PY 57314.
select ap_invoices
where voucher_number in ('AP 82373', 'AP 82361')
Step 2: Update the vouchers to set the status to Paid and a current total to 0.00.
update ap_invoices
set status = 'Paid'
where voucher_number in ('AP 82373', 'AP 82361')
update ap_invoices
set current_total = '0.00'
where voucher_number in ('AP 82373', 'AP 82361')
For AP vouchers that meet the criteria of the ticket, use the below format:
update ap_invoices
set status = 'Paid'
where voucher_number in ('AP XXXX', 'AP XXXX')
update ap_invoices
set current_total = '0.00'
where voucher_number in ('AP XXXX', 'AP XXXX')
Article - AP invoices show as open, although they are paid.docx
Highlight important information in a panel like this one. To edit this panel's color or style, select one of the options in the menu.