When a voucher is reversed, the F43121 would have Amount Open,0 in Amtpd/closedamt
We have already done the receiving - have match type = 1, Amt pd to date as 500 amt recd 500, Voucher matched done and paid, Payment voided and voucher voided.Now looks like they incorrectly the void, hence the F43121 Match type was not set back to 3.
Now match type = 2 , Amt Open = 0 Amt pd to date = 500, Amt recd = 500 closed amt = 0.00
I have to do a SQL to fix this, Please can you verify if I am taking care of all the fields for SQL Update.
I plan to do the following update to set Match Type = 5, Amt Open = 500, Amt recd = 500, Amt pd to date = 0.00, closed amt = 0.00