Excluding Sage 300 CRE Jobs from AnterraBI

Excluding Sage 300 CRE Jobs from AnterraBI

The implementation of this feature involves the customization of customer's AnterraBI environment.  Contact support for an estimate of fees and timing.

How To Configure

The strategy to exclude jobs from AnterraBI leverages the Sage 300 CRE, Job Setup – Status tab, Job Checklist.   Choose one of the unused Job Checklist items and designate it “Exclude Anterra”.   The title of the Job Checklist item can be changed using the 'Edit' button.   Anterra recommends using Job Checklist 12.

Once a Job checklist is renamed, AnterraDataCenter will need updated.  Contact Support@anterratech.com for an estimate of fees and timing and to coordinate the updates.

job setup screen


Anterra will customize customer's AnterraBI environment and jobs marked 'Exclude Anterra' are not transformed into AnterraBI.  If the customer unchecks the ‘Exclude Anterra’ job checklist item, the job will replicate in the next data synchronization cycle and become visible in AnterraBI.

AnterraDataCenter (ADC) Table Setup

When the name is edited, the Job Master file synchronization will fail until AnterraDataCenter is updated.  JCM_MASTER__JOB table recreation required for this setup.  This is processed through the AnterraDataCenter.  Locate and select the desired table and right click.  Select Run Table Setup.  For assistance, please contact Support@anterratech.com.
ADC Table Setup

AnterraBI Job Update

The AnterraBI Job sync updates required for this setup.  All AnterraBI Jobs are processed regularly overnight.  For a refresh prior to regular nightly refresh, please contact Support@anterratech.com.


    • Related Articles

    • Set up SQL Data connections for Sage Crystal Reports

      Overview Sage 300 CRE uses Crystal Reports to generate formatted reports. To connect Crystal Reports, and thus the Sage report designs to your data which ADC has extracted into SQL Server, you will need to: Create a 32-bit ODBC connection called a ...

    • 'Timberline Version Changed' appears when anterraDataCenter opens

      Background When anterraDataCenter opens, a dialog box with the title "Timberline Version Changed" appears Each time anterraDataCenter opens, a message appears that has the following text in it: "Timberline version has recently been updated. SQL ...

    • Troubleshooting Problems Data Sync to AnterraBI

      Some of the common reasons for the anterraDataCenter sync to stop running are as follows: The local or active directory account that is used by Windows Task Scheduler to run the data update has had its password changed. Your ERP system (Sage, ...

    • Entering Estimated Labor Hours in Sage 300 CRE

      Calculating  KPIs for Labor Having estimated hours in Sage will let Anterra calculate several key performance indicators including: Estimated vs Actual Labor Rate Remaining Estimate Hours  Entry for new jobs Manual entry or import – fill in the Units ...

    • Invoice Sync: Setup Sage 300 CRE with ADC

      Once you have Invoice Sync installed, use the following steps to complete setup. Configuring Sage 300 CRE with ADC Clicking the Config menu (shown below) then choosing Setup ADC Sage 300 CRE will bring up the Config ADC Sage 300 CRE window. In the ...