Procore Specific Purchasing Configurations

Note

All settings must be configured at the TOP LEVEL.

Exporting commitments from Procore to Sage Intacct® requires one general purchasing configuration and four specific Purchasing Transaction Definitions.

General Purchasing Configuration

  1. Navigate to Purchasing → Setup → Configuration.

  2. In the Unit of measure section:

    • Select a Default Group from the dropdown menu.

    • Check the "Enable Custom units of measure" box.

  3. In the Enable functionality section, check the box for 'Convert transactions by price - Allow override of item's default conversion type'.

    • This enables the importation of commitments that are amount-based.

Transaction Definitions Used in the Sage Intacct® Integration

These transaction definitions can be configured to meet your organization’s needs combined with the following Procore specific requirements.

Create a PC Contract Transaction Definition

Important

Perform these steps twice: once for PC Purchase Orders and once for PC Subcontracts.

  1. Navigate to Purchasing → Setup → Transaction Definitions.

  2. Click Add.

  3. Input the following values into the Properties Section:

    • Template name: PC Purchase Orders / PC Subcontracts

    • Description: Procore Purchase Orders / Procore Subcontracts

    • Template type: Order

    • Workflow category: Order

    • Status: Active

    • Enable primary document workflow: Checked

    • Enable Change order workflow: Checked

    • Document type: Source Document
      Note: Transaction numbering will not need to be enabled.

  4. Input the following values into the Accounting Section:

    • Transaction posting: Set to Do not post.
      Note: Consult your Sage Intacct® consultant if a different selection is required.

    • Enabled retainage: Checked.

  5. Input the following values into the Workflow Section:

    • Partial conversion handling: Leave Transaction Open.

    • Default AP term: Select your most common term (e.g., Net 30).

  6. Under the Additional information section, ensure that Enable Scope and Enable external reference are selected
    Note: If you selected General Ledger for Transaction posting, consult your Accounting team regarding the Posting Configuration tab.

  7. Navigate to the Security Configuration Tab and input the following values:

    • Edit policy: All.

    • Allow edit of vendor: Never.

    • Delete policy: All.

    • Create policy: New document or Convert.

    • Create transactions in: Top level or Entity.

  8. Click Save.

Create a PC Change Orders Transaction Definition

  1. Navigate to Purchasing → Setup → Transaction Definitions.

  2. Click Add.

  3. Input the following values into the Properties Section:

    • Template name: PC Change Orders

    • Description: Procore Change Orders

    • Template type: Order

    • Workflow category: Order

    • Status: Active

    • Enable Change order workflow: Checked

    • Document type: Change Document

    • Transaction numbering: Must be enabled. (Recommended name: "Commitment Change Orders").

  4. Input the following values into the Accounting Section:

    • Transaction posting: Consult your Sage Intacct® consultant on whether to post entries.

    • Enabled retainage: Checked.

  5. Input the following values into the Workflow Section:

    • Partial conversion handling: Close Transaction.

    • Default AP term: Select your most common term (e.g., Net 30).

  6. Under the Additional information section, ensure that Enable Scope and Enable external reference are selected
    Note: If you selected General Ledger for Transaction posting, consult your Accounting team regarding the Posting Configuration tab.

  7. Navigate to the Security Configuration Tab and input the following values:

    • Edit policy: All.

    • Allow edit of vendor: Never.

    • Delete policy: All.

    • Create policy: New document or Convert.

    • Create transactions in: Top level or Entity.

  8. Save.

Create a PC Commitment Invoices Transaction Definition

  1. Navigate to Purchasing → Setup → Transaction Definitions.

  2. Click Add.

  3. Input the following values into the Properties Section:

    • Template name: PC Commitment Invoices

    • Template type: Invoice

    • Workflow category: Invoice

    • Status: Active

    • Transaction numbering: Vendor Invoice

  4. Input the following values into the Accounting Section:

    • Transaction posting: Accounts Payable

    • Enabled retainage: Checked.

  5. Input the following values into the Workflow Section:

    • Transaction conversion: Select both PC Subcontracts and PC Purchase Orders.

    • Partial conversion handling: Leave Transaction Open.

  6. Navigate to the Posting Configuration Tab and input the following values:

    • Item GL Group: Select all cost types that will be used in Procore.

    • GL Mapping: Choose the appropriate Debit/Credit and GL Account information associated with these cost types.

    • Offset: Ensure at least one account is selected as Is Offset.

  7. Click Save.