Subcontracts

Visual Mapping

Common Errors and FAQs

What Info-Link Tables do I need?

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

1. VN_SUBCONTRACT_MC
2. VN_SUBCONTRACT_PHASE_MC

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

Error: Invalid GL Account for Job/Phase/Cost Type

If you receive the error Invalid GL Account for Job/Phase/Cost Type, it is because we are unable to determine the Ledger Account for a Subcontract Line Item when it is synced to Spectrum.

Since your Project Management system does not have a General Ledger and General Ledger Accounts are required for creating Subcontracts in Spectrum, Agave Sync will use one of the following General Ledger Accounts if available:

1. The Vendor's Default General Ledger Account in Spectrum (if available),
2. The Cost Type's Default General Ledger Account in Spectrum (if available), or
3. A default Expense General Ledger Account value you provide your Agave Account Manager (e.g. "5400" for "Subcontractor Expenses")

Setting a Vendor's Default General Ledger Account

To set a Vendor's Default General Ledger Account:

1. From the Spectrum Sitemap, go to Accounts Payable-->Maintenance-->Vendors:

2. Select a Vendor, then press Defaults and enter a value for G/L Distribution:

Setting a Cost Type's Default General Ledger Account

To set a Cost Type's Default General Ledger Account:

1. From the Spectrum Sitemap, go to Job Cost-->Maintenance-->Cost Type:

2. Select a Cost Type, then press Edit and enter a value for G/L Account Code: