Skip to main content
Procore

Acumatica® Detailed Data Mapping

Overview


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
COMPANIES erp-orange-arrows.png erp-green-arrows.png VENDORS
PROJECTS
SUB JOBS
erp-orange-arrows.png erp-green-arrows.png PROJECTS
PROJECT TASKS
PROJECT WBS CODES 1   erp-green-arrows.png COST CODES
COST TYPES   erp-green-arrows.png ACCOUNT GROUPS
BUDGETS erp-orange-arrows.png erp-green-arrows.png COST BUDGETS
BUDGET MODIFICATIONS erp-orange-arrows.png   COST BUDGET CHANGE ORDERS
PRIME CONTRACTS erp-orange-arrows.png   REVENUE BUDGET
PRIME CONTRACT CHANGE ORDERS erp-orange-arrows.png   REVENUE BUDGET CHANGE ORDERS
COMMITMENTS
SUBCONTRACTS & PURCHASE ORDERS
COMMITMENT CHANGE ORDERS (CCOs)
erp-orange-arrows.png   COMMITMENTS
SUBCONTRACTS & PURCHASE ORDERS
COMMITMENT CHANGE ORDERS (CCOs)
SUBCONTRACTOR INVOICES erp-orange-arrows.png   PAYABLES
SUBCONTRACT PAYMENTS ISSUED
FOR SYNCED SUBCONTRACTOR INVOICES
  erp-green-arrows.png PAID INVOICES
COSTS
DIRECT COST
JTD COST
  erp-green-arrows.png COSTS
TRANSACTIONAL COST BY INVOICE, EXPENSE, PAYROLL, AND SUBCONTRACTOR INVOICE TYPES

Custom WBS segments are NOT supported at this time.

Companies/Vendors


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
ERP Vendor ID1 erp-orange-arrows.png erp-green-arrows.png Vendor ID
Name erp-orange-arrows.png erp-green-arrows.png Account Name
Address
City
State
ZIP
erp-orange-arrows.png erp-green-arrows.png Address Line 1
City
State
Postal Code
Business Phone erp-orange-arrows.png erp-green-arrows.png Business 1 Phone
Email Address erp-orange-arrows.png erp-green-arrows.png Account Email

