Sage Intacct®: Setup Guide

Welcome to the Sage Intacct® Setup Guide

On these pages, we will walk through a number of key things to know as you prepare for and complete your implementation of the Sage Intacct® integration.

If you have questions, be sure to direct them to your Integration Implementation Specialist or your Procore point of contact.

The navigation menu to the left will walk you through each of the key things to know and will highlight action items required of you. 

Prerequisites

Sage Intacct® subscriptions

In order to use Procore's integration with  Sage Intacct®, the following subscriptions will need to be enabled in Sage Intacct®:

  • Web Services
  • Construction

To enable these, go to CompanyAdminSubscriptions

  1. Find ‘Web Services’ and click on it to Subscribe.

  2. Repeat the process for "Construction Subscription".  Sage Intacct® will have an additional charge for this.  Please consult your Sage reseller about this.

  3. Click Done when finish.

CONNECTION REQUIREMENTS

  • Within Procore:   Your Integration Implementation Specialist will ask you to add the required DMSA Apps to your account, more information here: ERP DMSA App Installation Guide

Create Web Service User

Web Server Users are used to access the Sage Intacct® data.  They are automatically limited to the API through Web Service access.  In other words, they can't be used to log into the company through the User Interface.

  1. In Sage Intacct® navigate to CompanyAdminWeb Service Users 

  2. Click ADD 

  3. Input values for these fields

    1. Enter a User ID for this user.  This cannot be the User ID of an existing standard user.

    2. Enter a Last name for this user

    3. Enter a First name for this user

    4. Enter the Email address for this user.  

    5. Enter a User name, which will identify user in the Web Services Users list.

    6. For the User Type, select Business User 

    7. The Admin privileges should be set to Full

    8. Status should be set to Active

    9. Navigate to the Roles information tab.  

    10. Select a role that has "Full Admin" rights

  4. Click SAVE 

 

 To confirm that the Role has Full Admin permissions, do the following

  1. In Sage Intacct®, navigate to CompanyAdminRoles

  2. Find the Role assigned to the Web Service User

  3. Click on SUBSCRIPTIONS 

  4. Click on Permissions on the first module.  

  5. Confirm Permission is set to "All" and click Save

  6. Repeat this process for each module after that.

  7. Click SAVE

 

 

 

Company Setup to use Sender ID and ISO country codes

Add the Procore Sender ID to the allowed list. 

1. Company → Setup → Company

2. Click Edit

3. Click on the Security tab

4. Go to the section labeled Web Services authorizations and add the Sender ID ProcoreMPP-DEV

clipboard_e0e1aa0fc4d9b48a447327ab605882f25.png

To reduce the number of issues when the Province/State do not match the country code on the Vendor setup, use the Use ISO country code option in Sage Intacct®.

  1. Navigate to Company → Setup → Company
  2. Click Edit.
  3. Under Company information check the box "Use ISO country codes"
  4. Click Save to confirm the selection

Procore Specific Purchasing Configuration

Three specific Purchasing Transaction Definitions will be required in order to export commitments from Procore to Sage Intacct®.

General Purchasing Configuration
  1. Navigate to Purchasing → Setup → Configuration.
  2. In the Unit of measure section:
    1. Select a Default Group from the dropdown menu.
    2. 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'.
    1. This enables the importation of commitments that are amount-based.
Transaction Definitions Used in the Sage Intacct® Integration
  • PC Purchase Orders 

  • PC Subcontracts

  • PC Change Orders

  • PC Commitment Invoices

 

clipboard_eb4eb9487b159bdfe0d0f1f7a233d4dd4.png

 

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

 

 

Create a PC Purchase Orders Transaction Definition:

  1. Navigate to PurchasingSetupTransaction Definitions

  2. Click ADD

  3. Input the following values into the Properties section: 

    1. Template name: PC Purchase Orders

    2. Description:  This field is optional, but can be Procore Purchase Orders.

    3. Template type: Order

    4. Workflow category: Order

    5. Status: Active

    6. Ensure that Enable primary document workflow is checked

    7. Ensure that Enable Change order workflow is checked

    8. Document type: Source Document

    9. Transaction numbering will not need to be enabled

 

clipboard_eec407f45afbf95106c7258343139546a.png

 
  1. Now enter values into the Accounting section

    1. For Transaction posting, it needs to be set to "Do not post".  If you need another selection, please consult with your Sage Intacct® consultant. 

    2. Be sure that Enabled retainage is selected as in the below screenshot.

 

clipboard_eaa309691a64fe3a4531a0f49d3a05b80.png

  1. Now enter the values into the Workflow section

    1. In the Partial conversion handling section, select Leave Transaction Open

    2. For the Default AP term, from the dropdown menu select the most common AP term, such as Net 30

 

