Error: “You must clear the returns and post bank reconciliation” Message When Activating Bank Services

Products

Sage 300 5.6 (retired)

Sage 300cloud

Country

North America

Description

The following errors may occur when upgrading to Bank Services 5.6:

  • Bank has outstanding returns. You must clear the returns and post bank reconciliation before you can upgrade Bank Services.
  • Bank has entries that are not posted. You must clear the returns and post bank reconciliation before you can upgrade Bank Services

Resolution

Perform a bank reconciliation for the affected bank and clear any outstanding bank entries or returns. If there are no outstanding entries or returns, check the following tables:

  • BKNSF for returns
  • BKENT for bank entries

These two tables must be empty in order for Bank Services to proceed with the activation. If any single table or if multiple tables are not empty, check the dates of the records. They may have been reconciled with a future date either by mistake or intentionally. The bank must be reconciled with the future date saved in the records of these tables first.