AP Payment voided before the payment control group was posted

Has anyone voided an AP Payment before the actual payment batch was posted leaving ?

This left the voucher in a paid status in the AP Ledger (with no open amount) and no payment in Accounts Payable - Matching Document (f0413/f0414) or the GL F0911.

I'd like to update through SQL the AP Ledger open amount and set it back to the value in the paid amount along with setting the Pay Status Code from a "P" (paid) to "A"

(Approved for payment but not yet paid) --- RPPST='A', RPAAP=RPAG

Has anyone done this before? Just wondering if there is a better way.  Thank you.