Skip to main content

Cost Types

Agave Sync allows you to link Spectrum Cost Types to Autodesk Build Budget Segment Values.

Video Tutorial​

Common Errors and FAQs​

Are there any pre-requisites to syncing Cost Types?​

Yes:

  1. You need to enable the Info-Link tables (see below),
  2. The associated Project must be synced beforehand, and
  3. Your Budget Code Segments must be set up beforehand (see below).

The following Info-Link tables are required when syncing Cost Types from or to Spectrum:

  1. JC_COST_TYPE_MASTER_MC
  2. JC_PHASE_MASTER_MC

For details on enabling Info-Link tables for your user, see Steps 2.7 in our Spectrum authentication guide.

Common Errors and FAQs​

Unable to Create -- Segment Code Already Exists​

If you see the error [Autodesk Build Error] ValidationException: Unable to create - segment code already exists, it means the Segment Code (such as a Sub Job, Cost Code, or Cost Type) you are trying to sync is already in the Project.

To fix this error, you will need to link the record to the existing Sub Job, Cost Code, or Cost Type in Autodesk Build.

tip

If the Segment Code is not appearing in the "Link to Existing" list, trying pressing Fetch Latest Data to confirm you are seeing the latest list of Sub Jobs, Cost Codes, or Cost Types in Autodesk Build.

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")
  • 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