Skip to main content

Prime Contracts (Contracts)

Visual Mapping

Procore and Spectrum AR Invoice Visual Mapping

Procore and Spectrum AR Invoice Visual Mapping

Procore and Spectrum AR Invoice Visual Mapping

Common Errors and FAQs

The following Info-Link tables are required when syncing Prime Contracts from or to Spectrum:

  1. CR_BID_ITEM_DES_MC
  2. CR_CONTRACT_MASTER1_V
  3. CR_CONTRACT_MASTER_MC
  4. CR_DRAW_REQUEST_DETAIL_MC
  5. CR_DRAW_UNIT_PRICE_BILL_MC

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

Unit Price Contracts

For importing Prime Contracts from Spectrum to Procore, if a Project (Job) has a type of "Unit Price" in Spectrum, Agave Sync will read from the "Unit Billing Items" tab in Spectrum.

For exporting Prime Contracts from Procore to Spectrum, if a Prime Contract has a type of "Unit" in Procore, Agave Sync will export Prime Contract Line Items to the "Unit Billing Items" tab in Spectrum.

Exporting Prime Contracts from Procore to Spectrum

If you choose to export Prime Contracts from Procore to Spectrum, there are a few important details to keep in mind:

  1. Limited Field Sync: Agave Sync can only sync the Job Number, Customer (at the Prime Contract header), and the Prime Contract Line Items. Other header-level fields — such as Retention Percentage — cannot be updated through Agave Sync.
  2. Taxable Status Logic: when determining whether a Prime Contract Line Item should be marked as "Taxable" in Spectrum, Agave Sync will reference the associated Job's settings. If the Job is set to "Taxable", the Prime Contract Line Item will be treated as taxable.

Deleting Prime Contracts

You may unintentionally sync Prime Contracts to Procore without all of the line items you would like to include. Instead of manually (1) setting the Prime Contract back to "Draft", (2) unlinking the Prime Contract, and (3) deleting the Prime contract, you can use Agave Sync to delete Prime COntracts you have synced to Procore.

To delete Prime Contracts you have synced to Procore:

  1. Identify the Prime Contracts you would like to delete:

    Prime Contracts

  2. In Agave Sync, select those Prime Contracts and press Delete from Procore:

    Prime Contracts

    Prime Contracts

  3. The Prime Contracts will now appear as syncable but they will no longer exist in Procore:

    Prime Contracts

    Prime Contracts

note

Agave Sync will delete the Prime Contracts in Procore, but not in the original source system (i.e. youre accounting system).