Unable print _Manual check and payment register_databace connector error

Hello, 

There is error message on the Sage100 as shown below. 

How to fix the error?

Thank you in advance for your help!

  • This error could mean that your report cannot read a date field because a record has an invalid date (perhaps the check date or any other date field).  For example, if a date is entered in a format other than xx/yy/zzzz, this could be why you're getting this error.

  • Description

    Error: "Unable to Print. Database Connector Error. '[Database Vendor Code: 9]'."

    "Error in File AP_InvoicePaymentListing"

    Occurs when Print or Preview in Accounts Payable Check Printing and Electronic Payment

    Cause

    One or more records in the following files/tables contains an invalid date value:

    • AP_CheckHeader
    • AP_CheckDetail



    Resolution

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

    1. Open Modules, Library Master, Utilities, Data File Display and Maintenance
    2. Click OK to Warning dialog box
    3. Browse to ..\MAS90\MAS_xxx\APxxx and open either AP_CheckHeader.m4t and /or AP_CheckDetail.m4t
      (xxx = company code)
    4. Locate the affected record with invalid date
    5. Click Edit, select the field(s) to correct from drop down menu (affected field may be the invoice date, invoice due date, etc.)

    Note: The date should have the following format: YYYYMMDD. For example June 17, 2014 is formatted as 20140617, but may display as 2014 617