Subcontracts

Visual Mapping

Exporting Subcontracts to Foundation

After exporting a Purchase Order, Subcontract, or Purchase Order/Subcontract Change Order, you can find them in Foundation by following these steps:

1. From the Foundation homepage, go to PO/Subcontract --> PO/Sub and Change Order Sync:

2. Select the Report tab. Alternatively, you can apply specific filters (e.g. to Jobs like the below screenshot) to make sure you return Subcontracts that meet your needs.

3. In the Report tab, select the "Import" checkbox for the Subcontract, and then press the Import button:

4. After importing, press the OK button to confirm there are no validation errors or issues.

You can also check the Item Detail tab to confirm that line items imported as expected:

5. Press OK again. If there are no issues, you will see a confirmation that the Purchase Order or Subcontract has successfully imported into Foundation.

Purchase Order or Subcontract Line Item Ledger Account

Since most Project Management systems do not have a Ledger Account, Agave will default to the Ledger Account associated with the Cost Type (Cost Class). The default Ledger Account associated with the Cost Type can be found below:

note

We recommend assigning a Default General Ledger Account for each Cost Type. This will prevent the need to manually input the Ledger Account in Foundation for each Purchase Order, Subcontract, or Subcontractor Change Order you export to Foundation.

FAQs and Common Errors

Why am I getting an error saying a record already exists even though I deleted it?

You may have deleted a record but still receive an error saying the record exists after re-syncing it (example below). Alternatively, You may need to modify and re-sync a Purchase Order, Subcontract, or Purchase Order/Subcontract Change Order record in the Project Management system after it has been exported to Foundation.

Depending on the status of the export, you have a two options:

If the record has not been imported in Foundation (i.e. it has a status of "Imported" or is in the PO/Sub and Change Order Sync view):

1. From the main menu, select PO/Subcontract

2. Select the PO/Sub and Change Order Sync view

3. Press Report, then select the Delete checkbox. Then press Delete

If the record has been imported in Foundation (i.e. it does NOT have a status of "Imported" or is visible in either the Enter PO/Subs or Enter Change Orders views), you can either modify the record manually with details from your Project Management system, or:

1. Delete the record from either the Enter PO/Subs or Enter Change Orders views. You can do this by pressing the trashcan icon in the toolbar.

2. From the main menu, select Controls --> Purge Data.

3. Scroll down to the P/S Purges section and select PO/Subs.

4. In the Criteria tab, input the criteria for your report, then press the Report tab. Assuming the records match what you want to delete, either press "Ctrl + U" or Purge --> Purge Selected Records in the toolbar.

Error: The executed date field is required.

Foundation requires a date field when creating Subcontracts.

To resolve this error:

1. Go to the Subcontract in Procore.

2. Scroll down to the Contract Dates section.

3. Add a date under Contract Date:

tip

To avoid this error, we recommend making the Contract Date field required. See Procore's Guide on how to make this field required.