1Export Note: The ERP Vendor ID is entered manually by an Accounting Approver when a company is exported from Procore to Acumatica Cloud ERP. This is stored as the ERP Vendor ID (you can view it in the company-level ERP Integration tool under Vendors or in the company-level Directory tool) and is then used on other vendor related exports (Commitments, Commitment CO's). This can be an optional field during exporting if this option has been enabled by Procore.

Projects


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
Project Number erp-orange-arrows.png erp-green-arrows.png Project ID1
Project Name erp-orange-arrows.png erp-green-arrows.png

Description

Address
City
State
Zip
erp-orange-arrows.png erp-green-arrows.png

Address Line 1
City
State
Postal Code

Latitude / Longitude erp-orange-arrows.png erp-green-arrows.png Latitude / Longitude
Start Date/Completion Date erp-orange-arrows.png erp-green-arrows.png Start Date / End Date
Subaccount ID2 erp-orange-arrows.png   Default Sales Subaccount
Template ID3 erp-orange-arrows.png   Template

1 Export note: The Acumatica Cloud ERP Project ID is entered manually by an accounting approver when a project is exported from Procore to Acumatica Cloud ERP. This may, or may not, depending on what the accounting approver has entered, match the Project Number found in Procore under the project-level Admin tool. This is stored as the Acumatica Cloud ERP Project ID (you can view it in the company-level ERP Integrations tool under the Synced section of Projects) and is then used on other project related exports such as Budgets, commitments etc... Import note: If the project is imported from Acumatica Cloud ERP, the project ID will automatically populate in the project number field

2 Export note: The Subaccount ID is entered manually by an accounting approver when a project is exported from Procore to Acumatica Cloud ERP. Its an optional field, only required if the customer has enabled Subaccounts in Acumatica Cloud ERP. If the project is imported into Procore from Acumatica Cloud ERP, the Subaccount ID is not stored on the project in Procore.

3 Export note: The Template ID is entered manually by an accounting approver when a project is exported from Procore to Acumatica Cloud ERP. Its an optional field. If the project is imported into Procore from Acumatica Cloud ERP, the Template ID is not stored on the project in Procore.

Sub Jobs/Project Task


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
Code erp-orange-arrows.png erp-green-arrows.png Task ID
Sub Job Name erp-orange-arrows.png erp-green-arrows.png Description
Cost Code
Cost Code
Description
erp-orange-arrows.png erp-green-arrows.png Cost Code1
Cost Code
Description
Cost Type
Cost Type
erp-orange-arrows.png erp-green-arrows.png Account Group1
Account Group

 

1 Import note: If the Project Task in Acumatica Cloud ERP has cost codes and account groups define on the cost budget tab, then those cost codes and account groups will import along with the Project Task. If there are no cost codes or account groups defined on the cost budget, just the project task will import into Procore.

Standard Cost Codes/Cost Codes

In Procore, the Cost Codes can be found in the Work Breakdown Structure (WBS) section in the Admin Tool under Acumatica Cloud ERP Standard Cost Codes. Custom WBS segments are not supported for the integration at this time.


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
Cost Code   erp-green-arrows.png Cost Code
Description   erp-green-arrows.png Description

Standard Cost Types/Account Groups

In Procore, the Cost Types can be found in the Cost Types section in the Admin Tool under Acumatica Cloud ERP Standard Cost Types.


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
Cost Type   erp-green-arrows.png Account Group
Description   erp-green-arrows.png Description

 

Budgets/Cost Budget

All budgets totals are entered against the Project Task (In Acumatica Cloud ERP>Project>Cost Budget) or the Sub Job (In Procore>Budget Tool)


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
Original Budget Amount erp-orange-arrows.png erp-green-arrows.png Original Budgeted Amount
Sub Job erp-orange-arrows.png erp-green-arrows.png Project Task
Cost Code erp-orange-arrows.png erp-green-arrows.png Cost Code
Category erp-orange-arrows.png erp-green-arrows.png Account Group

Budget Modifications

Budget modifications export from Procore only. In Procore, budget mods are accessed from project-level Budget tool.

When Budget Modifications are exported from Procore, a Cost Budget Change Order is created on the Project in Acumatica Cloud ERP. It will arrive with an "On Hold" status. In Procore, budget modifications are accessed from the Budget Modifications column in the project-level Budget tool. They are used to move money from one budget line item to another, most commonly with a zero net effect.

 Phased Release: Budget Changes

Some ERP integrated clients may have already transitioned from Budget Modifications (Legacy) to the new Budget Changes experience. The legacy experience will continue to be available until November 2024. To learn more about the timeline for migration, see Common Questions.

Choosing to use the new Budget Changes experience will not impact the function of your ERP integration. You should still thoroughly review the available documentation before migrating to the new experience. We recommend you also discuss any concerns or questions about migrating your Budget Modifications to Budget Changes with your Procore point of contact. 

To learn more about the new Budget Changes experience, see About Budget Changes.


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
Change Date1 erp-orange-arrows.png   Change Date
Sub Job erp-orange-arrows.png   Project Task
Cost Code erp-orange-arrows.png   Cost Code
Cost Type erp-orange-arrows.png   Account Group
Budget Modification Amount erp-orange-arrows.png   Amount

 

1 Export note: The Change Date is entered manually by an accounting approver when the budget mod is exported from Procore to Acumatica Cloud ERP.

Prime Contracts

Prime Contracts export from Procore only. Prime contracts in Procore automatically sync to Acumatica Cloud ERP as a summarized single line item within the Revenue Budget tab. Your prime contract is automatically synced when the following conditions are met:

  • The project is synced with Acumatica Cloud ERP.
  • A prime contract exists in the 'Approved' status.
  • At least one (1) line item with a non-zero value has been added to the contract's schedule of values (SOV).
  • The contract number must consist of no more than seven (7) alphanumeric characters.

This automatic sync detects changes made to the contract's value in Procore as they occur, and updates the corresponding summarized value in Acumatica Cloud ERP accordingly.


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
Amount
(Schedule of Values tab)
erp-orange-arrows.png   Original Budgeted Amount (Project Revenue Budget)

1 Prime Contract Number can be changed before export in the ERP Integrations tool, resulting in a non-matching number between the corresponding fields. If Auto Numbering is enabled in Acumatica Cloud ERP, the Prime Contract number in Acumatica Cloud ERP will be the next system generated number.

Prime Contract Change Orders

Prime Contract Change Orders (PCCOs) export from Procore only. When entering the SOV for a PCCO in Procore, you have the option of selecting an existing line item, or entering a new line item. In Procore, PCCOs are accessed from the project level Prime Contracts tool under Change Orders. In Acumatica Cloud ERP, the change(s) will appear as a Revenue Change Order with a Status of On Hold


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
System Date at Time of Prime Contract Creation erp-orange-arrows.png   Change Date
Approval Date
PCCO Number1 erp-orange-arrows.png   Reference Nbr
External ID
Title (General tab) erp-orange-arrows.png   Description
Description (Schedule of Values tab) erp-orange-arrows.png   Description
Project Number
Sub Job
erp-orange-arrows.png   Project
Project Task 2 
Cost Code (Schedule of Values tab) erp-orange-arrows.png   Cost Code (Cost Budget Tab)
Cost Type (Schedule of Values tab) erp-orange-arrows.png   Account Group (Cost Budget Tab)
Potential Change Order Amount erp-orange-arrows.png   Amount (Cost Budget Tab)
Potential Change Order Amount + Markup(s) Amount erp-orange-arrows.png   Amount (Revenue Budget Tab)

1 PCCO Number can be changed before export in the ERP Integrations tool, resulting in a non-matching number between the corresponding fields. If Auto Numbering for Change Orders is enabled in Acumatica Cloud ERP, the Change Order number in Acumatica Cloud ERP will be the next system generated number.

2 The Project Task created for PCCOs will only be used on Revenue Budget lines. Cost Budget lines will use the existing Tasks associated with each Budget Code on the SOV.

 

Commitments

Commitments export from Procore only. When a Commitment (Subcontract or Purchase Order) is exported from Procore, a commitment is automatically created in Acumatica Cloud ERP. For Subcontracts a status of Open will be used in Acumatica Cloud ERP. The Project used in Procore will be sent to the Project field on the commitment line item in Acumatica Cloud ERP. For Purchase Orders, a status of Open will be used in Acumatica Cloud ERP. For Purchase Orders, the type of Normal will be used in Acumatica Cloud ERP. In Procore, Commitments are accessed from the project-level Commitments tool. 


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
System Date at Time of Commitment Creation erp-orange-arrows.png   Date
Start Date (Subcontract)
Delivery Date (Purchase Order)
erp-orange-arrows.png   Start Date (Subcontract)
Promised On (Purchase Order)
Commitment #1 erp-orange-arrows.png   Subcontract Nbr (for Subcontracts)
Order Nbr (for Purchase Orders)
External Ref (Subcontracts and Purchase Orders)
Contract Company erp-orange-arrows.png   Vendor
Title (General tab) erp-orange-arrows.png   Description
Default Retainage erp-orange-arrows.png   Retainage Percent

Budget Code (Schedule of Values tab)

Sub Job
Cost Code
Cost Type

erp-orange-arrows.png   Project Task
Cost Code
Inventory ID2
Description (Schedule of Values tab) erp-orange-arrows.png   Line Description
Qty (Schedule of Values tab), if applicable erp-orange-arrows.png   Order Qty
Unit Cost (Schedule of Values tab), if applicable erp-orange-arrows.png   Unit Cost
Amount
(Schedule of Values tab)
erp-orange-arrows.png   Ext. Cost

1Commitment # can be changed before export in the ERP Integrations tool, resulting in a non-matching number between the corresponding fields. If Auto Numbering for Subcontracts and/or Purchase Orders is enabled in Acumatica Cloud ERP, the Subcontract/Purchase Order number in Acumatica Cloud ERP will be the next system generated number.

2The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in Acumatica Cloud ERP

Commitment Change Orders

Commitment Change Orders export from Procore only. When entering the SOV for a Commitment Change Order in Procore, you have the option of selecting an existing line item, or entering a new line item. In Procore, Commitment Change Orders are accessed from the project level Commitments tool under Commitment Record. In Acumatica Cloud ERP, the change(s) will appear as a Commitment Change Order with a Status of Closed


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
System Date at Time of Commitment Creation erp-orange-arrows.png   Change Date
Approval Date
Commitment Change Order #1 erp-orange-arrows.png   Change Order Reference Nbr
External Reference Nbr
Contract Company erp-orange-arrows.png   Vendor
Title (General tab) erp-orange-arrows.png   Description
Description (Schedule of Values tab) erp-orange-arrows.png   Description
Project Number
Sub Job
erp-orange-arrows.png   Project
Project task
Cost Code (Schedule of Values tab) erp-orange-arrows.png   Cost Code
Cost Type (Schedule of Values tab) erp-orange-arrows.png   Inventory ID2
Qty (Schedule of Values tab), if applicable erp-orange-arrows.png   Quantity
Unit Cost (Schedule of Values tab), if applicable erp-orange-arrows.png   Unit Cost
Amount
(Schedule of Values tab)
erp-orange-arrows.png   Amount
Description
(General tab)
erp-orange-arrows.png   Detailed Description

 

1Commitment Change Order # can be changed before export in the ERP Integrations tool, resulting in a non-matching number between the corresponding fields. If Auto Numbering for Change Orders is enabled in Acumatica Cloud ERP, the Change Order number in Acumatica Cloud ERP will be the next system generated number.

2The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in Acumatica Cloud ERP

Job Costs

Job costs import from Acumatica Cloud ERP only. Cost information is retrieved from Acumatica Cloud ERP for each Sub Job/Cost Code/Category on Synced projects for use in 2 locations in Procore, the Budget and the Job Costs report. If Job Cost Transaction Syncing is enabled on the Procore Project, cost transaction from Acumatica Cloud ERP are imported into the Direct Cost tool for each project. This provides transaction detail for the costs displayed in Procore, and if the budget view is configured properly the values of those transactions can be viewed into the Direct Costs or JTD Cost columns for a budget line item. 


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
DIRECT COST TYPE     DIRECT COST TYPE

Invoice

  erp-green-arrows.png Invoices
Subcontractor Invoice   erp-green-arrows.png Commitment Invoices
Payroll   erp-green-arrows.png Payroll
Expense   erp-green-arrows.png Misc Expenses
DIRECT COST      
Date   erp-green-arrows.png Date
Status   erp-green-arrows.png Automatically set to Approved
Employee   erp-green-arrows.png  
Description   erp-green-arrows.png Description
Vendor   erp-green-arrows.png Vendor (Only for transactions that originate from Accounts Payable)
Invoice #   erp-green-arrows.png Invoice (Only for transactions that originate from Accounts Payable)
Budget Code   erp-green-arrows.png Project Task
Cost Code
Account Group
Qty   erp-green-arrows.png Quantity
Unit Cost   erp-green-arrows.png Unit Rate
Amount   erp-green-arrows.png Amount
BUDGET      
JTD Cost   erp-green-arrows.png Actual Amount
Direct Costs   erp-green-arrows.png JTD Cost - Commitment Invoiced1
JOB COSTS REPORT      
Sub Job   erp-green-arrows.png Project Task
Cost Code   erp-green-arrows.png Cost Code
Cost Type   erp-green-arrows.png Account Group
Original Budget   erp-green-arrows.png Original Budgeted Amount
Original Budget Units   erp-green-arrows.png Original Budgeted Quantity
Approved Budget Changes   erp-green-arrows.png Budgeted CO Amount
Approved Budget Unit Changes   erp-green-arrows.png Budgeted CO Quantity
Revised Budget   erp-green-arrows.png Revised Budgeted Amount
Revised Budget Units   erp-green-arrows.png Revised Budgeted Quantity
Commitment Invoiced   erp-green-arrows.png Committed Invoiced Amount
Job To Date Cost   erp-green-arrows.png Actual Amount

1Direct costs is calculated from Job To Date Cost minus Commitment Invoiced.

Subcontractor Invoices

When a subcontractor invoice is exported from Procore to Acumatica Cloud ERP, an AP Bill is automatically created in Acumatica Cloud ERP. In Procore, Subcontractor Invoices are accessed from Invoices in the project Commitments tool. In Acumatica Cloud ERP, the Bill will have a status of On Hold. NOTE: For customers who have multiple Cash Accounts in Acumatica, Procore will export subcontractor invoices to the Cash Account defined on the Acumatica project>USER-DEFINED FIELDS.


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP
Billing Date erp-orange-arrows.png   Date
Project erp-orange-arrows.png   Project
Commitment # erp-orange-arrows.png   Subcontract Nbr.
Overall Comments erp-orange-arrows.png   Description
Contractor Company erp-orange-arrows.png   Supplier
Invoice #1 erp-orange-arrows.png   Reference Nbr
Supplier Ref
Payment Due erp-orange-arrows.png   Amount
Budget Code (Detail Tab)
Sub Job
Cost Code
Cost Type
erp-orange-arrows.png   Project Task
Cost Code
Inventory ID2
This Period (Detail Tab) erp-orange-arrows.png   Amount

Work Retainage Held %
Work Retainage Held $

Work Retainage Released %

Work Retainage Released $

erp-orange-arrows.png  

Retainage Held Amount
Retainage Held Percent

Retainage Released Amount

Retainage Released Percent

Accounting Date erp-orange-arrows.png  

 

Date

1If Auto Numbering for Bills is enabled in Acumatica Cloud ERP, the Reference Number in Acumatica Cloud ERP will be the next system generated number.

2The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in Acumatica Cloud ERP

Commitment Payments Issued

Commitment Payments Issued imported from Acumatica Cloud ERP only. When a subcontractor invoice is exported from Procore to Acumatica Cloud ERP, an AP Bill is automatically created in Acumatica Cloud ERP. When the AP Bill is paid the payment information will flow back to Procore. In Procore, Subcontractor Invoices Payments are accessed from Payments Issued in the project Commitments tool. In Acumatica Cloud ERP, payments are accessed from Payables>Checks and Payments.


PROCORE
Exports data from Procore to Acumatica Cloud ERP  Imports data from Acumatica Cloud ERP to Procore
Acumatica Cloud ERP

Invoices

  erp-green-arrows.png n/a
Date   erp-green-arrows.png Post Date
Payment #   erp-green-arrows.png Reference Nbr
Invoice #   erp-green-arrows.png Supplier Ref
Check / Ref #   erp-green-arrows.png Payment Ref
Amount   erp-green-arrows.png Payment Amount