Error batch posting AP Payment

SUGGESTED

Hi there,

Currently running on Sage 300 2017 and we have this error when we post AP checks: " Check XXXXX drawn on Bank XXXX not found in Bank Services."

The bank Account exists. Not sure what is going on there.

Any clue?

thanks

Parents Reply Children
  • 0 in reply to Django
    I also encountered this (after my original response in March) on a database where they ran a number of Vendor Number Changes. Seems the wrong vendor code (or payee id) was in the BKTRAND or APPYM. (Or missing completely from the APPYM, in some cases.) I don't think the users changed any payment codes during this time.
  • 0 in reply to Django
    I ended up doing the following. Proceed at your own risk.

    Print Batch Listing Report so I had all of the relevant details.

    update APBTA
    set CNTCHKPRNT=0
    where PAYMTYPE='PY'
    AND CNTBTCH=<bad batch number>
    where CNTCHKPRNT<>0

    UPDATE APTCR
    SET SWPRINTED=0
    WHERE BTCHTYPE='PY' AND CNTBTCH=<bad batch number>

    Opened the <bad batch number> in Sage and deleted each of the entries. Created a new batch and re-entered the entries making sure to unselect "Print Check". Used the same check number from the printed document.

    Compared totals to make sure I re-entered the details correct.

    Post.