CheckDate Utility for Vendor Code 9 errors related to Sage 100 KB 87257 “Error: “Unable to view” [name of the report, register, etc] Database Connector Error: [Database Vendor Code:9] “when printing a report or register with an invalid date” as well as other date errors.
Important: The CHECKDATE utility is not included with your Sage 100 download, and must be downloaded and installed from the attached file below.
This utility will scan all Sage 100 data files for invalid dates related to KB 87257 and generate a text file with a list of invalid fields. The invalid date fields will need to be manually corrected using Data File Display and Maintenance.
To execute this program, place the CheckDate program in the “..\MAS90\SOA” folder on the server where Sage 100 is installed.
From the file run, type the following SYZCON
From the SYZCON window type RUN “CHECK DATE and press Return
NOTE: This utility does not work with Sage 100 Premium. Use a SQL query that includes a function like ISDATE() to find the invalid date fields.
How to Get Support for SAGE Error Warnings