Set Up the Export Subcontractor Invoices Feature for Sage 300 CRE®

If you have 'Admin' permission on the company's ERP Integrations tool, you can complete the initial setup for the Sage 300 CRE® subcontractor invoices feature so that your team can sync invoices from Procore to Sage 300 CRE®.

• Required User Permissions:

  • to request to turn the feature ON and to designate the Accounting Approver who will be authorized to sync invoices. You must be your company's Procore Administrator to make this request.

  • To complete the initial setup steps below, ‘Admin’ on the company’s ERP Integrations tool and login credentials for your company's hh2 Synchronization Client.

• Requirements:

  • The hh² sync client must be running version 1.31.467.xxxx or higher.

  • The ERP Integrations tool must be enabled on the company account.

  • The ERP Integrations tool must be configured to work with Sage 300 CRE®.

  • The Not Required option but must be set for 'Date Received Usage' and 'Payment Date Usage' in the 'AP Settings - Invoice Settings' in Sage 300 CRE® as described below.

• Additional Information:

  • Some fields in a Procore subcontractor invoice are NOT exported directly to Sage 300 CRE®. Instead, the system first uses those fields to calculate a value and then the calculated value is exported to Sage 300 CRE®. For details, see Sage 300 CRE® - Data Mapping.

• Limitation:

  • If your company is using the ERP Integrations tool to import Sage 300 CRE® tax codes and tax groups into Procore, you will not be able to export subcontractor invoices to Sage 300 CRE®. To learn more about tax codes and groups, see How can I use tax codes on a Procore project? and Set Up the Import Sage 300 CRE® Tax Groups Feature.

1. Configure the hh² Sync Client for Subcontractor Invoice Exports

2. Set the 'Date Received Usage' and 'Payment Date Usage' to Not Required in Sage 300 CRE®

3. Set Up Subcontractor Invoice Exports in Procore

Configure the hh² Sync Client for Subcontractor Invoice Exports

First, configure the settings for subcontractor invoice exports in the hh2 Synchronization Client:

1. Log into your Sage 300 CRE® server using an account with administrative privileges.

2. Launch your company's hh² Sync Client.

    Important

   The hh² sync client must be running version 1.31.467.xxxx or higher.

   

3. Click Connect.

4. Browse to the Local Connections tab.

5. Click Mappings.

6. Click Advanced Mappings.

7. Place a checkmark in these circles:

   • Distribution (AP)

   • Distribution Payment (AP)

   • Invoice (AP)

   • Payment (AP)

   • Invoice Payment (AP)

   • Invoice Settings (AP)

8. Click Save.

Set the 'Date Received Usage' and 'Payment Date Usage' to Not Required in Sage 300 CRE®

Either the Not Used or Not Required option button must be selected for 'Date Received Usage' and 'Payment Date Usage' in the 'AP Settings - Invoice Settings' in Sage 300 CRE®. To learn more about these settings, see your Sage 300 CRE® user guide or help system.

Set Up Subcontractor Invoice Exports in Procore

Next, complete the following setup task in Procore:

Email Your List of Accounting Approvers to Procore

1. Ask your company’s Procore Executive Sponsor to with the following information:

   • Email addresses for the accounting approvers who should be granted the additional permission to export subcontractor invoices to Sage 300 CRE®.

      Note

     • If you do not know your company’s Executive Sponsor, see the Executive Sponsor field under Account Information in the company's Admin tool.

     • If there is no Executive Sponsor listed, contact your company’s Procore Administrator.

2. Wait for your Executive Sponsor to confirm that the Procore ERP Support Team has granted permissions to your company's designated accounting approvers.
   Once permission has been granted, you can begin using the feature.