Skip to main content

Projects (Jobs)

Agave Sync allows you to sync Sage 300 CRE Jobs to Autodesk Build Projects.

Visual Mapping

Autodesk Build and Sage 100 Vendors Mapping

Autodesk Build and Sage 100 Vendors Mapping

Autodesk Build and Sage 100 Vendors Mapping

Common Errors and FAQs

Error: Project Already Exists

If you encounter the error [Autodesk Build Error] [Project Name] already exists, you will need to either:

  1. Link the Record: link the Project to the existing Project in Autodesk Build, or
  2. Check for Duplicates: if you cannot link the Project, it means there is already a Project in your accounting system that links to the Autodesk Project. In this case, you can:
    • Delete or consolidate the duplicate Project in your accounting system,
    • Ignore the duplicate record, or
    • Update the name of the Project name to make it unique.

Error: Invalid State Code for Country

When syncing Projects, Vendors, or Customers in Autodesk Build, only valid state or province names and ISO 3166-1 alpha-2 country codes are supported. Additionally, the specified state or province must correspond to a valid location within the project's country.

United States

Below is a list of valid state codes for use in Autodesk Build:

  • AL: Alabama
  • AK: Alaska
  • AZ: Arizona
  • AR: Arkansas
  • CA: California
  • CO: Colorado
  • CT: Connecticut
  • DE: Delaware
  • FL: Florida
  • GA: Georgia
  • HI: Hawaii
  • ID: Idaho
  • IL: Illinois
  • IN: Indiana
  • IA: Iowa
  • KS: Kansas
  • KY: Kentucky
  • LA: Louisiana
  • ME: Maine
  • MD: Maryland
  • MA: Massachusetts
  • MI: Michigan
  • MN: Minnesota
  • MS: Mississippi
  • MO: Missouri
  • MT: Montana
  • NE: Nebraska
  • NV: Nevada
  • NH: New Hampshire
  • NJ: New Jersey
  • NM: New Mexico
  • NY: New York
  • NC: North Carolina
  • ND: North Dakota
  • OH: Ohio
  • OK: Oklahoma
  • OR: Oregon
  • PA: Pennsylvania
  • RI: Rhode Island
  • SC: South Carolina
  • SD: South Dakota
  • TN: Tennessee
  • TX: Texas
  • UT: Utah
  • VT: Vermont
  • VA: Virginia
  • WA: Washington
  • WV: West Virginia
  • WI: Wisconsin
  • WY: Wyoming

Canada

Below is a list of valid province codes for use in Autodesk Build:

  • AB: Alberta
  • BC: British Columbia
  • MB: Manitoba
  • NB: New Brunswick
  • NL: Newfoundland and Labrador
  • NS: Nova Scotia
  • ON: Ontario
  • PE: Prince Edward Island
  • QC: Quebec
  • SK: Saskatchewan
  • NT: Northwest Territories
  • NU: Nunavut
  • YT: Yukon

Error: NotAllowedException: Not Authorized. Current project is not active.

This errors is from the Project no longer being marked as Active in Autodesk.

To resolve this error, you can either:

  1. Mark the Project as Active in Autodesk. You can do this by going to Account Admin-->Projects, and selecting the Archived tab. From there, you can select to Restore Projects:

    Projects

  2. Disable Auto-syncs for the Project in Agave. You can do this by going to the Projects tab in the Agave Sync website, and toggling off Automatic Sync for the Project:

    Projects

If you want to apply Project Templates in Autodesk Build as a default, see our guide on setting up Project Templates.

Configuring Autodesk Budget Codes to Match your Accounting System

You will want to make sure your Autodesk Build Budget Codes is set up to match the structure of your Sub Jobs, Cost Codes, and Cost Types in your Accounting System. We recommend properly configuring this in your Project Template(s) to ensure all Autodesk Projects use the same Budget Code structure.

The following includes a video walk through and guide to properly onfigure your Project Template's Budget Code.

To ensure they match:

  1. In your Project Template, go to the Cost Management module.

Budget Code

  1. Select the gear icon or Settings on the left navigation.

Budget Code

  1. Select the Budget tab, select Add New.

Budget Code

Configuring Sub Jobs

If you plan to use Sub Jobs, complete the following steps. If you do not, feel free to skip this step.

Note, the following Accounting Systems have the concept of Sub Jobs:

  • Acumatica ("Tasks")
  • Deltek ComputerEase ("Phases")
  • Foundation ("Phases")
  • Sage 100 Contractor ("Phases")
  • Sage 300 CRE ("Extras")
  • Sage Intacct
  • Vista

To configure your Sub Job setup:

  1. Press the pencil icon next to Segment 1, and type in Sub Job.

Budget Code

  1. Below Sub Job:
    • For Where, select "Code"
    • For Number of Characters, select "Flexible"
    • For Delimiter, select "Hyphen"

Budget Code

Configuring Cost Codes

To configure your Cost Code setup:

  1. Press the pencil icon next to Segment 1, and type in Cost Code.

Budget Code

  1. Below Cost Code:
    • For Where, select "Code"
    • For Number of Characters, select "Flexible"
    • For Delimiter, select "Hyphen"

Budget Code

Configuring Cost Types

To configure your Cost Type setup:

  1. Press the pencil icon next to Segment 2, and type in Cost Type.

  2. Below Cost Type:

    • For Where, select "Code"
    • For Number of Characters, select "Flexible"
    • For Delimiter, select "None"

Budget Code

The type field is required.

When syncing Projects form Sage 300CRE to Autodesk, we require a project type.

To resolve this error, you can go into the Job Setup > General in Job Cost module in Sage 300CRE, and add a Type there. The type here should be any free form text.

Which direction do projects sync by default?

Projects sync from Sage 300 CRE to Autodesk Build by default.

Do we need an Autodesk Build project template set up before syncing projects?

Strongly recommended. Templates standardize budget code segments, preconfigure permissions and approvals, and keep setup consistent across projects. Work with your Autodesk Build implementation manager to finalize templates early.

Can we support multiple different Autodesk Build project templates?

Yes. Multiple templates are supported, and selection/filtering is controlled via configuration. Your implementation team can wire which templates apply to which projects.

How long does it take for a newly synced project to be usable in Autodesk Build cost management?

After pushing a project from Sage, the Project Cost module can take a few minutes to finish initializing. During that time, pushing cost codes or cost types may return "project not set up yet" errors. Wait a few minutes and retry.

What project filters do you recommend when syncing from Sage?

Use Active projects only to avoid syncing archived or closed jobs and to keep Autodesk Build clean.

What happens if we try to sync archived or test projects?

They will attempt to sync, but you will create noise in Autodesk Build and the error log. Prefer filtering to active production projects and Ignore obvious test or training jobs.

Can we delete or deactivate projects through sync?

You can delete certain synced project records from Autodesk Build using controls in the sync UI, but this is one-directional. Archiving/deactivation ultimately follows Autodesk Build and Sage native behavior.

Can we map Sage project type to Autodesk project type? What about long type values?

Yes. Sage project type can be mapped into Autodesk Build, but both systems enforce character limits. Use shorter or abbreviated types (for example, "Residential" → "Res") if you hit limits.

What does "automatic sync eligible" mean on the projects screen?

It lists projects already linked between Sage 300 CRE and Autodesk Build that can participate in automatic syncing. Turning on auto-sync for those records keeps them updated, while other projects can remain manual.

Error: Update failed for table JOB

When syncing from Autodesk Build to Sage 300C CRE, make sure all codes and numbers are formatted as your Sage company file expects them (e.g. Project number as xx-xxxx)