Cancelling Payment Batch

I just got requirement to cancel the payment batch. It’s pretty easy if you know all underlying tables. You can use below statements as ready to use statements where you have update Payment batch name.


DELETE ap_checkrun_conc_processes_all
WHERE checkrun_name = '< Batch name>';

DELETE ap_selected_invoices_all
WHERE checkrun_name = '< Batch name>';

DELETE ap_selected_invoice_checks_all
WHERE checkrun_name = '< Batch name>';

DELETE ap_checkrun_confirmations_all
WHERE checkrun_name = '< Batch name>';

DELETE ap_awt_temp_distributions_all
WHERE checkrun_name = '< Batch name>';

UPDATE ap_inv_selection_criteria_all
SET status = 'CANCELED'
WHERE checkrun_name = '< Batch name>';