clipboard_eb5cbc38c2e9701c1ba69934aef22eab1.png

 
  1. Under the Additional information section, ensure that Enable Scope and Enable external reference are selected

  2. If you selected General Ledger for Transaction posting, please consult your Accounting team on what to use on the Posting Configuration tab.

  3. Navigate to the Security Configuration tab.

    1. For the Document permissions section, the following settings will need to be applied:

    2. The Edit policy needs to be set to "All".

    3. The Allow edit of vendor should be set to "Never".

    4. The Delete policy needs to be set to "All".

    5. The Create policy needs to be set to "New document or Convert"

    6. The option Create transactions in needs to be set to "Top level or Entity" 

  4. Click Save

 

 

Create a PC Subcontract Transaction Definition:

  1. Navigate to PurchasingSetupTransaction Definitions

  2. Click ADD

  3. Input the following values into the Properties section: 

    1. Template name: PC Subcontracts

    2. Description:  This field is optional, but can be Procore Subcontract

    3. Template type: Order

    4. Workflow category: Order

    5. Status: Active

    6. Ensure that Enable primary document workflow is checked

    7. Ensure that Enable Change order workflow is checked

    8. Document type: Source Document

    9. Transaction numbering will not need to be enabled

 

clipboard_e7ef57c3d303af7950b13790145645da7.png

  1. Now enter values into the Accounting section

    1. For Transaction posting, it needs to be set to "Do not post".  If you need another selecting, please consult with your Sage Intacct® consultant. 
    2. Be sure that Enabled retainage is selected as in the below screenshot. clipboard_eaa309691a64fe3a4531a0f49d3a05b80.png

  2. Now enter the values into the Workflow section

    1. In the Partial conversion handling section, select Leave Transaction Open

    2. For the Default AP term, from the dropdown menu select the most common AP term, such as Net 30

  3. Under the Additional information section, ensure that Enable Scope and Enable external reference are selected

  4.  If you selected General Ledger for Transaction posting, please consult your Accounting team on what to use on the Posting Configuration tab.

  5. Navigate to the Security Configuration tab.

    1. For the Document permissions section, the following settings will need to be applied:

    2. The Edit policy needs to be set to "All".

    3. The Allow edit of vendor should be set to "Never".

    4. The Delete policy needs to be set to "All".

    5. The Create policy needs to be set to "New document or Convert"

    6. The option Create transactions in needs to be set to "Top level or Entity" 

  6. Click Save

 

 

Create a PC Change Orders Transaction Definition:

 
  1. Navigate to PurchasingSetup Transaction Definitions

  2. Click Add

  3. Input values into the Properties section

    1. Template name: PC Change Orders

    2. Description is optional, but can be Procore Change Orders

    3. Template type: Order

    4. Workflow category: Order

    5. Status: Active

    6. Ensure that Enable Change order workflow is checked

    7. Document type: Change Document

    8. Transaction numbering will now need to be enabled, can be setup in Company  Setup Document numbering

      1. This can be called anything, but recommended is "Commitment Change Orders".

  4. Now enter values into the Accounting section

    1. For Transaction posting, consult with your Sage Intacct® consultant on whether you will want to make posting entires or not.

    2. Be sure that Enabled retainage is selected.

  5. Enter the following values into the Workflow section:

    1. For Partial conversion handling, select "Close Transaction".
    2. In the Default AP term dropdown, select the default AP term such as "Net 30".  This must be selected, but the vendor will override it, if it is different.

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, please consult your Accounting team on what to use on the Posting Configuration tab.

  1. Navigate to the Security Configuration tab.

    1. For the Document permissions section, the following settings will need to be applied:

    2. The Edit policy needs to be set to "All".

    3. The Allow edit of vendor should be set to "Never".

    4. The Delete policy needs to be set to "All".

    5. The Create policy needs to be set to "New document or Convert"

    6. The option Create transactions in needs to be set to "Top level or Entity" 

  2. Click Save

 

Create a PC Commitment Invoices Transaction Definition:

  1. Navigate to Purchasing → Setup → Transaction Definitions
  2. Click Add
  3. Input values into the Properties section
    1. Template name: PC Commitment Invoices
    2. Template type: Invoice
    3. Workflow category: Invoice
    4. Status: Active
    5. Transaction numbering: Vendor Invoice
  4. clipboard_eb631a89190a2abb513764a0b6df82588.png
  5. In the Transaction numbering section, select Vendor Invoice
  6. Input values into the Accounting section
    1. Transaction posting:  Account Payable
    2. Ensure that Enable retainage is selected
    3. clipboard_e310916c943064a1eba048db0ada061f4.png
  7. Input values into the Workflow section
    1. Transaction Conversion: PC Subcontracts and PC Purchase Orders
    2. Partial conversion handling: Leave Transaction Open
    3. clipboard_e7f22856eced8a8fee6ecfa7e195d6499.png
  8. Navigate to the Posting Configuration tab
    1. Under Item GL Group, select all cost types that will be used in Procore
    2. Choose the appropriate Debit/Credit and GL Account information that should be associated with these cost types
    3. At least one account needs to be selected as “Is Offset
  9. Click Save

 

Unit of Measure Group

In order for subcontracts and commitments to be exported successfully from Procore to Sage Intacct®, two Unit of Measure Groups, called EA and Is, will need to be created.

Explanation:

The Procore and Sage Intacct® integration is hard coded to use two Unit of Measure Groups: EA and Is.

