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

  • 0
    Have you been able to print checks from this bank in the past?

    There might be some difference between the bank codes (a special character not visible through the UI). If this is a brand new bank, maybe set it inactive, then add a NEW bank with a different code (the rest of the info would be the same, obviously, as this is a direct replacement for the bad bank).
  • 0
    Hi Eddy,

    Did you find a resolution to this? Just encountering this on an existing and active bank account and it happened to five checks in a batch of 38.
  • SUGGESTED
    The only way I could think to replicate this would be to create payment entries with a payment code assigned to the Cash payment type (by-passes bank services) then change the payment code setup before the batch is posted.
  • 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.