Sage 300 2014 Error batch when posting AP payment batch - check xxx drawn on bank xxx not found in bank services

SUGGESTED

Occasionally we get an error batch when posting AP checks.  We have many companies running Sage and this happens to all of them at random times.  The bank accounts exist and have been there for years.  Does anyone know what causes this error?

check xxx drawn on bank xxx not found in bank services

Parents Reply Children
  • SUGGESTED
    Possible causes:
    1) Database indexes need rebuilding --> SQL or DB Dump / Load. This can be tested by checking to see if the Check / Serial / Bank do in fact exist in the Bank table

    2) Person posting A/P batches doesn't have required permissions to insert / update the bank record or status --> try running as ADMIN to ensure this isn't the case

    3) Long shot, but I've seen odd things happen when G/L Security is used to restrict access to certain accounts which may allow processing in one module but block in another

    Suggested approach:
    1) Backup database
    2) Run Data Integrity with fix option on - BUT not selecting to delete orphan records
    3) Dump / Load the database
    4) At this point, you're down to the forensic level of examining rv / db spy logs

    Best of luck!