Detailed Data Mapping

Coming Soon

Procore Vision for Acumatica® Cloud ERP is coming soon in 2025. Please reach out to your Procore point of contact for more information.

Overview

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

COMPANIES 2

Erp Green Arrows

VENDORS

PROJECTS

Erp Orange Arrows

PROJECTS

COST TYPES

Erp Green Arrows

ACCOUNT GROUPS

BUDGETS 1
PROJECT TASKS
SUB JOBS (OPTIONAL)
COST CODES

Erp Orange Arrows

COST BUDGETS PROJECT TASKS
PROJECT TASKS & SUB JOBS
COST CODES

BUDGET MODIFICATIONS

Erp Orange Arrows

COST BUDGET CHANGE ORDERS

PRIME CONTRACTS

Erp Green Arrows

REVENUE BUDGET

PRIME CONTRACT CHANGE ORDERS

Erp Orange Arrows

REVENUE BUDGET CHANGE ORDERS

PRIME CONTRACT INVOICES
*Coming Soon*

Erp Orange Arrows

ACCOUNTS RECEIVABLE INVOICES

COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs)

Erp Orange Arrows

COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs)

SUBCONTRACTOR INVOICES SUBCONTRACTS & PURCHASE ORDERS

Erp Orange Arrows

ACCOUNTS PAYABLE INVOICES

SUBCONTRACT PAYMENTS ISSUED
FOR SYNCED SUBCONTRACTOR INVOICES

Erp Orange Arrows

Erp Green Arrows

PAID INVOICES

COSTS
DIRECT COST
JTD COST

Erp Green Arrows

COSTS
TRANSACTIONAL COST BY INVOICE, EXPENSE, PAYROLL, AND SUBCONTRACTOR INVOICE TYPES

1 Budgets containing line items with $0 values can be exported from Procore to Procore Vision for Acumatica®.

2 Import companies by type, including those without a specified company type from Procore Vision for Acumatica® to Procore.

Companies/Vendors

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

ERP Vendor ID 1

Erp Green Arrows

Vendor ID

Type

Erp Green Arrows

Vendor Class

Name

Erp Green Arrows

Account Name

Address
City
State
ZIP

Erp Green Arrows

Address Line 1
City
State
Postal Code

Business Phone

Erp Green Arrows

Business 1 Phone

Email Address

Erp Green Arrows

Account Email

1 Export Note: The ERP Vendor ID is entered manually by an Accounting Approver when a company is exported from Procore to Procore Vision for Acumatica®. 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, CCOs). This can be an optional field during exporting if this option has been enabled by Procore.

Projects

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

Project Number

Erp Orange Arrows

Project ID

Project Name

Erp Orange Arrows

Description

Address
City
State
Zip

Erp Orange Arrows

Address Line 1
City
State
Postal Code

Latitude/Longitude

Erp Orange Arrows

Latitude/Longitude

Start Date/Completion Date

Erp Orange Arrows

Start Date/ End Date

Subaccount ID

Erp Orange Arrows

Default Sales Subaccount

Template ID

Erp Orange Arrows

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 Procore Vision for Acumatica® Standard Cost Codes. Custom WBS segments are not supported for the integration at this time.

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

Cost Code

Erp Green Arrows

Cost Code

Description

Erp Green Arrows

Description

Standard Cost Types/Account Groups

In Procore, the Cost Types can be found in the Cost Types section in the Admin Tool under Procore Vision for Acumatica® Standard Cost Types.

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

Cost Type

Erp Green Arrows

Account Group

Description

Erp Green Arrows

Description

Budgets/Cost Budget

Budget export from Procore only. All budgets totals are entered against the main Project Task (In Procore Vision for Acumatica®>Project>Cost Budget) or the Sub Job (In Procore>Budget Tool)

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

Work Breakdown Segment

Erp Orange Arrows

Project Task

Cost Code

Erp Orange Arrows

Cost Code

Cost Type

Erp Orange Arrows

Account Group

Sub Job

Erp Orange Arrows

Project Task

Task

Erp Orange Arrows

Project Task

Original Budget Amount

Erp Orange Arrows

Original Budgeted Amount

Budget Modifications

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

When Budget Modifications are exported from Procore, a Cost Budget Change Order is created on the Project in Procore Vision for Acumatica®. 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 Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

Change Date 1

Erp Orange Arrows

Change Date

Sub Job

Erp Orange Arrows

Project Task

Cost Code

Erp Orange Arrows

Cost Code

Cost Type

Erp Orange Arrows

Account Group

Budget Modification Amount

Erp Orange Arrows

Amount

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

Prime Contracts

Prime Contracts import only from the Acumatica projects' Revenue Budget.

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

#

Erp Green Arrows

Description

Erp Green Arrows

Original Budgeted Amount
(Project Revenue Budget)

Original Contract Amount

Erp Green Arrows

Schedule of Values

Budget Code

Erp Green Arrows

