Problem with migrated standard databases and estimates that used a job cost interface (SQL)
Description
Cause
Resolution

Important! Until you perform the following steps, you will receive a Job Cost Interface Failure error when you try to edit job cost settings for a standard database or an estimate that was integrated with job cost in Estimating (Pervasive). Also, you will not be able to use the standard database with new interfaced estimates in Estimating (SQL).

Before you start

You need to be assigned to a role with Run Management Console, Edit Standard Databases, Edit Standard Database Settings permissions, and have Edit access to the estimates to use the job cost system setup.

For each migrated standard database that used a job cost interface in Estimating (Pervasive):

  1. In the Estimating Management Console, click Standard DB on the ribbon.
  2. In the Standard Database Catalog, select the migrated standard database.
  3. In the details pane to the right, click Edit
  4. In the Job Cost Information section:
    1. For the Job cost system name, select either None or Text.
    2. Click Save.
    3. For the Job cost system name, select Sage 300 Construction or Sage 100 Contractor, depending on the application from which you migrated the estimate.
    4. Click Setup, and then enter the job cost settings required to reintegrate the database with Sage 300 Construction and Real Estate or Sage 100 Contractor.
  5. Click Save.
Repeat steps 2 through 5 for each migrated estimate that used the job cost interface in Estimating (Pervasive).

Note: To edit estimates, you must first click Estimates on the ribbon, and then (in step 2) you select the estimate from the Estimate Catalog.

[BCB:164:Chat Estimating US:ECB]

Steps to duplicate
Related Solutions

Getting Started: Sage 300 CRE Job Cost interface (SQL)
Error: A job cost interface failure occurred (SQL)
Error: A job cost interface failure occurred (General) (SQL)