To create the Unit of Measure Groups follow the steps below in order, twice. First to create the group EA and again to create the group Is:

  1. In Sage Intacct®, go to Purchasing  Setup tab  More  Units of measure

  2. Click the Add button to add a new Unit of measure group.

  3. In the Unit of measure group name field, enter EA for the name for the unit of measure group (or Is if EA has already been created).

  4. In the Base unit field, enter EA (or Is if EA has already been created).

  5. In the Abbreviation field, enter abbreviation EA (or Is if EA has already been created).

  6. Enter all of the Units of Measure you want to use from Procore in the related units section. For example, ls is used for lump sum, ea and Each are used for Each. These can also be added to an existing Unit of Measure group if needed.

  7. When you have completed entering the related units, click Save. The Units of Measure list appears and displays the new Unit of Measure Group.

NOTE:  Any Unit of Measure used in Procore will need to be set up in Sage Intacct® as a Unit of Measure Group.

General Ledger Custom Fields

When using the Procore integration with Sage Intacct®, two Custom Fields will need to be created: PC Account Type and PC Cost Types

 
  1. To create those fields, navigate to Platform ServicesCustom Fields  or to Customization Services Custom Fields

clipboard_efc705c9945070cf9ecc33be36ac1ab7c.png

  1. The first custom field is called PC_ACCOUNT_TYPE.

    1. Click Add

    2. On "Step 1: Choose Object to Extend" select GL Account and click Next

    3. On "Step 2: Choose Field Data Type"  select Picklist and click Next

    4. On "Step 3: Choose Pick List Field Characteristics" enter the following: 

      1. For the Label enter PC Account Type

      2. Enter for Pick Values: Payroll, Expense, and Cash per snippet below

      3. Type in the Field ID box, PC_ACCOUNT_TYPE and click Next

    5. Click Done

  2. The second custom field is called PC_COST_TYPES

    1. Click Add

    2. On "Step 1: Choose Object to Extend" select GL Account and click Next

    3. On "Step 2: Choose Field Data Type"  select Picklist and click Next

    4. On "Step 3: Choose Pick List Field Characteristics" enter the following: 

      1. For the Label enter PC Cost Types

      2. Enter for Pick Values: Payroll and Expense per snippet below

      3. Type in the Field ID box, PC_COST_TYPES and click Next

    5. Click Done

Once this is done, these will need to be added to the GL accounts that will bring costs over to Procore.

  1. In Sage Intacct® go to General Ledger > All > General Ledger Accounts
  2. Select the GL account that needs to be updated, by clicking Edit
  3. In the PC Account Type, select the appropriate account type:  Payroll, Expense, Cash
  4. In the PC Cost Types, select either Payroll or Expense.
  5. Click Save to confirm the changes.
  6. Repeat for any additional GL accounts that need to be modified.
  7. Click Done when done.

clipboard_e77c927fa534338ecd4932c09a92b2b16.png

Item ID Setup

An Item ID needs to be set up for your Standard Cost Types.

Each Standard Cost Type needs to have an Item assigned to it. 

  1. Go to Purchasing → Setup → Items

  2. Click Add to add a new Item.

  3. The Item type has to be Non-Inventory.

  4. Enter the Item ID, such as M for Materials 

  5. Enter the Name for the Item ID, such as Materials.

  6. Select the Base unit of EA from the list.

    Note:  This is required for using commitments imported from Procore.
  7. Click Save when done.

Standard Cost Types

Sage Intacct® has the ability to have hierarchical cost types.  Procore does not support hierarchical cost types.  All cost types used in the Procore/Sage Intacct® integration will be the Parent Cost Types that are setup in Sage.

Steps to create a Standard Cost Type.

  1. Got to Projects → Setup → Standard cost type catalog

  2. Click the Add button

  3. For the ID, enter the ID needed for this cost type

  4. A Name is required for the Cost Type.  Enter an appropriate name for the Cost Type

  5. Select the appropriate GL account

  6. Select the appropriate Item from the drop down menu

  7. Other fields on this setup are optional.

  8. Click the Save button

Standard Cost Codes

Sage Intacct® refers to Standard Cost Codes as Standard Tasks.  When setting up a Standard Cost Code in Sage Intacct®, the ID will need to include the Parent ID.

Steps to create a new Standard Cost Code (Tasks) in Sage Intacct®:

  1. Got to Projects → Setup → Standard tasks catalog (Note this may be renamed to Standard cost code catalog)
  2. Click the Add button

  3. For the ID, enter the ID needed for this task including the Parent ID

  4. A Name is required for the Cost Type.  Enter an appropriate name for the Cost Type

  5. Select the Parent ID from the drop-down menu

  6. Other fields on this setup are optional.

  7. Select the Standard Cost types needed for this task.

  8. Click the Save button

NOTE:  Cost codes (Standard tasks) must use either the dash/hyphen as the delimiter or use the dot.  A combination dashes and dots is not supported.

 

Sage Intacct® Entities

Please discuss with your Integration Implementation Specialist about entitiy support in Sage Intacct®.