Unable print _Manual check and payment register_databace connector error

Question

Hello, 
 
 There is error message on the Sage100 as shown below. 
 How to fix the error?

Thank you in advance for your help!

BShockley · Answer

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.

BigLouie · Answer

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. 
 
 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_CheckHeader.m4t and /or AP_CheckDetail.m4t (xxx = company code) 
 Locate the affected record with invalid date 
 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

Sage 100

Unable print _Manual check and payment register_databace connector error

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING