Error when running Accounts Payable (AP) Compliance reports:

"Failed to retrieve the data from the database. Database Vendor Code: 31400"

Compliance - Misc Compliance Items by Job (CR)
Compliance - Misc Compliance Items by Vendor (CR)

The field name of Project Manager was changed to a different name in the JC Job Setup window.

Option 1: Change the field name description back to Project Manager

See How do I change the Type, Project Manager, and Misc. Title descriptions in Setup Jobs?

The Project Manager field is below Misc Phone # and above Misc Title 1 (If you changed the name of Misc_Title_1, the new name will be displayed).

Option 2: Change the Project Manager references in the Crystal Report design

Note: You will need the Crystal Reports software and have a basic knowledge of how to use it in order to complete these steps. If you do not own Crystal Reports or do not know how to use it, please contact your Sage 300 Construction and Real Estate Consultant or Sage Professional Services Group for assistance.

1. Make sure the Timberline Data Source ODBC DSN is set to the database that is receiving the error.
   1. From the Windows task bar, click Start and select All Programs, ODBC, 32bit ODBC Administrator.
   2. Select the Timberline Data Source.
   3. Select Configure.
   4. Click Select Folder then select the company data folder that is receiving the error.
   5. Click OK.
   6. Click Options.
   7. Specify the Table and Field Naming as Standard Descriptions.
   8. Mark the Use maximum table segment size check box.
   9. Clear the Shorten field and table names check box.
   10. Click OK.
   11. Click OK.
2. Open the design in Crystal Reports.
3. From the Database menu, select Database Expert.
4. In the Selected Tables section, expand Timberline Data Source.
5. Right-click on MiscCompliance.
6. Select Edit Command.
7. Change the reference JCM_MASTER__JOB."Project_Manager" to JCM_MASTER__JOB."[field name]" AS "Project_Manager"
   • For example, if the Project Manager field name was changed to Contact, then change the reference to JCM_MASTER__JOB."Contact" AS "Project_Manager"
8. Click OK.
9. Save the design as modified name.
10. Change the AP report menu to use this modified report or add the modified report to your AP report menu in Reports Manager. See How do I add a report to a Reports menu?
    Note: Make sure that the Source selected is Crystal report design.