Sage 100 Database Connector Error: [Database Vendor Code 9] running the Bank Reconciliation Report

Description

Sage 100 Error: “Database Connector Error: [Database Vendor Code 9 ]” running the Bank Reconciliation Report
Database Connector Error: ‘[Database Vendor Code 9 ]’
Error in File BR_ReconciliationRegister
{151E4895-28C7-4577-A09E-8A1E2F06E6E4}.rpt

Disclaimer

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions.

Cause

The file BR_Transaction.m4t contains a bad date format in a date field

Resolution

1. Open Library Master, Utilities, Data File Display and Maintenance
2. Click OK to the Warning message
3. Open ..\MAS90\MAS_XXX\BRXXX\BR_Transaction.M4T where XXX=Company Code
4. Examine the following fields for bad date formats (Something other than YYYYMMDD format):
   •TransactionDate
   •DocumentDate
   •CheckDate
   •ClearedDate
5. The fields can be edited with the correct format by clicking the Edit button

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.