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			VENDORS
PROJECTS			PROJECTS
COST TYPES			ACCOUNT GROUPS
BUDGETS			COST BUDGETS
BUDGET MODIFICATIONS			COST BUDGET CHANGE ORDERS
PRIME CONTRACTS			REVENUE BUDGET
PRIME CONTRACT CHANGE ORDERS			REVENUE BUDGET CHANGE ORDERS
PRIME CONTRACT INVOICES			ACCOUNTS RECEIVABLE INVOICES
COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs)			COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs)
SUBCONTRACTOR INVOICES SUBCONTRACTS & PURCHASE ORDERS			ACCOUNTS PAYABLE INVOICES
SUBCONTRACT PAYMENTS ISSUED FOR SYNCED SUBCONTRACTOR INVOICES			PAID INVOICES
COSTS DIRECT COST JTD COST			COSTS TRANSACTIONAL COST BY INVOICE, EXPENSE, PAYROLL, AND SUBCONTRACTOR INVOICE TYPES

Companies/Vendors

PROCORE	Exports data from Procore to Acumatica Cloud ERP	Imports data from Acumatica Cloud ERP to Procore	Acumatica Cloud ERP
ERP Vendor ID¹			Vendor ID
Type			Vendor Class
Name			Account Name
Address City State ZIP			Address Line 1 City State Postal Code
Business Phone			Business 1 Phone
Email Address			Account Email

¹Export 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			Project ID
Project Name			Description
Address City State Zip			Address Line 1 City State Postal Code
Latitude / Longitude			Latitude / Longitude
Start Date/Completion Date			Start Date / End Date
Subaccount ID			Default Sales Subaccount
Template ID			Template

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			Cost Code
Description			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			Account Group
Description			Description

Budgets/Cost Budget

Budget export from Procore only. All budgets totals are entered against the main 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
Work Breakdown Segment			Project Task
Cost Code			Cost Code
Cost Type			Account Group
Sub Job			Project Task
Task			Project Task
Original Budget Amount			Original Budgeted Amount

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 Date¹			Change Date
Sub Job			Project Task
Cost Code			Cost Code
Cost Type			Account Group
Budget Modification Amount			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 import only from the Acumatica projects' Revenue Budget.

PROCORE	Exports data from Procore to Acumatica Cloud ERP	Imports data from Acumatica Cloud ERP to Procore	Acumatica Cloud ERP
#
Description			Original Budgeted Amount (Project Revenue Budget)
Original Contract Amount
Schedule of Values
Budget Code			Project Task + Cost Code + Account Group
Description			Description
Amount			Original Budget Amount

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			Change Date Approval Date
PCCO Number¹			Reference Nbr External ID
Title (General tab)			Description
Description (Schedule of Values tab)			Description
Project Number Sub Job			Project Project Task ²
Cost Code (Schedule of Values tab)			Cost Code (Cost Budget Tab)
Cost Type (Schedule of Values tab)			Account Group (Cost Budget Tab)
Potential Change Order Amount			Amount (Cost Budget Tab)
Potential Change Order Amount + Markup(s) Amount			Amount (Revenue Budget Tab)

¹ 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.

² 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			Date
Start Date (Subcontract) Delivery Date (Purchase Order)			Start Date (Subcontract) Promised On (Purchase Order)
Commitment #¹			Subcontract Nbr (for Subcontracts) Order Nbr (for Purchase Orders) External Ref (Subcontracts and Purchase Orders)
Contract Company			Vendor
Title (General tab)			Description
Default Retainage			Retainage Percent
Budget Code (Schedule of Values tab) Sub Job Cost Code Cost Type²			Project Task Cost Code Inventory ID²
Description (Schedule of Values tab)³			Line Description³
Qty (Schedule of Values tab), if applicable			Order Qty
Unit Cost (Schedule of Values tab), if applicable			Unit Cost⁴
Amount (Schedule of Values tab)			Ext. Cost

¹Commitment # 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.

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

³If the SOV line description is left blank, Acumatica Cloud ERP will populate the Acumatica Cloud ERP contract lline by default Base Unite set up for the {{int.

4Amount-based contract lines receive a default Unit qty of 1 when integrated to Acumatica Cloud ERP. For Amount Based contracts (i.e., Procore Subcontracts), UOM is determined on the Acumatica Cloud ERP contract line by the default Base Unit set up for the Acumatica Cloud ERP Inventory ID associated with that line.

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			Change Date Approval Date
Commitment Change Order #¹			Change Order Reference Nbr External Reference Nbr
Contract Company			Vendor
Title (General tab)			Description
Description (Schedule of Values tab)			Description
Project Number Sub Job			Project Project task
Cost Code (Schedule of Values tab)			Cost Code
Cost Type (Schedule of Values tab)			Inventory ID²
Qty (Schedule of Values tab), if applicable			Quantity
Unit Cost (Schedule of Values tab), if applicable			Unit Cost
Amount (Schedule of Values tab)			Amount
Description (General tab)			Detailed Description

¹Commitment 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.

²The 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			Invoices
Subcontractor Invoice			Commitment Invoices
Payroll			Payroll
Expense			Misc Expenses
DIRECT COST
Date			Date
Status			Automatically set to Approved
Employee
Description			Description
Vendor			Vendor (Only for transactions that originate from Accounts Payable)
Invoice #			Invoice (Only for transactions that originate from Accounts Payable)
Budget Code			Project Task Cost Code Account Group
Qty			Quantity
Unit Cost			Unit Rate
Amount			Amount
BUDGET
JTD Cost			Actual Amount
Direct Costs			JTD Cost - Commitment Invoiced¹
JOB COSTS REPORT
Sub Job			Project Task
Cost Code			Cost Code
Cost Type			Account Group
Original Budget			Original Budgeted Amount
Original Budget Units			Original Budgeted Quantity
Approved Budget Changes			Budgeted CO Amount
Approved Budget Unit Changes			Budgeted CO Quantity
Revised Budget			Revised Budgeted Amount
Revised Budget Units			Revised Budgeted Quantity
Commitment Invoiced			Committed Invoiced Amount
Job To Date Cost			Actual Amount

¹Direct 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			Date
Project			Project
Commitment #			Subcontract Nbr.
Overall Comments			Description
Contractor Company			Supplier
Invoice #¹			Reference Nbr Supplier Ref
Payment Due			Amount
Budget Code (Detail Tab) Sub Job Cost Code Cost Type			Project Task Cost Code Inventory ID²
This Period (Detail Tab)			Amount
Work Retainage Held % Work Retainage Held $ Work Retainage Released % Work Retainage Released $			Retainage Held Amount Retainage Held Percent Retainage Released Amount Retainage Released Percent
^{Accounting Date}			Date

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