Open Forum

 View Only
  • 1.  Update "Pay By" field in AP Voucher & Adj Entry Screen

    SILVER CONTRIBUTOR
    Posted 29 days ago
      |   view attached
    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
    ------------------------------

    Attachment(s)

    pdf
    Pay By issue.pdf   102 KB 1 version


  • 2.  RE: Update "Pay By" field in AP Voucher & Adj Entry Screen

    GOLD CONTRIBUTOR
    Posted 29 days ago
    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
    ------------------------------



  • 3.  RE: Update "Pay By" field in AP Voucher & Adj Entry Screen

    SILVER CONTRIBUTOR
    Posted 28 days ago
    Marc, you are the BEST!  This worked perfectly and your quick response allowed us to pay our sub right away!  Thank you so much!

    ------------------------------
    Corrie Boese
    Sr Accountant
    KBA, Inc.
    Bellevue WA
    ------------------------------