It has been awhile since I have looked at these, but I believe this does it; check what you'll update first with your select statement and note values in Econfirm and Estatus (most likely blank). if the returned record seems right, run begin tran and update; if you get 1 row updated, run commit, otherwise rollback.
select * From apdoc where refnbr = '021941' and openDoc = 1 and doctype = 'VO'
begin tran
update apdoc set Econfirm = 'MAIN', Estatus = 2 where refnbr = '021941' and openDoc = 1 and doctype = 'VO'
rollback
commit
if that doesn't do it, set econfirm and estatus back to prior values
Marc
------------------------------
Marc DeLozier
Finance SysAdmin
David Evans and Associates Inc.
Portland OR
------------------------------
Original Message:
Sent: Jun 02, 2022 07:02 PM
From: Corrie Boese
Subject: Update "Pay By" field in AP Voucher & Adj Entry Screen
We had a vendor that used to be paid by check. Recently the vendor has been updated to receive payment by ACH. There is a released AP voucher that I'm trying to pay via ACH that was originally entered when the vendor was getting payment by check. The Document Maintenance Screen shows "CCD" in the Pay By field but the Voucher & Adjustment Entry screen still shows "SL Check" in the Pay By field. When I try to pay the vendor in e-banking, I get an error message and I believe this is why. Is there a way to update the "Pay By" field in the Voucher & Adj Entry screen? I have some SQL experience to update that way but I can't find the necessary table/field to update there. I know from prior experience that I can void the AP document and re-enter and that will work, but I'd like to avoid having to do this each time this occurs. I attached screenshots for examples. Thank you so much for your help!
------------------------------
Corrie Boese
Sr Accountant
KBA, Inc.
Bellevue WA
------------------------------