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)

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

Choose an option below to resolve the issue

Change the field name

Change the field name description back to Project Manager.

The Project Manager field is below Misc Phone # and above Misc Title 1. If you changed the name of Misc_Title_1, you'll see it displayed there.

Change the report design

Change the Project Manager references in the Crystal Report design.

You’ll need the Crystal Reports software and have a basic knowledge of how to use it to complete these steps. If you don’t own Crystal Reports or don’t know how to use it, contact your Sage Consultant or Sage Expert Services for assistance.

Confirm the Timberline Data Source ODBC DSN uses the database receiving the error.

1. From the Windows task bar, click Start and select All Programs, ODBC.
2. Select the correct administrator for your version.
   • Versions 25.2 and earlier: 32-bit ODBC Administrator
   • Versions 261 and later: 64-bit Administrator
3. Go to the System DSN tab.
4. Select the Timberline Data Source.
5. Select Configure.
6. Click Select Folder then select the company data folder that’s receiving the error.
7. Click OK.
8. Click Options.
9. Specify the Table and Field Naming as Standard Descriptions.
10. Mark the Use maximum table segment size checkbox.
11. Clear the Shorten field and table names checkbox.
12. Click OK.
13. Click OK.
14. Open the design in Crystal Reports.
15. From the Database menu, select Database Expert.
16. In the Selected Tables section, expand Timberline Data Source.
17. Right-click on MiscCompliance.
18. Select Edit Command.
19. Change the reference JCM_MASTER__JOB."Project_Manager" to JCM_MASTER__JOB."[field name]" AS "Project_Manager"
    • For example, if you changed the Project Manager field to Contact, then change the reference to JCM_MASTER__JOB."Contact" AS "Project_Manager"
20. Click OK.
21. Save the design with a different name.
22. Change the report menu to use this modified report or add the modified report in Reports Manager. Make sure that the Source selected is Crystal report design.