Detailed Data Mapping

Overview

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 STANDARD COST CODES

erp-green-arrows.png

ACCOUNT GROUPS STANDARD COST CODES

BUDGETS SUB JOB/CUSTOM SEGMENT (TASK) PROJECT COST CODE PROJECT COST TYPE

erp-orange-arrows.png

erp-green-arrows.png

COST BUDGETS PROJECT TASK COST CODE ACCOUNT GROUP

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 PAYMENTSISSUED2 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

1 Custom WBS segments are NOT supported at this time.

2 Import of subcontractor payment records from MYOB Advanced Construction is only supported in US Editions.

Companies/Vendors

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction. 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

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction Project ID is entered manually by an accounting approver when a project is exported from Procore to MYOB Advanced Construction. 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 MYOB Advanced Construction 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 MYOB Advanced Construction, 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 MYOB Advanced Construction. Its an optional field, only required if the customer has enabled Subaccounts in MYOB Advanced Construction. If the project is imported into Procore from MYOB Advanced Construction, 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 MYOB Advanced Construction. Its an optional field. If the project is imported into Procore from MYOB Advanced Construction, the Template ID is not stored on the project in Procore.

Sub Jobs/Project Task

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 Grou p1 Account Group

1 Import note: If the Project Task in MYOB Advanced Construction 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 MYOB Advanced Construction Standard Cost Codes. Custom WBS segments are not supported for the integration at this time.

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction Standard Cost Types.

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction>Project>Cost Budget) or the Sub Job (In Procore>Budget Tool)

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction. 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.

Detailed Data Mapping Content Reuse for ERP Budget Changes

Beta icon 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

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction.

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 MYOB Advanced Construction.

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

Any changes made to the overall value of the contract after the initial contract value is synced, must be manually updated in the ERP system.

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction, the Prime Contract number in MYOB Advanced Construction 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 MYOB Advanced Construction, the change(s) will appear as a Revenue Change Order with a Status of On Hold.

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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

erp-orange-arrows.png

Project

Sub Job

erp-orange-arrows.png

Project Task

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)2

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 MYOB Advanced Construction, the Change Order number in MYOB Advanced Construction will be the next system generated number.

2 Markup Amounts=Gross Margin Amount (except when using Markup to Estimate, then markups are included in Change Total Amount).

Commitments

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

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction, the Subcontract/Purchase Order number in MYOB Advanced Construction will be the next system generated number.

2The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in MYOB Advanced Construction

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 MYOB Advanced Construction, the change(s) will appear as a Commitment Change Order with a Status of Closed.

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction, the Change Order number in MYOB Advanced Construction will be the next system generated number.

2The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in MYOB Advanced Construction

Job Costs

Job costs import from MYOB Advanced Construction only. Cost information is retrieved from MYOB Advanced Construction 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 MYOB Advanced Construction 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

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction, an AP Bill is automatically created in MYOB Advanced Construction. In Procore, Subcontractor Invoices are accessed from Invoices in the project Commitments tool. In MYOB Advanced Construction, 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

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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 MYOB Advanced Construction, the Reference Number in MYOB Advanced Construction will be the next system generated number.

2The Inventory ID comes from the Account Groups(Cost Type)>Procore Integration>Default Non-Stock setting in MYOB Advanced Construction

Commitment Payments Issued

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

PROCORE

Exports data from Procore to

MYOB Advanced Construction

Imports data from

MYOB Advanced Construction

to Procore

MYOB Advanced Construction

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