Project Task + Cost Code + Account Group

Description

Erp Green Arrows

Description

Amount

Erp Green Arrows

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 Procore Vision for Acumatica®, the change(s) will appear as a Revenue Change Order with a Status of On Hold.

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

System Date at Time of Prime Contract Creation

Erp Orange Arrows

Change Date
Approval Date

PCCO Number 1

Erp Orange Arrows

Reference Nbr
External ID

Title (General tab)

Erp Orange Arrows

Description

Description (Schedule of Values tab)

Erp Orange Arrows

Description

Project Number Sub Job

Erp Orange Arrows

Project
Project Task 2

Cost Code (Schedule of Values tab)

Erp Orange Arrows

Cost Code (Cost Budget Tab)

Cost Type (Schedule of Values tab)

Erp Orange Arrows

Account Group (Cost Budget Tab)

Potential Change Order Amount

Erp Orange Arrows

Amount (Cost Budget Tab)

Potential Change Order Amount + Markup(s) Amount

Erp Orange Arrows

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 Procore Vision for Acumatica®, the Change Order number in Procore Vision for Acumatica® 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 Procore Vision for Acumatica®. For Subcontracts a status of Open will be used in Procore Vision for Acumatica®. The Project used in Procore will be sent to the Project field on the commitment line item in Procore Vision for Acumatica®. For Purchase Orders, a status of Open will be used in Procore Vision for Acumatica®. For Purchase Orders, the type of Normal will be used in Procore Vision for Acumatica®. In Procore, Commitments are accessed from the project-level Commitments tool.

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

System Date at Time of Commitment Creation

Erp Orange Arrows

Date

Start Date (Subcontract) Delivery Date (Purchase Order)

Erp Orange Arrows

Start Date (Subcontract) Promised On (Purchase Order)

Commitment # 1

Erp Orange Arrows

Subcontract Nbr (for Subcontracts)
Order Nbr (for Purchase Orders)
External Ref (Subcontracts and Purchase Orders)

Contract Company

Erp Orange Arrows

Vendor

Title (General tab)

Erp Orange Arrows

Description

Default Retainage

Erp Orange Arrows

Retainage Percent

Budget Code (Schedule of Values tab)
Sub Job
Cost Code
Cost Type 2

Erp Orange Arrows

Project Task
Cost Code
Inventory ID 2

Description (Schedule of Values tab) 3

Erp Orange Arrows

Line Description 3

Qty (Schedule of Values tab), if applicable

Erp Orange Arrows

Order Qty

Unit Cost (Schedule of Values tab), if applicable

Erp Orange Arrows

Unit Cost 4

Amount (Schedule of Values tab)

Erp Orange Arrows

Ext. Cost

1 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 Procore Vision for Acumatica®, the Subcontract/Purchase Order number in Procore Vision for Acumatica® will be the next system-generated number.

2 The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in Procore Vision for Acumatica®.

3 If the SOV line description is left blank, Procore Vision for Acumatica® will populate the Procore Vision for Acumatica® contract line by default Base Unit set up for the Procore Vision for Acumatica® connector.

4 Amount-based contract lines receive a default Unit qty of 1 when integrated to Procore Vision for Acumatica®. For amount-based contracts (i.e., Procore Subcontracts), UOM is determined on the Procore Vision for Acumatica® contract line by the default Base Unit set up for the Procore Vision for Acumatica® 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 Procore Vision for Acumatica®, the change(s) will appear as a Commitment Change Order with a Status of Closed.

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

System Date at Time of Commitment Creation

Erp Orange Arrows

Change Date Approval Date

Commitment Change Order # 1

Erp Orange Arrows

Change Order Reference Nbr
External Reference Nbr

Contract Company

Erp Orange Arrows

Vendor

Title (General tab)

Erp Orange Arrows

Description

Description (Schedule of Values tab)

Erp Orange Arrows

Description

Project Number Sub Job

Erp Orange Arrows

Project
Project task

Cost Code (Schedule of Values tab)

Erp Orange Arrows

Cost Code

Cost Type (Schedule of Values tab)

Erp Orange Arrows

Inventory ID 2

Qty (Schedule of Values tab), if applicable

Erp Orange Arrows

Quantity

Unit Cost (Schedule of Values tab), if applicable

Erp Orange Arrows

Unit Cost

Amount
(Schedule of Values tab)

Erp Orange Arrows

Amount

Description
(General tab)

Erp Orange Arrows

Detailed Description

1 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 Procore Vision for Acumatica®, the Change Order number in Procore Vision for Acumatica® will be the next system-generated number.

2 The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in Procore Vision for Acumatica®.

Job Costs

Job costs import from Procore Vision for Acumatica® only. Cost information is retrieved from Procore Vision for Acumatica® 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 transactions from Procore Vision for Acumatica® 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 in the Direct Costs or JTD Cost columns for a budget line item.

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

Direct Cost Type

Invoice

Erp Green Arrows

