Transcription
TPM – Yardi Voyager 7S Technical ManualVersion 1.0May 2, 2017Copyright 2016, 2017, Oracle and/or its affiliates. All rights reserved.
Table of ContentsTPM – Yardi Voyager 7S Technical Manual . 1Overview . 3Description . 3Yardi Voyager 7S Subcontracts and Subcontract Change Orders exported to TPM . 3Yardi Voyager 7S Subcontract Compliance exported to TPM . 3Yardi Voyager 7S AP Invoices imported from TPM . 3Yardi Voyager 7S AP Invoice Reversals imported from TPM . 3Yardi Voyager 7S AP Payments imported from TPM . 3Design Methodology. 4Automated Solution for Import Interfaces . 4Key Features . 4Main Features covered in the scope of this integration . 4Yardi Objects . 5Field Mappings . 6Subcontracts . 6Change Orders . 7Compliance . 7Invoices . 8Invoice Rejections (reversals) . 8Payments . 9Job Streams . 9Subcontracts . 9Change Orders . 10Compliance . 10Invoice. 11Invoice Rejections (Reversal) . 11Payments . 12TexturaLink. 13System Requirements: . 13Installation: . 13Configuring TexturaLink . 14TexturaLink Configuration Parameters . 14TexturaLink Home Screen . 16Page 2
OverviewDescriptionThis document contains a comprehensive explanation of the Yardi Voyager 7s/Oracle Textura PaymentManagement Interface. There are five components of this interface:1.Yardi Voyager 7S Subcontracts and Subcontract Change Orders exported to TPM2.Yardi Voyager 7S Subcontract Compliance exported to TPM3.Yardi Voyager 7S Accounts Payable Invoices imported from TPM4.Yardi Voyager 7S Accounts Payable Invoice Reversals imported from TPM5.Yardi Voyager 7S Accounts Payable Payments imported from TPM.Yardi Voyager 7S Subcontracts and Subcontract Change Orders exported to TPMJob cost subcontracts and subsequent change orders against those subcontracts on properties setup inYardi to use the Textura integration will be extracted from Yardi and imported into TPM. Requestsinitiated from TexturaLink will use Yardi’s Get Job Cost web service method and import records using theinsert contracts web service for TPM.Yardi Voyager 7S Subcontract Compliance exported to TPMCompliance requirements tracked on a subcontract for a Textura managed property in Yardi will beimported into TPM. These records will initiate holds or releases in TPM based on the status as it istracked in Yardi. Requests initiated from TexturaLink will use Yardi’s Get Job Cost web service methodand import records using the import compliance web service for TPM.Yardi Voyager 7S AP Invoices imported from TPMSubcontract Invoices are created in the Oracle Textura Payment Management system and exported tothe Yardi Voyager 7S Accounts Payable system. The import of Invoice voucher data is initiated byTexturaLink either on a scheduled basis or on-demand using web services. Standard progress invoicesare imported using Yardi’s Import Payables method and will create an unposted batch in Yardi. Forretention release invoices, Yardi’s Get Retention amounts service is used to identify the invoice IDs of APinvoices posted against a contract that is holding retention. The Import Retention Payables service willbe used to create retention release invoices in Yardi.Yardi Voyager 7S AP Invoice Reversals imported from TPMSubcontract Invoices are created in the Oracle Textura Payment Management system and exported tothe Yardi Voyager 7S Accounts Payable system once they are approved in TPM. If a subcontractorinvoice that was previously approved and exported from TPM is later rejected by the GC, TPM will sendan invoice rejection record to reverse the existing payable. Once the subcontractor resubmits theinvoice, we will create a new invoice with a unique revision number appended to the end of the originalinvoice number. This process uses the GetPayables service to identify the Yardi invoice ID for theinvoices that should be rejected, then the ReversePayables method to reverse the entry.Yardi Voyager 7S AP Payments imported from TPMAP Payments are created in the Oracle Textura Payment Management system and exported to YardiVoyager 7S Payment Processing where the payments are applied to matching invoice vouchers inAccounts Payable. The import of Payment data is initiated by TexturaLink either on a scheduled basis oron-demand using web services. The import checks web service is used to import payments against APinvoices in Yardi.Page 3
Design MethodologyAutomated Solution for Import InterfacesDue to the need for an automated solution, the following design methodology was adopted:1. All data to be imported into Yardi will use Yardi’s SOAP based vendor invoicing web servicesinitiated by requests from TexturaLink2. All data extracted from Yardi will use Yardi’s SOAP based job cost web services initiated byrequests from TexturaLink3. All integration points can be scheduled or invoked by a user using TexturaLink.Key FeaturesMain Features covered in the scope of this integrationFollowing is a list of some of the main features covered in the scope of this document:1. Subcontract, Change Order, and Compliance Extracts Properties must be set to use the Textura Interface in Yardi setupOnly orders for Jobs that are setup in TPM will be extractedPage 4
Subcontract items use the contractid concatenated with the database id of that record inYardi as the subcontract item number key for TPM. This field is represented as UniqueMarkon the XMLresponse from the Yardi service.2. Subcontract Invoice Import The system will allow import of Invoices to create AP invoice batches in Yardi. The numberof batches created is configurable in TexturaLink. The options are to create a separate batchfor each incoming invoice, or to create a separate batch for each job number on theincoming invoice feed. Batches are broken out this way because the Yardi service will failthe entire import if any record fails validation, providing the option to break out the batchesmore granularly will result in more successful postings with each import job. Separate invoice lines are created in Yardi for each invoice line in the import feed that isholding retention. If Retention on an Invoice has to be released, a Retention Invoice will be sent from Texturaand imported into Yardi Voyager 7S. The import will create a new payable record for eachinvoice it is releasing retention from and append an R to the front of the original invoicenumber. For Retention Release invoices, the user defined field #10 is used to store the Texturagenerated invoice number. This value is used when applying payments to the retentionrelease invoices. For Invoice reversals (rejections), the invoice will be deleted if it is in an unposted batch, orreversed if it is in a posted batch as long as no payment has been applied to that invoice.3. Subcontract Payment Import Payments can be made against original Invoice as well as Retention Invoice. For each funding organization set up in TPM, the ERP Bank code field must be set with thecorresponding Bank ID in Yardi.Yardi ObjectsObject NameImport PayableObject TypeWeb ServiceGetPayablesWeb ServiceGetRetentionAmountsWeb ServiceGetJobCostReversePayableWeb ServicesWeb ServicesNotesUsed to import AP Invoices into YardiUsed to find all retention release invoices in Yardiaffiliated with a single TPM draw for paymentprocessingUsed to obtain invoice IDs of invoices holdingretention for a specific subcontractUsed to extract job cost data from Yardi (Subcontracts,Change Orders, Compliance)Used to reverse a previously exported payablePage 5
Field ostYardi bCostRetentionPercentGetJobCostJobId - CostContract centGetJobCostJobId - Property IdVendorIdYardi FieldCostCodeCategoryIdTPM FieldContract rcentageProjectNumberSubcontractAmountVendor IdNotesIf no start date, then use current dateTPM FieldAccount CodeCategory tentionPercentageProjectNumberSubcontractItem NumberSubJobNumberVendor IdNotesPage 6JobId – PropertyId combined, example:1000-TEX001JobId – PropertyId combined, example:1000-TEX001Unique database id from Yardi databaseconcatenated with contractid
Change OrdersHeaderServiceYardi stContract centGetJobCostJobId - Property IdVendorIdYardi FieldCostCodeCategoryIdTPM FieldChange OrderDateChange OrderNumberChange OrderTitleSubcontractNumberVendor IdNotesTPM FieldAccount CodeCategory tentionPercentageNotesProject NumberSubcontract ItemNumberSubJob NumberVendor IdIf no date of, then use current dateJobId – PropertyId combined, example: 1000TEX001Unique database id from Yardi databaseconcatenated with contractidComplianceServiceGetJobCostYardi FieldJobId VendorIdNameGetJobCostExpiresTPM FieldProjectNumberSubcontractNumberVendor IdDescriptionExpirationDateStatusNotesJobId – PropertyId combined, example: 1000-TEX001If there is an expiration date, set status to received. Ifnot, set status to not receivedPage 7
InvoicesHeaderServiceImport PayablesImport PayablesImport PayablesImport PayablesImport PayablesImport PayablesImport PayablesDetailsServiceImport PayablesImport PayablesImport PayablesImport PayablesImport PayablesImport PayablesImport PayablesImport PayablesImport PayablesTPM FieldVendor IDInvoiceNumberInvoice DateDraw PeriodTo DateDrawNumberSubcontractNumberYardi FieldVendorIDNotesInvoiceNumberInvoiceDateCurrent DateSet to the first of the month of the invoice drawdatePostMonthNotesContractIDInvoice NetAmountInvoice Net amount unless it is a RetentionRelease invoice, then Total Retention releaseamountTotalAmountTPM FieldItem GrossAmountYardi FieldNotesIf retention release, item retention releaseamount is usedNot MappedAmountAccountIDSubJobNumberSubcontractItem ryIdRetentionAmountWill create a separate invoice line for each line'sretention held amountCostCodeNotesInvoice Rejections
5. Yardi Voyager 7S Accounts Payable Payments imported from TPM. Yardi Voyager 7S Subcontracts and Subcontract Change Orders exported to TPM Job cost subcontracts and subsequent change orders against those subcontracts on properties setup in Yardi to use the Textura integration will be extracted from Yardi and imported into TPM. Requests initiated from TexturaLink will use Yardi’s File Size: 1MBPage Count: 17Explore furtherUser Guideconam.yardielearning.comYardi Training Manual Pdf - Fill Online, Printable .yardi-manual.pdffiller.comYardi Voyager Training Manual Pdf.pdf pdf Book Manual .www.pdf-book-search.comTraining – Yardiwww.yardi.comUser Guideconam.yardielearning.comRecommended to you based on what's popular Feedback
