Unable to Print. Database Connector Error. '[Database Vendor Code: 9]'. in Accounts Payable Invoice Register in Sage 100 ERP

Summary

Error: “Unable to Print. Database Connector Error. ‘[Database Vendor Code: 9]’.” while printing the Accounts Payable Invoice Register in Sage 100 ERP

Disclaimer

Backup Warning

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.
Database Warning
These steps require knowledge of database engines and application databases (DBs) used by your Sage product (including Microsoft/Transact SQL, Pervasive SQL, or MySQL, etc.). Customer Support is not responsible for assisting with these steps and cannot be responsible for errors resulting from changes to the database engine or DBs. Before making changes, backup all system and application DBs required for a full restore. Contact an authorized business partner or DB administrator for assistance.

Cause

One or more entries has an invalid date

Resolution

Resolution One:

Use Data File Display and Maintenance, look for records with dates that are not in the format YYYYMMDD. Edit any record with a date not in this format by entering a date in the correct format.

Open Modules, Library Master, Utilities, Data File Display and Maintenance
Click OK to Warning dialog box
Browse to ..\MAS90\MAS_xxx\APxxx and open either AP_InvoiceHeader.m4t and /or AP_InvoiceDetail.m4t
(xxx = company code)
Locate the affected record with an invalid date field.
Click Edit, select the invalid date field (such as InvoiceDate$) to correct from drop down
Correct the invoice date
1. Note: The date should have the following format: YYYYMMDD. For example June 17, 2014 is formatted as 20140617

Resolution Two:

Open Accounts Payable, Main menu, Invoice Data Entry
1. Note: If prompted, select the Batch Number of the batch of invoices that were to be printed on the register.
Click the First (navigation arrow) button to access the first invoice.
Review the Invoice Date, Invoice Due Date, and Invoice Discount Date of the invoice, to see if one of these dates is invalid
- Note: Examples of invalid dates include a date with an odd year such as 107, or an odd month such as 22, or a long string of numbers or letters not in a standard MM/DD/YYYY format.
If a date is invalid, correct it. If no invalid date is found, use the Next (navigation arrow) button to access the next invoice and review the dates per the previous step. Continue with this process until the last invoice is reviewed.
Exit Invoice Data Entry and try printing the Accounts Payable Invoice Register again.

Resolution Three:

Open a new blank worksheet in Excel (this example was written for Excel 2007, these steps may differ for other versions of Excel)
Select Data, Import Data, From Other Sources, From Microsoft Query (note: on some systems this feature may need to be installed, contact your System Administrator or Microsoft Support for assistance with this)
In the Choose Data Source dialog box, select SOTAMAS90 and click OK. Input Sage 100 ERP user name and password into Database Signon dialog box and click OK
In the Query Wizard – Choose Columns, browse to the AP_InvoiceHeader on the left column.
Highlight the AP_InvoiceHeader and click the icon to add data files to the column on the right.
Click the Next button, and then click Next 2 more times.
In the Query Wizard – Finish window, select View data or edit query in Microsoft Query. Click Finish.
Dialog box opens “This query cannot be edited by the Query Wizard”. Click OK to open Microsoft Query.
Using your mouse, scroll down to the last record (do not drag the scroll bar).
You will see the error again; “Invalid Date contents”.
Click OK on the error. The last record on the query should be the last good record in the file.
Go through Data File Display and Maintenance to the file in question (i.e.: AP_InvoiceHeader) and do a lookup on this record.
Use the next arrow key to go to the next record.
Check all the date fields. One or more fields will have the incorrect date.
Click on the Edit button, select the date field and correct it.
Repeat the steps if the error occurs in multiple files.