Invoices

Subcontractor Invoice

Erp Green Arrows

Commitment Invoices

Payroll

Erp Green Arrows

Payroll

Expense

Erp Green Arrows

Misc Expenses

Direct Cost

Date

Erp Green Arrows

Date

Status

Erp Green Arrows

Automatically set to Approved

Employee

Erp Green Arrows

Description

Erp Green Arrows

Description

Vendor

Erp Green Arrows

Vendor (Only for transactions that originate from Accounts Payable)

Invoice #

Erp Green Arrows

Invoice (Only for transactions that originate from Accounts Payable)

Budget Code

Erp Green Arrows

Project Task
Cost Code
Account Group

Qty

Erp Green Arrows

Quantity

Unit Cost

Erp Green Arrows

Unit Rate

Amount

Erp Green Arrows

Amount

Budget

JTD Cost

Erp Green Arrows

Actual Amount

Direct Costs

Erp Green Arrows

JTD Cost - Commitment Invoiced 1

Job Costs Report

Sub Job

Erp Green Arrows

Project Task

Cost Code

Erp Green Arrows

Cost Code

Cost Type

Erp Green Arrows

Account Group

Original Budget

Erp Green Arrows

Original Budgeted Amount

Original Budget Units

Erp Green Arrows

Original Budgeted Quantity

Approved Budget Changes

Erp Green Arrows

Budgeted CO Amount

Approved Budget Unit Changes

Erp Green Arrows

Budgeted CO Quantity

Revised Budget

Erp Green Arrows

Revised Budgeted Amount

Revised Budget Units

Erp Green Arrows

Revised Budgeted Quantity

Commitment Invoiced

Erp Green Arrows

Committed Invoiced Amount

Job To Date Cost

Erp Green Arrows

Actual Amount

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

Subcontractor Invoices

When a subcontractor invoice is exported from Procore to Procore Vision for Acumatica®, an AP Bill is automatically created in Procore Vision for Acumatica®. In Procore, Subcontractor Invoices are accessed from Invoices in the project Commitments tool. In Procore Vision for Acumatica®, 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 Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

Billing Date

Erp Orange Arrows

Date

Project

Erp Orange Arrows

Project

Commitment #

Erp Orange Arrows

Subcontract Nbr.

Overall Comments

Erp Orange Arrows

Description

Contractor Company

Erp Orange Arrows

Supplier

Invoice # 1

Erp Orange Arrows

Reference Nbr Supplier Ref

Payment Due

Erp Orange Arrows

Amount

Budget Code (Detail Tab)
Sub Job
Cost Code
Cost Type

Erp Orange Arrows

Project Task
Cost Code
Inventory ID 2

This Period (Detail Tab)

Erp Orange Arrows

Amount

Work Retainage Held %
Work Retainage Held $
Work Retainage Released %
Work Retainage Released $

Erp Orange Arrows

Retainage Held Amount
Retainage Held Percent
Retainage Released Amount
Retainage Released Percent

Accounting Date

Erp Orange Arrows

Date

1 If Auto Numbering for Bills is enabled in Procore Vision for Acumatica®, the Reference Number in Procore Vision for Acumatica® will be the next system-generated number.

2 The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in Procore Vision for Acumatica®.

Commitment Payments Issued

Commitment Payments Issued imported from Procore Vision for Acumatica® only. When a subcontractor invoice is exported from Procore to Procore Vision for Acumatica®, an AP Bill is automatically created in Procore Vision for Acumatica®. 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 Procore Vision for Acumatica®, payments are accessed from Payables>Checks and Payments.

PROCORE

Exports data from Procore to Procore Vision for Acumatica®

Imports data from Procore Vision for Acumatica® to Procore

Procore Vision for Acumatica®

Invoices

Erp Green Arrows

n/a

Date

Erp Green Arrows

Post Date

Payment #

Erp Green Arrows

Reference Nbr

Invoice #

Erp Green Arrows

Supplier Ref

Check / Ref #

Erp Green Arrows

Payment Ref

Amount

Erp Green Arrows

Payment Amount

Procore Pay Payments

 General Availability in Select Markets (United States)

Flag Us Procore Pay is available in the United States. It is designed for General Contractors and Owner-Builders who act as their own General Contractors on a job. Procore Pay extends the Invoice Management functionality in the Procore web application to handle the payment process between general and specialty contractors.

PROCORE

Exports data from Procore to Acumatica®

Imports data from Acumatica® to Procore

Acumatica®

Date Payment Funded

Erp Orange Arrows

Erp Green Arrows

Application Date

Check Number

Erp Orange Arrows

Erp Green Arrows

Payment Ref

Payment Method

Erp Orange Arrows

Erp Green Arrows

Payment Method (ACH, CHECK)

Amount

Erp Orange Arrows

Erp Green Arrows

Payment Amount

Amount

Erp Orange Arrows

Erp Green Arrows

Details - Amount Paid