Yardi Voyager® Detailed Data Mapping

Overview

 
PROCORE
 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
 
Yardi Voyager®
COMPANIES   erp-green-arrows.png VENDORS3
PROJECTS
Cost Codes
Cost Types		   erp-green-arrows.png JOBS
Cost Categories
Cost Codes
ORIGINAL BUDGET ESTIMATES erp-orange-arrows.png erp-green-arrows.png ORIGINAL BUDGETS
BUDGET CHANGES erp-orange-arrows.png   BUDGET REVISIONS
COMMITMENTS
(Does not include Purchase Orders)		 erp-orange-arrows.png   CONTRACTS
COMMITMENT CHANGE ORDERS1 erp-orange-arrows.png   CHANGE ORDERS
COMMITMENT INVOICES1,4 erp-orange-arrows.png   PAYABLES
COMMITMENT PAYMENTS ISSUED1   erp-green-arrows.png PAID INVOICES
DIRECT COSTS   erp-green-arrows.png PAYABLES
JOURNAL ENTRIES2

1.  Does not include purchase orders.

2.  Due to a Yardi Voyager® update, Job Cost adjustment functionality is not available at this time.

3. Vendors marked as Credit Card Vendors are not supported.

4. Interfaces (Plug-in Version 25) must be installed to successfully sync work retainage.

 

Projects/Jobs

 
PROCORE
 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
 
Yardi Voyager®
origin_code   erp-green-arrows.png Job ID
origin_data   erp-green-arrows.png PropertyID
Project Name   erp-green-arrows.png Job Description
Status   erp-green-arrows.png Status
Address   erp-green-arrows.png Mailing Address
Cost Code
 		   erp-green-arrows.png Cost Categories
 

Cost Type

   erp-green-arrows.png

Cost Code

.

Companies/Vendors

 
PROCORE
 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
 
Yardi Voyager®

Vendor ID

   erp-green-arrows.png

origin_id
Company Name   erp-green-arrows.png Vendor Name
Address   erp-green-arrows.png Address
State (this is set to uppercase)   erp-green-arrows.png State
Email   erp-green-arrows.png Email
Phone   erp-green-arrows.png Phone
Must be set to True   erp-green-arrows.png Is_active

Original Budget Estimate - Export 

 
PROCORE
 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
 
Yardi Voyager®
Original Budget erp-orange-arrows.png   new_amount
Job ID erp-orange-arrows.png   job_id
CategoryId erp-orange-arrows.png   origin_id (String Split)
CostCode erp-orange-arrows.png   line_item_type_origin_id

Original Budget Estimate - Import

 
PROCORE
 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
 
Yardi Voyager®
Original Budget   erp-green-arrows.png new_amount
Job ID   erp-green-arrows.png job_id

Budget Changes

 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 October 2023. 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 連絡先. 

To learn more about the new Budget Changes experience, see: Budget: New 'Budget Changes' Feature for Change Management in Project Financials

 
PROCORE
 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
 
Yardi Voyager®
Job ID erp-orange-arrows.png   job_id
Category erp-orange-arrows.png   origin_id (string split)
Cost Code erp-orange-arrows.png   line_item_type_origin_id
Amount erp-orange-arrows.png   Value
Date erp-orange-arrows.png   revision_date
Revision Number erp-orange-arrows.png   revision_number
Budget Revision Type erp-orange-arrows.png   revision_type
Budget Revision Status erp-orange-arrows.png   revision_status

Commitments

 
PROCORE
 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
 
Yardi Voyager®
Title erp-orange-arrows.png   Description
Contract Company erp-orange-arrows.png   Vendor
Status erp-orange-arrows.png   Status
origin_id erp-orange-arrows.png   JobId
origin_data erp-orange-arrows.png   PropertyId
contract_estimated_completion_date erp-orange-arrows.png   EndDate
contract_start_date erp-orange-arrows.png   StartDate
retainage_percent erp-orange-arrows.png   RetentionPercent
description erp-orange-arrows.png   Remarks
line_item_type/Object/code erp-orange-arrows.png   CostCode

Commitment Change Orders


PROCORE		 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
Yardi Voyager®
AccountId erp-orange-arrows.png   AccountId
origin_id erp-orange-arrows.png   JobId
position erp-orange-arrows.png   LineOrder
origin_data erp-orange-arrows.png   PropertyId
due_date erp-orange-arrows.png   Date
origin_code erp-orange-arrows.png   ParentContractId
amount erp-orange-arrows.png   ContractAmount
title erp-orange-arrows.png   Description
retainage_percent erp-orange-arrows.png   RetentionPercent
line_item_type/Object/origin_id erp-orange-arrows.png   CategoryId
cost_code/Object/origin_id erp-orange-arrows.png   CostCode

Subcontractor Invoice

Export from Procore only. When an invoice is exported from Procore to Yardi Voyager®, it is automatically posted in the Accounts Payable (AP) module.


PROCORE		 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
Yardi Voyager®
Subcontractor Invoice erp-orange-arrows.png   Subcontractor Invoice
Payroll erp-orange-arrows.png   Payroll
Expense erp-orange-arrows.png   Expense

Paid Invoices


PROCORE		 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
Yardi Voyager®
Invoice Number   erp-green-arrows.png Invoice_number
Lookup based on the following fields: ID, PersonID, InvoiceNumber, JobID   erp-green-arrows.png requisition_id
ID   erp-green-arrows.png origin_id
AmountPaid   erp-green-arrows.png Amount
Details.CheckNumber   erp-green-arrows.png check_number
Notes   erp-green-arrows.png Notes
Payment Type   erp-green-arrows.png payment_method
Payment Date   erp-green-arrows.png Payment Date
Payment Number   erp-green-arrows.png Payment Number

Direct Costs


PROCORE		 Exports data from Procore to Yardi Voyager® Imports data from Yardi Voyager® to Procore
Yardi Voyager®
PropertyId   erp-green-arrows.png origin_data
job_id   erp-green-arrows.png origin_id
ScheduledStartDate   erp-green-arrows.png estimated_start_date
ScheduledCompletionDate   erp-green-arrows.png estimated_completion_date