CGC/CMS Integration User Manual
Contents
1. Completing payment posting in CMS 1 Navigate to the Textura Interface Management screen by typing TXTURA in the Fastpath link at the bottom of the screen 2 Select 2 Edit Post Textura Payments a Ryan270 LE File Edit View Communication Actions Window Help Buga 2 ee a RR IIE A e 2 Fastpath 21 013 aj 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_1 E a amp ao KL Inbo BN Rya Ryan is Ado NA Rep M Docu A Rep Q 4 37 PM CMS Textura Integration User Manual Page 28 of 43 Textura Corporation Confidential 3 Type the Company Number and Division Number in the appropriate locations The system automatically populates the Cash G L Account and Accounts Payable G L Account with the default accounts Edit View Communication Actions Window Help ES 4 ee a Le 28 a Sd Textura Payment Posting 07 1902 Session successfully started 4 The Edit only option will generate a report outlining the information to be posted in this batch Adobe Reader REPORT2 PDF 05 016 Server Room LaserJet 5000 Series PCL6 on IP_1S File Edit View Document Tools Window Help Bookmarks L j ADAMS FAMILY CONSTRUCTION CO 10 19 06 TXTEDIT Job Nbr 001251 Sub Job 005 OFFICE MAX Vendor 6512 BOLAND amp SONS CO Contract 002300 Item Nbr 01 EARTHWORK Invoice 1251 3 Payment Nbr 19332. File Edit Yiew Communication Actions Window Help Bel BR ee a RIR 28 a ele P Adams Family Construction Co Accts Payable Fastpath 21 014 gy 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_1 CMS Textura Integration User Manual Page 25 of 43 Textura Corporation Confidential 2 From the Batch menu select option 19 Edit File Edit View Communication Actions Window Help S pel BII SIRI ali Le ok al eld APPMO4 Adams Family Construction Co Accts Payable QPADEVOOMW Processing Approve Enter Invoices Release Multiple Halt Codes Pay Select Cash Requirements 13 Release or Halt by Vendor Job Clear Selection 14 Estimating Interface Print Checks 15 Blank Check Print Clear Checks Cash Disbursements Update Process Manual Checks Purchase Journal Transfer Lien Waiver Data Purchase Journal Audit Work with Lien Waivers Standard Invoice Remove Standard Invoice Foo Oon OuURWND FE e e Entry Correction Edit Update Fastpath Computer Guidance Corp File Edit View Communication Actions Window Help S Riga R em ai Le AIE al eld Date 10 19 06 APP158 Time 16 26 Batch Number 0 A11 Outq Hold Save Job Queue F3 Exit F4 Prompt 05 029 J 1 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_15 CMS Textura Integration User Manual Textura Corporation Confidential Page 26 of 43 4 Below is a sample
3. 2 Pah ferns O G w LU A Address https www5 texturallc comfinterfaces SubcontractListing psp projectID 1147 amp contractID 1794 v Go Links 6 N NT ge v Search web ZX Upgrade Now lt 7 Ear amp EMail G My Yahoo EJ Answers N KP Fantasy Sports 26 Hockey Totals 948 649 35 97 206 20 5 116 12 51 443 15 Incomplete Subcontracts Contract Humber Contract Date Phase Code Description Organization Subcontract Amount 161008 09 25 06 view ELECTRICAL SYSTEMS Choice Electric Inc 108 018 00 15401 101 06 View PLUMBING 60 981 00 99000 101406 View PAINITNG 20 358 00 99001 1011406 View PAINTING SITE 20 358 00 05120 101 06 view STRUCTURAL STEEL 211 315 00 Totals 1 369 679 35 internet CMS Textura Integration User Manual Page 17 of 43 Textura Corporation Confidential 2 Click the Contract Number link for each Incomplete Subcontract The system displays the Contract Maintenance page 3 Click on the Edit Settings button 4 Textura Contract Maintenance ions Foni Ch rie Adams Construction Payment Management 10 10 000 001607 00 2 15401 Plumbing ABC Construction Save Changes Revertto Saved Reallocating for Draw 2 Not yet initiated Delete Subcontract Edt Settings Add New Component Copy Selected Delete Selected Contract Components Chg Orders Payments Phase Account Caegety K Original Subcontract Desci iption Paid 10 Date Code Cot
4. Emire Project Track Requirement Home Enforcement Expiration First Second Delete tZ Pertormance Bond Advise Only Z 0 Siqned Contract advise On Z 0 Schedule Inky t D Proot of insurance Advise Only Z 0 Add Requirement L Delete Selected Requirements Save Settings Cancel 5 When finished return to your Project Home Page CMS Textura Integration User Manual Page 24 of 43 Textura Corporation Confidential 6 Subcontractor Invoices Interface Once a subcontractor invoice has been approved in Textura it will be tagged for download to CMS at the next scheduled time Invoices will typically be downloaded to CMS once a day The batch import process to enter subcontractor invoices will create an open payable and update the subcontract record Note If a user approves an invoice in Textura and later rejects that invoice for changes the user will need to modify the Open Payable record in CMS once the new invoice record is approved in Textura It will be identified on the edit report as a duplicate invoice number Completing the Batch Import process in CMS On a daily basis a user will be responsible for completing the batch import process to enter the approved subcontractor invoices into CMS This process will include an edit function to review the information and an update function to create the Open Payables and Update the subcontract 1 From the Accounts Payable main menu select option 4 Processing ay
5. Payment Amt Retention Amt Discount Payment Date 10 11 2006 A P Account 2000 000 Company 10 Division ADAMS FAMILY CONSTRUCTION CO Cash Acount 0103 000 Company 10 Division ADAMS FAMILY CONSTRUCTION CO Job Nbr 001251 Sub Job 005 OFFICE MAX Vendor 6512 BOLAND amp SONS CO Contract 002300 Item Nbr 01 Invoice 1251 3R Payment Nbr 1933 Payment Amt 1598 20 Retention Amt Discount Payment Date 10 11 2006 A P Account 2000 000 Cash Acount 0103 000 Company 10 Division ADAMS FAMILY CONSTRUCTION CO Job Nbr 001251 Sub Job 005 OFFICE MAX Vendor 12139 CHC ELECTRIC INC Contract 016100 Item Nbr 01 ELECTRICAL Invoice 16100 5SR Payment Nbr 1949 Payment Amt Retention Amt Discount Payment Date 10 11 2006 A P Account 2000 000 Cash Acount 0103 000 Company 10 Division ADAMS FAMILY CONSTRUCTION CO Job Nbr 001607 Sub Job 000 610 TEXTURA TESTING Vendor 3483 LIN FAB INC Contract 005120 Item Nbr 01 STRUCTURAL STEEL Invoice 1607 5 Payment Nbr 1943 Payment Amt 56491 75 Retention Amt Discount Payment Date 10 11 2006 A P Account 2000 000 Cash Acount 0102 000 Company 10 Division RYAN CONSTRUCTION TEST CO Job Nbr 001607 Sub Job 000 610 TEXTURA TESTING Vendor 3483 LIN FAB INC Contract 005120 Item Nbr 02 STEEL FAB Invoice 1607 5 Payment Nbr 1943 NL 13 19 x 11 in CMS Textura Integration User Manual Textura Cash Dispursements Edit Textura Corporation Confidential Page 29 of 43 5
6. Room LaserJet 5000 Series PCL6 on IP_1 CMS Textura Integration User Manual Page 20 of 43 Textura Corporation Confidential 4 Subcontract Change Orders Interface Entering Subcontract Change Orders in CMS Subcontract change orders should be entered into CMS as they are today If the subcontract change order is related to a Textura managed subcontract it will automatically be tagged for download to Textura Exporting subcontract change orders to Textura The process of exporting subcontract change orders to Textura will be managed by the AS400 Job Scheduler See Section 7 Textura Send Receive Scheduler for more information on scheduling the job to download subcontracts and subcontract change orders Viewing Subcontract Change Orders in Textura The Subcontract Change Order will automatically be applied to the Subcontract Once downloaded the user may view the change order from the Project Home Page Click on the show Subcontract Change Orders link Log Out Pa Textura Project Home Page vs Construction Payment Management Test Project 10 000 001251 005 Draw Interfaces SoV Subcontracts Change Orders Project Setup Reports Compliance Project Summary Project Actions z Show project summary None Prime Contract Change Order D Change Orders a Show Prime Contract Change Orders Draw 2 05 Jun 2008 Enter Invoice for Draw 2 Approve Invoice for Draw 2 Draw 1 17 Mar 2
7. a subcontractor the status should be set to Received The first time a project is included in the import file Textura will automatically add the compliance document requirements exported out of CMS to that project Enforcement will be set to Advise Only for all requirements and Track Expiration will be turned on only if there are expiration dates in the export file To view the imported legal document requirements 1 From the Project Home Page click the Compliance menu and select View Document Status Compliance Edit Document Status View Document Status Setup Document Requirements View Lien Waiver Status The system displays the Legal Document Status page which identifies the imported legal documents and their Status CMS Textura Integration User Manual Page 22 of 43 Textura Corporation Confidential Home Log Out Fa Textura View Document Status Tracy Adams Adams Family Construction Construction Payment Management Project Test Project 10 000 001607 005 D Compliant 04 Jan 2006 Expires within A Expired 04 Jan 2006 vo Compliant due Not T 60 days Not Received 01 Jan 2006 to related contract Applicable Dates shown are expiration dates Edit Document Requirements Apply Oypanization noncompliance of these document requirements will create a payment hold or all open draws Help PT Reports Manual Subs Pending Payments Suppliers Subcontractor Supplier Due on Site Action on
8. of the edit report It lists all invoices to be posted as well as identifies errors i Adobe Reader REPORT1 PDF SEIZ G x h File Edit View Document Tools Window Help S gt open PA Save a copy 7 Print Email QU Search E Select Text fe Q Gl E 76 A D En Sigg eBooks N 10 000 ADAMS FAMILY CONSTRUCTION CO A P EDIT REPORT TIME 10 19 PAGE 1 Br Eoee DATES CR G L ACCOUNTS INVOICE GROU INVOICE JU A P CASH AMOUNT NO Sub Cost Distribution cs io NO CONTR T G L NUMBER 01094 ACME AWNIN 10 12 2006 0 12 N N 2000 000 0 000 0103 000 O ATC 00001 10 000 001251 005 100 107000 4 10700 N 1330 000 06512 BOLAND 0 18 2006 10 18 2006 N N 2000 000 66 956 00 00206 0103 000 O C 00001 10 000 001251 00S 020 023000 2300 N 1330 000 06512 BOLAND 1251 3r 18 0 18 T 2000 000 598 20 00207 0103 000 j0 ATCH 00001 10 000 001251 005 020 022000 ERROR MESSAGE INVALID APPLICATION CODE m D 2 5 T C a L lla o v gt amp S if D a ta a Las 03483 LIN FAB 1607 4 0 19 0 19 2000 000 2 01023 000 10 000 001607 000 050 051200 3 5120 N 1330 000 10 000 001607 000 050 0 200 5120 N 1330 000 70926 SWANS 99001 4 00001 10 000 00160 000 090 099000 8 99001 N 1330 000 76852 TOP ALL RO 0 19 0 19 2006 N N 2000 000 23 880 00 00210 0103 000 70 ATCH 00001 10 000 001607 000 070 075120 8 7512 N 1330 000 OF INV 6 BATCH DESC Textura Invoices Division OF INV 6 Division TO
9. to kick off Scheduling interval hours for This field sets the interval time between send sessions After the first sending information to Textura send session 1s kicked off in the morning the program will run at intervals set by this field In the example below the send session will run every 1 hour until 5 00 pm Suspend sending information to This field will default to No N The user can stop the send program by Textura changing this field to Yes Y File Edit View Communication Actions Window Help S Hel BIR ee al 4 24 a e Textura Send Receive Scheduler 05 072 07 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_1 CMS Textura Integration User Manual Page 31 of 43 Textura Corporation Confidential Receiving Information The second three lines relate to receiving information 1 e subcontractor invoices and subcontractor ACH payments from Textura The fields are CC ES Ending time for receiving information This field sets the time after which the receive program will no from Textura longer run for the day It will start again the next time it is scheduled to kick off Scheduling interval hours for receiving This field sets the interval time between receive sessions After the information from Textura first receive session is kicked off in the morning the program will run at intervals set by this field In the example below the send session will run every 8 h
10. to the appropriate user documentation for these systems Interface Development Approach In developing the interfaces with CMS we followed an approach of leveraging native CMS and AS400 capabilities wherever possible and a strict policy of not modifying CMS code The interface with CMS is based on programs external to CMS and database triggers used to capture the information Textura CMS Workflow Summary Integrating Textura with CMS will provide efficiencies in your payment application process The most common interface points are e Subcontracts Download subcontracts from CMS to Textura using an automated process on a regularly scheduled basis e Subcontract Change Orders Download subcontract change orders from CMS to Textura using an automated process on a regularly scheduled basis e Legal Documents Download legal and compliance information from CMS to Textura using an automated process on a regularly scheduled basis e Subcontractor Invoice Entry Export approved subcontractor invoice information from Textura to a file formatted for batch processing in CMS e Subcontractor ACH Payment Entry Export subcontractor ACH payment information from Textura to a file formatted for posting in CMS CMS Textura Integration User Manual Page 5 of 43 Textura Corporation Confidential Textura Billing Process c Subcontractor Initiate Draw web based ic Aaa invoice entry i sina Finalize GC Pay Request Current Fela a Rece
11. 0 0 00 0 00 pi Leb amp Past r 3i 10 000 00 10 000 00 0 00 0 00 Based on the setup above the Textura to CMS interfaces will upload invoice and payment records to the correct job sub job coding in CMS CMS Textura Integration User Manual Page 16 of 43 Textura Corporation Confidential Completing the subcontract in Textura Introduction Subcontracts are entered in CMS and exported to Textura Textura will accept all subcontracts new to Textura If a subcontract is currently incomplete in Textura the subcontract will be updated if included in the export file If the subcontract is already complete in Textura the record will be rejected as a duplicate if it is included in the export file Subcontracts will be imported into Textura as incomplete subcontracts if the Vendor ID has not been assigned to a project previously and the GC s SoV is more than one line If the Vendor ID has been previously assigned and the SoV is one line the subcontract will automatically be imported as complete 1 To view the incomplete subcontracts from the Project Home Page click SoV Subcontracts and select Subcontract List So Subcontracts Su Heo nt bgt List Create Subcontract Edit Code Hierarchy The system displays the Subcontract Listing page with the subcontracts C Textura System Subcontract Listing Microsoft Internet Explorer aAA File Edit View Favorites Tools Help L l A 4 i gt 7 lr LA Q 6 9
12. 008 14 Mar 2008 The Subcontractor will be required to allocate the change order to their schedule of values There is no further action for the GC CMS Textura Integration User Manual Page 21 of 43 Textura Corporation Confidential 5 Legal Document Interface Entering Legal Document Requirements in CMS Legal document requirements should be entered into CMS as they are today If the subcontract is a Textura managed subcontract the legal document information will automatically be tagged for download to Textura Exporting subcontract change orders to Textura The process of exporting Legal Document requirements to Textura will be managed by the AS400 Job Scheduler See Section 7 Textura Send Receive Scheduler for more information on scheduling the job to download subcontracts and subcontract change orders Viewing Legal Document Requirements in Textura Each time the legal document import is run all status data for each subcontractor relative to the compliance documents stored in CMS will be refreshed with the data in the import file The status for each legal document is as follows elf there is no information regarding the requirement for the subcontractor the status is set to Not received elf there is an existing record for the requirement for the subcontractor that has a status of Not Applicable the status will remain at Not Applicable elf information is supplied for a particular requirement for
13. CH Payments Interface ns 28 DISDUFSING EUROS IN 4 1 nr dt en dette en 28 EXPOPRUIMPOMN PIOCCSS ee ee ten eme sens nee cpanoaueeue sta tn scene states sonne ns 28 Completing payment posting in CMS nn ss sese seene eenn nenen ennenen nenen 28 8 Textura Send Receive TOn e TE ut aaae aai 31 DEN GING IRTORMAUONME SES nn a ete entente notes rate teen end 31 RECEIVING INTONIMAUION sssrin nes tn de tetes ut rte ed imn nine mana dise 32 Initiating th Program Ad FOG SU a a a a ame ie 33 9 Work with Textura Transactions sss sss sss sss sss ss sss s sse ss esse ese seene 34 CMS Textura Integration User Manual Page 3 of 43 Textura Corporation Confidential Option 3 Work with Textura Transaction eenn eenn enen 34 Summary Of Available ACTIONS sss sese sss sse sese eenn ennenen nenen ennenen enne 34 SUS ONCE ACIS ER a nee oies 37 Subcontract Change 6 L a an na end nn ni te aa cie 39 MV OIG OS NN ns seen etnn De ln de se ne annee tn net use tena tele tel nete uses est 41 nd 2 2 LI 0 a sos E a D EP SE a a E 42 CMS Textura Integration User Manual Page 4 of 43 Textura Corporation Confidential 1 Overview Description This manual is a guide for utilizing the interfaces between Textura and CMS processing the related workflow in both systems Information for setting up the interfaces can be found in the Installation Guide It is not intended to be a guide for the AS400 or CMS For more information on the AS400 and CMS please refer
14. Construction Payment Management Textura CMS Integration User Manual Version 2 0 June 16 2008 This user manual contains confidential information of Textura LLC and is protected by all applicable patents copyright trademark trade secret and similar intellectual property laws Neither this document nor any of the information contained in this document may be reproduced or disclosed to any person under any circumstances without the express written permission of Textura LLC Copyright 2006 All rights reserved Textura LLC Processes and technologies described in this document have US and Global Patents Pending CMS Textura Integration User Manual Page 2 of 43 Textura Corporation Confidential Table of Contents E 6111 017111 7 T 5 DOS CHIP WON nn nn en esse eme nnn cerise a et ere ee 5 Interface Development Approach esse sees sees ssesesese essen eenn nenen nenen enean eee 5 Textura CMS Workflow Summary 5er ns en sure en sees senenn ennenen eenn 5 Textura Biling PFOCRSSSS Sn etes ete Encre nettes en anse t 6 A Socontracts Subcomtact Chans e E a T YET 6 Subcontract Cime c R LE nn eme Gace hs wed aaa wed se OR 6 D AP TIVO SE Re a eR eC eee le dl 7 Co RT E Re Nicer ARS ES See SMU ee Ca ON EOC EO TnL TONS ET 7 DD TAN TNC TTT 7 2 Identifying your Accounting Package in Textura sssssssssssssssssss esse sss sss cesses essen een ee 8 Setting up your Accounting Package ss sese sese ss sees seene 8 Creating the pr
15. Held The record will not be sent to Textura until you change its status 5 View Details This action provides you with a view of the subcontract change order record details in a single screen with information such as job sub job vendor id vendor name contract number item number change order number sequence number change order description change order amount and Status Invoices 5 View Details This action provides you with a view of the invoice record details in a single screen with information such as job sub job vendor id vendor name contract number item number cost distribution invoice amount retention amount invoice number description 1 e partial or final and indication of retention only invoices Payments 3 Release This action allows you to release a previously held payment making it available to be posted 4 Hold This action allows you to change the status of a payment record from Pending to Held Once on hold a payment record will no longer display on the payment edit report 5 View Details This action provides the user a view of the payment record details in a single screen with information such as job sub job vendor id vendor name contract number item number cost distribution payment number payment amount payment date invoice amount retention amount invoice number invoice date and description 1 e partial or final CMS Textura Integration User Manual
16. Hold Performance Bond Proof of Insurance Schedule Signed Contract ADVANTAGE STEEL sub 1 2 Click the Subcontractor link to view the document detail The system displays the Legal Document View page listing the documents that were imported for the subcontractor The Status ID and dates are populated with the import information Home Log Out Fa Te xtu ra Edit Docu ment Status Haine Construction Construction Payment Management Project Test Project 10 000 001607 Help Pais Feet ae O Organization ADVANTAGE STEEL M Document Date Expiration Date Document Action When Expired or Missing Performance Bond Received Submit Performanc 0 7 Jun 2005 24 31 Dec 2010 Proof of Insurance Received Submit Insurance C 14 Mar 2008 31 Dec 2010 Schedule Received Review Project Sct 10 Jun 2005 31 Dec 2010 Signed Contract Received Submit Signed Cor 01 Jun 2005 3 31 Dec 2010 CMS Textura Integration User Manual Page 23 of 43 Textura Corporation Confidential 3 To edit legal document requirements return to the Legal Document Status page and click Edit Legal Document Requirements 4 Add Delete document requirements as appropriate and click Save Settings Ha Textura Setup Document Requirements Nas Fami Adams Family Corstruction Construction Payment Management roject 10 000 001 6f Name Project 1998 Number Expt ation Notices days in advance
17. MS Payments made to subcontractors with Textura managed subcontracts via manual check will be handled in the same way they are handled today within CMS CMS Textura Integration User Manual Page 7 of 43 Textura Corporation Confidential 2 Identifying your Accounting Package in Textura Setting up your Accounting Package The Textura Administrator must identify the Accounting Package interface that is used when the Organization set up in Textura When an Organization is invited to join a project on Textura the Edit Organization link is displayed on the main home page Click this link The system displays the Edit Organization page Address Line 1 51 Sherwood Terrace Address Line 2 City Lake Bluff S Bank Name State Illinois v gt Bank City Zip Code 60044 Bank State Select State County Lake Phone 847 998 0987 Bank Account Name Routing Number or SWIFT Code 123456780 L J CONCERNING ACH ROUTING NUMBERS Routing numbers often differ from Fax the number on a Check or Deposit Ticket Please confirm with your bank that the routing number you use is valid for ACH transfers Note Routing Mobile numbers which begin with the digit 5 are not used in the ACH system Alternate Phone Default Currency Tax ID Organization Type USD lt 111 11 1111 Corporation Stored account on file ending in 1111 Bank Account Re enter Ban
18. Page 36 of 43 Textura Corporation Confidential Subcontracts You can filter the records by Job Number Sub Job Number and Contract Date 5 02 07 Work With Textura Transactions QPADEVOOTS Time 09 58 18 Subcontracts OSECOFR TXTTRANC2 Company 11 ADAMS COMPANIES US INC Job Nbr Division Sub Job Nbr Contract select option 2 Send Re send Job ub Opt Nbr Job Vendor Contract Item Nbr Status 001676 OOO LANE FIRE PROTECTION INC 15300 O1 Sent 001676 000 RUSHING 15800 O1 sent 001676 000 FALMER ELECTRIC 16100 O1 Sent 001666 OOO CAULKING SPECIALISTS INC 19200 Hi sent 001666 OOO MOSCH PAINTING WALLCOVERING 99100 O1 Sent 001666 000 FABRICATINGING 51700 O1 Sent 001666 000 HIGHWAY PROF SERV INC 50701 O1 Sent 001666 OOO COVELL PLUMBING 50600 O1 Sent 001666 800 RODE amp SOMNS INC 31200 OL sent 001666 OOO SCHIESS COMPANIES INC 26000 l Sent More The options for working with subcontracts are listed above the records These include 2 Send Resend 4 Hold 5 View Details Options 2 and 4 change the status as listed on this screen CMS Textura Integration User Manual Page 37 of 43 Textura Corporation Confidential Option 5 displays the details of the subcontract record as shown below Date 5 02 07 Work With Textura Transactions QPADEVOOTS Time 09 56 40 Subcontracts QOSECOFR TXT TRANGS Company 11 ADAMS COMPANIES US INC Division Job Nbr 001676 Sub Job O00 AGA Vendor 939908 RUSH INC Contract 15800 Item Nb
19. TAL DEBITS CREDITS 216 488 20 216 488 20 TOTAL gt 13 19x11in 1 of 1 d Start 7 E E LA amp aO E KL Inbo SU Rya SU Rya OEN 4 Rep R Docu A Rep Q 4 36 PM 5 When satisfied with the data to be update from the Batch menu select 20 Update a File Edit View Communication Actions Window Help Hel BRI ele a Le 28 al elo Adams Family Construction Co Accts Payable Fastpath 21 067 a 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_1 The update function will create an open payable record for the invoice and update the subcontract with the invoice information CMS Textura Integration User Manual Page 27 of 43 Textura Corporation Confidential 7 Subcontractor ACH Payments Interface Disbursing Funds in Textura Once funds have been disbursed the ACH payment information will be provided to the CMS interface for posting Only ACH payment information will be provided to CMS for posting Any checks written against a Textura invoice are assumed to have been written in CMS and posted against the appropriate invoice Export Import Process ACH Payments will be downloaded from Textura and formatted for a batch import into CMS on a daily basis The program to format the file for batch process will be managed by the AS400 Job Scheduler See Section 7 Textura Send Receive for more information on scheduling the job to format the batch import file
20. When satisfied with the data to be updated from the Batch menu select 20 Update 6 When satisfied with the data to be updated type Yes in the Edit and post field to post the data S File Edit View Communication Actions Window Help e Da RI ee a Rl a Ae Textura Payment Posting 07 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_1 The Edit and Post function will update the e Open Payable e Subcontract and e GIL CMS Textura Integration User Manual Page 30 of 43 Textura Corporation Confidential 8 Textura Send Receive Scheduler The Textura Send Receive Scheduler can be used to manage the timing of the regularly scheduled transfers as well as to initiate an ad hoc transfer Sending Information The first three lines relate to sending information 1 e subcontracts subcontract change orders and legal document requirements to Textura Exporting information to Textura will be scheduled to run at certain intervals during the day For example the program to send subcontracts may be scheduled to kick off for the first time during the day at 7 00 am and then to run every 2 hours during the day Subcontracts and Subcontract Change Orders will be downloaded at the same time The fields are CC ES End time for sending This field sets the time after which the send program will no longer run information to Textura for the day It will start again the next time it is scheduled
21. and only approved change orders are exported Duplicate subcontract change orders will be ignored when presented to Textura CMS Textura Integration User Manual Page 6 of 43 Textura Corporation Confidential B AP Invoices Subcontractor invoices will be entered directly into Textura by the subcontractors for any Textura managed project Project Managers will be responsible for approving the subcontractor invoices within Textura On a daily basis all approved subcontractor invoices will be retrieved and formatted in preparation for a batch import into CMS Duplicate invoice numbers will be rejected by CMS Once an invoice has been approved if there are any changes made in Textura the changes will have to be made in CMS separately At this time the interface process will not identify modified invoices C Legal Documents Legal document information will be entered into CMS using the same process as today For those contracts that have been identified with the textura keyword the legal document compliance information will be logged in a file for download to Textura D Payments Subcontractor payments will be made via ACH through Textura for any Textura managed subcontract The Disburser will be responsible for disbursing funds through Textura as usual On a daily basis all subcontractor ACH payments will be retrieved and formatted in preparation for import into CMS Each day one user will need to complete the posting process into C
22. e Budget Anwas Note The Item Number is fed over from CMS NEVER manually adjust the item number The system displays the Contract Maintenance Page 4 Type in the Subcontractor s Company Name next to Organization click the Find button 5 Select the proper organization name and the grey box above will auto populate Organization City State Create Cont ABC Construction L Chicago Illinois ABC Door Albuquerque New Mexico ABC Electrical Contractors Des Moines lowe ABC Erosion Control Leander Texas E ABC Flooring Specialists Londonderry Mew Hampshire Contract X i contract Amount 0 00 Default Payment Form Description Plumbing Default Retention Controlled E Open Book E subcontract Contract 13 Jun 2008 Sub SOV Option Date E Create Paired Use Specified Billing Lines by Phase Code Signatory approval of invoices Contract is not Complete Subcontractor cannot modify retention Bonding Institution Note This will only have to be done once Going forward Textura will remember the association between the Vendor ID and the organization CMS Textura Integration User Manual Page 18 of 43 Textura Corporation Confidential 6 At the bottom of the screen is the contract component Select the Phase Code and Description click Save Changes Top of Screen If the GC s SoV is only one line the Phase Code will automatically be assigned Click Save Changes to finalize the subcontract Copy Select
23. ed Delete Selected Contract Components Chg Orders Payments F 9 l Phara Description Ae cont Category Suber act iginal SUNAT arc Retention Fa S Paii To Dat Code Code tem Euxiget Anrount ane To Date Sana 20 000 00 20 000 00 Laih amp Plaster 10 000 00 10 000 00 Code Suija Removing the subcontract from Textura managed status To remove a subcontract from Textura managed status the user must change the keyword from textura to not textura It is not sufficient to simply delete the keyword textura From the Subcontract Maintenance Header Maintenance press F8 Text Maint aq File Edit View Communication Actions Window Help ES Ela ele Bs a RIR AI a 6 Date 10 19 06 XAPO46 Vendor Job Sub Number Number Job Contract Contract Expiration Contract Description Date Date Amount 2 Ongoing Currency Change Order Contract Rate Total Amounts Y N Type 09 040 aj 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_19 CMS Textura Integration User Manual Page 19 of 43 Textura Corporation Confidential On the Subcontract Text Detail Maintenance screen change the keyword in the Text Instructions area from textura to not textura ay File Edit View Communication Actions Window Help e Da AR ee a LS AII al ele Date 10 Vendor Job Contract H Text Code Text Instructions of 1902 Session successfully started Server
24. eject Collect Zero Dollar Lien Waivers L O L O Cumulative Material Totals and Automatic Split Payments Default Subcontractor Invoice Approval Method for New Subcontracts Project Manager System Approval Signatory Approval New subcontracts default to Specified Billing New invoices entered as whole de clude all sub jobs for this job number 4 Setup your subcontracts in CMS a For a subcontractor with only one subcontract setup the subcontract as you normally would using the appropriate job sub job and mark with the textura keyword b For a subcontractor with subcontracts on multiple sub jobs setup the initial subcontract on the first sub job as you normally would For the subsequent sub jobs create a zero dollar contract on the new sub job and create change orders to add the total dollars to the contract Mark all contracts with the textura keyword CMS Textura Integration User Manual Page 14 of 43 Textura Corporation Confidential IMPORTANT In order to manage the multiple subcontracts in CMS as a single subcontract in Textura the following conditions must apply e Contract Numbers must be the same on each sub job for an individual subcontractor e Subcontract tem Numbers must be different for each contract component across all sub jobs for an individual subcontractor The following example in CMS would interface correctly to Textura for this subcontract because all item s are unique across s
25. ive Current Lien Waivers cn Lien Waivers Approve Lien Waiver Accounting System i Subcontractor 9 XY S Owner Title Co pores R Forward LWsic Release Current GC Personnel Interaction Interface Point A Subcontracts Subcontract Change Orders Subcontracts will be entered into CMS using the same process as today with one exception if the subcontract is going to be billed through Textura the subcontract must be tagged with the keyword textura on the file This can be accomplished by selecting F8 when entering the record and typing textura in the text field This entry is not case sensitive Once a subcontract has been entered into CMS a program will be triggered automatically using the AS400 Job Scheduler to transfer the Textura managed subcontracts from CMS to Textura This transfer can occur once or multiple times per day based on the customer s preference Duplicate subcontracts will be ignored when presented to Textura If a change 1s made in CMS after the subcontract is transferred to Textura then the user will need to make that change in both CMS and Textura Subcontract Change Orders Subcontract Change Orders will be entered into CMS using the same process as today For those contracts that have been identified with the textura keyword the change orders will be logged in a file for download to Textura The transfer of subcontract change orders will be handled using the same process as described for Subcontracts
26. k Account Organization Role Accounting Package Document Imaging System Invoice Export Timing Project Fee Schedule View Fee Schedules Earnest Money Balance 0 00 Earnest Money Transactions View Earnest Money Days before passwords ace ml aie 365 K Default date input format mmiddiyyy e g 12 31 2008 O dd 31 12 Verify the correct accounting package and Invoice Export Timing is selected If your Accounting Package is not set up when you edit your organization contact your Textura System Administrator and they will be able to update your Accounting Package Creating the project in Textura When creating a project type your CMS job number in the Internal Project Number field These fields must match between the two systems in order for the interface to work properly as Internal Project Number is one of the unique identifiers for the interface Project Number This needs to be in a format that will be recognized by the interface The format should be Company Division Job No Sub Job No 10 000 001607 005 10 000 001 607 005 CMS Textura Integration User Manual Page 8 of 43 Textura Corporation Confidential Log Out Pa Textu ra Create Project Textura Administrator Adams Construction Construction Payment Management Project Information Project Name Test Project General Contractor Project Number 10 000 001607 005 Project Type Commercial New Original E
27. oject in TEx UI A sees eenn enen 8 3 SLUDCONIHACIS INTRA e nes na sans csnenne ss amiens asie 10 Identify the Textura managed subcontract in CMS un sees sese eee 10 Exporting subcontracts to TEXAS sonne sens sante nenen ennenen enean nenen eee 12 Managing SUD JODS in Textura ss ssssssssss sss ss sss ssssss essen senenn ennenen ennenen ennenen 12 Completing the Subcontract in Textura css ssssss esse ss esse ss sees sees senenn ennenen eenn neee 17 IN TOQUCLHION HTHH HHHH 17 Removing the subcontract from Textura managed status sese sss esse cesses se nenes 19 4 Subcontract Change Orders Interface sssssssssssssssssessssssss essen enen nenen ennenen 21 Entering Subcontract Change Orders in CMS cesses sese sssessss esse eee 21 Exporting subcontract change orders to TexXtUra nn seene nenen eenn eee 21 Viewing Subcontract Change Orders in TeXtUra sessss ese ssesess sees ee neee 21 9 Le0al DOCUMENU 9 TOST r e sis a nsen sense nee een 22 Entering Legal Document Requirements in CMS ss sss sese sees ss sees senenn ennenen neee 22 Exporting subcontract change orders to Textura sssssssssss esse ss ssss esse seene nenen eenn eee 22 Viewing Legal Document Requirements in Textura esse esse ssss esse sees sees ees eee ennenen eenn 22 6 Subcontractor Invoices Interface sese sssssssss esse sese eese enesenn ennenen ennenen enen 25 Completing the Batch Import process in CMS esse esse seene nne nenen ene 25 7 Subcontractor A
28. or each subcontractor e One pay application from each subcontractor Note Option 2 is an on off setting i e you can t have two sub jobs under the same job number as one project in Textura and a third sub job under the same job number as a separate project in Textura For Option 2 there is one minor change that needs to be made in the Textura project settings and a few key things to remember when setting up the subcontracts in CMS CMS Textura Integration User Manual Page 13 of 43 Textura Corporation Confidential Option 2 Project Setting Modifications To interface subcontracts from CMS to Textura under Option 2 1 Setup the project in Textura as you normally do using the primary Job SubJob number combination in to populate Textura internal project number field e g 11 000 1234 000 2 From the Project Home Page click the Project Setup menu and select Project Settings The system displays the Project Settings page 3 Scroll down to the Project Settings section and check the Include all sub jobs for this job number checkbox iystem Project Settings Windows Internet Explorer https www3 texturalle com system ProjectGCSettings psp projectID 1162 Textura System Project Settings Project Settings L Subcontractors may edit Lien Waiver effective date K Subcontractors may add Lien Waiver optional text Subcontractors may add Contractor Affidavit optional text Owner Approval Disables the GC ability to R
29. ours until 5 00 pm If the program is kicked off at 7 00 am in the morning it will run at 7 00 am and 3 00 pm each day Suspend receiving information to This field will default to No N The user can stop the receive Textura program by changing this field to Yes Y File Edit View Communication Actions Window Help a el AR E Me eal al ele Date 10 19 06 Textura Send Receive Scheduler QPADEVOOMW Time 16 31 33 DBROWN TXTSCHMO1 End time for sending information to Textura i 17 00 00 scheduling interval hours for sending PSP EE to Textarea ia a 208 suspend sending information to Textura 4 4 4 4 4 4 o ss Ending time for receiving information from Textura 17 00 00 Scheduling interval hours for receiving information from Fat Ur 8 00 suspend receiving information from Textura N Send information to Textura now Receive information from Textura now F3 Exit 05 072 Server Room LaserJet 5000 Series PCL6 on IP_1 aj 1902 Session successfully started CMS Textura Integration User Manual Page 32 of 43 Textura Corporation Confidential Initiating the Program Ad Hoc The last two lines relate to initiating the programs in an ad hoc fashion at any time during the day For example if the user has entered subcontract change orders into CMS that they need available in Textura for subcontractor billing the user could choose to initiate the send program from this screen by changing the N
30. porting subcontracts to Textura will be managed by the AS400 Job Scheduler See Section 7 Textura Send Receive Scheduler for more information on scheduling the job to download subcontracts and subcontract change orders CMS Textura Integration User Manual Page 12 of 43 Textura Corporation Confidential Managing Sub Jobs in Textura Textura offers two options for managing sub jobs interfaced from CMS Option 1 Each job sub job combination in CMS represents a single project in Textura e g 1234 000 and 1234 002 would each be considered a project in Textura Each project has the following e Separate Project Budgets SoV e Separate Contracts e Separate Pay Applications for both GC and subcontractors For Option 1 there is nothing that you need to do differently in Textura or CMS from what you do today for the interfaces When you create the project number in Textura it should include Company Division Job Number SubJob Number If you have two sub jobs you Il have two projects in Textura When you add the textura keyword to contracts in CMS the interface will pull those contracts into the appropriate project within Textura Option 2 All job sub job combinations are rolled together into a single project in Textura e g 1234 000 1234 001 and 1234 002 would be considered one project within Textura The project has the following e One Project Budget SoV e One contract with multiple contract components f
31. r O1 DESIGN BUILD HVAC Contract Amt 260 137 00 Retention Pct 00 Status Sent CMS Textura Integration User Manual Textura Corporation Confidential Page 38 of 43 Subcontract Change Orders You can filter the records by Job Number Sub Job Number and Contract Date 5 02 07 Work With Textura Transactions Time 09 59 06 subcontract Change Orders Company 11 ADAMS COMPANIES US INC Division ct option id Re send Sub Nbr Job Contract 001624 GOO WOODWORKERS INC 6210 001666 880 SWISH MECHANICAL INC 23000 001666 00O KOVACH STRUCTURAL 20104 001666 00O KOVACH STRUCTURAL 20104 001666 060 KOVACH STRUCTURAL 20104 001538 002 RITCHIE COMPANY INC 6111 001538 902 RITCHIE COMPANY INC 6111 001538 002 RITCHIE COMPANY INC 6111 0010652 036 FLYWAY TECH 16100 001052 MINNESOTA FIRE PROTECTION 15300 The options for working with subcontract change orders are listed above the records These include 2 Send Resend 4 Hold 5 View Details Options 2 and 4 change the status as listed on this screen CMS Textura Integration User Manual OT Job Nbr Sub Job Nbr Contract CO Item Nbr Nbr O1 3 O1 DI Ol O1 03 02 ai j O1 Textura Corporation Confidential g 4 3 2 1 5 5 5 B 1 OPADEVOOTS QSECOFR TXHITRANCS co Seq 1 1 1 1 1 3 1 1 1 Stat Sent sent Sent Sent Sent Sent Sent Sent sent sent ia Page 39 of 43 Option 5 displays the de
32. stimate Start 01 Jan 2008 7 Original Estimated Completion Date 31 Dec 2008 i Create Project Once the project is setup in Textura it will be ready to receive subcontracts subcontract change orders and legal document information as entered into CMS If you enter subcontracts and try to download them to Textura prior to setting up the minimum project information you ll have to resend the subcontracts again in order to get them entered into Textura See Section 7 Textura Send Receive Scheduler for information on how to resend subcontracts and subcontract change orders to Textura CMS Textura Integration User Manual Page 9 of 43 Textura Corporation Confidential 3 Subcontracts Interface Identify the Textura managed subcontract in CMS For subcontracts that are going to be managed through Textura they need to be tagged as a Textura managed subcontract when entered into CMS To identify a subcontract as a Textura managed subcontract the user must perform the following From the Subcontract Maintenance Screen in CMS type the Vendor and Job Number a Ryan270 Sex File Edit View Communication Actions Window Help S AA AR ee a RR AI S eld XAP046 Job Sub Maint Com Div Vendor Number Job Contract Type Types 1 Single Line Maintenance 2 Multi Line Maintenance 06 012 07 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_1 CMS Te
33. t Option 3 from the Textura Interface Management menu Type your Company and Division Select the type of transaction with which you would like to work CMS Textura Integration User Manual Page 34 of 43 Textura Corporation Confidential Work With Textura Transactions CMS Textura Integration User Manual Page 35 of 43 Textura Corporation Confidential The table below describes what actions you can complete for each type of transaction Available Actions Subcontracts 2 Send Resend This action allows you to change the status of a subcontract record from Sent to Pending The record will be sent to Textura the next time the interface runs 4 Hold This action allows you to change a subcontract record s status from Pending to Held The record will not be sent to Textura until you change its Status 5 View Details This action provides you with a view of the subcontract record details in a single screen with information such as job sub job vendor id vendor name contract number item number contract amount retention percent and Status Subcontract 2 Send Resend This action allows the user to change the status of a Change Orders subcontract change order record from Sent to Pending The record will be sent to Textura the next time the interface runs 4 Hold This action allows you to change the status of a subcontract change order record from Pending to
34. tails of the subcontract change order record as shown below Date 5 02 07 Work With Textura Transactions OPADEVOOTS Time OLS RESTE RC Change Orders OSECOFR TXT TRANO4 Company 11 ADAMS COMPANIES US INC Division Job Nbr 001666 Sub Job O00 RICHFIELD OUTLOTS BLOGS 2 3 8 Vendor 1187 SWISH MECHANICAL INC Contract 23000 Item Nbr O1 HVAC Cost Distribution 23 230000 Cost Type 5 Change Order Nbr 4 seq Nbr 1 Description COH1 ADD 2 RTUS PER 4 17 REQUEST Revision Amt 18 450 00 Status Sent CMS Textura Integration User Manual Page 40 of 43 Textura Corporation Confidential Invoices You can filter the records by Job Number Sub Job Number Contract Vendor Number or Invoice Number Date 5 02 07 Work With Textura Transactions QPADEVOOTS Time 09 59 41 Invoices QSECOFR Company 11 ADAMS COMPANIES US INC Job Nbr Division Sub Job Nbr TXTTRANCS Contract Vendor Nbr Invoice Nbr Vendor Contract Item Nbr Invoice Nbr 001052 WOODWORKING INC 15300 01 11 000 001 001052 SWISH MECHANICAL INC 8110 0i 021052036 001052 KOVACH STRUCTURAL 15401 O1 021052036 001052 MOSH PAINTING amp WALLCOVERING 9900 021052036 001052 MOSH PAINTING amp WALLCOVERING 9900 01 021052036 001052 COVELL PLUMBING 15800 021052036 001052 RODE amp SONS INC 9260 01 021052036 001052 FLYWAY TECH 16100 01 021052036 001167 CAULKING SPECIALISTS INC 15401 01 011167052A 001167 CAULKING SPECIALISTS INC 15401 O1 021167052 More The op
35. tions for working with invoices are listed above the records Option 5 displays the details of the invoice record as shown below CMS Textura Integration User Manual Date 5 02 07 Work With Textura Transactions OPADEVOOTS Time 09 59 56 Invoices OSECOFR TXT TRANOS Company 11 ADAMS COMPANIES US INC Division Job Nbr 001052 Sub Job 036 UNITED HEALTH GROUP TI Vendor 10247 SWISH MECHANICAL INC Contract 68110 Item Nbr O1 DOORS FRAMES HARDWAR Cost Distribution O80 081100 Cost Type P Invoice Amt 25 861 56 Retention Amt 00 Invoice Date 04 24 2007 Description PARTIAL Retention Invoice No Textura Corporation Confidential Page 41 of 43 Payments You can filter the records by Job Number Sub Job Number Contract Vendor Number or Payment Number Work With Textura Transactions Payments The options for working with payments are listed above the records These include 3 Release 4 Hold 5 View Details Options 3 and 4 change the status as listed on this screen Option 5 displays the details of the payment record as shown below CMS Textura Integration User Manual Page 42 of 43 Textura Corporation Confidential Work With Textura Transactions Payments CMS Textura Integration User Manual Page 43 of 43 Textura Corporation Confidential
36. to Y in the Send Information to Textura now field The fields are Send information to Textura now Initiate the send program immediately Receive information from Textura now Initiate the receive program immediately File Edit View Communication Actions Window Help S e BR el elal S ele Date 10 19 06 Textura Send Receive Scheduler QPADEVOOMW Time 16 31 33 DBROWN TXTSCHMO1 End time for sending information to Textura 17 00 00 1 00 Scheduling interval hours for sending Re fe p tura Suspend sending information to Textura a 4 42 42 adaa amp 8 4 aa N 17 00 00 Ending time for receiving information from Textura Scheduling interval hours for receiving information from ppp 8200 Suspend receiving information from Textura N Send information to Textura now Receive information from Textura now F3 Exit 05 072 rh 1 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_1 CMS Textura Integration User Manual Page 33 of 43 Textura Corporation Confidential 9 Work with Textura Transactions Option 3 Work with Textura Transaction The Work with Textura Transactions menu can be used to manage the individual send receive records for subcontracts subcontract change orders legal document requirements invoices and payments You can access this menu by typing TXTURA in the Fastpath field Option _ Fastpath Summary of Available Actions When you selec
37. ub jobs 990 and 991 1234 12190 25 000 00 1234 12190 40 000 00 The following example would not interface correctly because the item s are not unique 10 000 00 a p lt lt E fw p 9 CMS Textura Integration User Manual Page 15 of 43 Textura Corporation Confidential 5 When the interface exports the subcontracts to Textura the sub job numbers are stored on the Contract Maintenance screen in the Subjob field The Subjob field will not be populated for the primary sub job number i e the sub job used in the Textura internal project number In the example below the internal project number is 11 000 1234 990 and the second sub job number is 991 You can see that 991 has been stored for two of the contract components in the Subjob field Also please note that the subcontract item numbers continue to be unique Reeatlocating for Draw 3 Not yet initiated Subcontraci a oii Subcontractor Contact Amount iog G0 Da C fauit Payment Form Cesengton LATH amp PLASTER Default Retention Controlled Subcontract Ha Open Book F subcontrad UT VO7 Sub SON Option None Dale Lise Speied Biling O Signaloy appraval of invoices UO Aane Killing Of Add New Component Copy Selected Delete Selected Contract Components Chg Orders Payments Phase PRE Account Category Subcontract Original Subcontract l Retention Code AMP code Code TN hens Budget Amount Tp Tome O General sn 01 20 000 00 270 000 0
38. xtura Integration User Manual Page 10 of 43 Textura Corporation Confidential From the Subcontract Maintenance Header Maintenance press F8 Text Maint aq File Edit Yiew Communication Actions Window Help e s IR ee a LS AAE a el XAPO46 Vendor Job Sub Number Number Job Contract Contract Description Date Date Expiration Contract Amount 2 Ongoing Contract Y N Change Order Currency Total Amounts Rate Type oJ 1902 Session successfully started 09 040 Server Room LaserJet 5000 Series PCL6 on IP_1 CMS Textura Integration User Manual Page 11 of 43 Textura Corporation Confidential On the Subcontract Text Detail Maintenance screen type the keyword textura in the Text Instructions field aq File Edit View Communication Actions Window Help e Da RI ee a L AI Sl Date 10 19 06 PP648 Time Update Page Vendor Job Contract H Text Code Text Instructions 07 002 gy 1902 Session successfully started Server Room LaserJet 5000 Series PCL6 on IP_1 At this point the subcontract information that you have entered and identified as Textura managed with the textura keyword will be downloaded to Textura and associated with the Textura project if the project numbers match The format for project numbers in Textura must equal Company Division Job Number Sub Job Number e g 10 000 001607 005 Exporting subcontracts to Textura The process of ex
Download Pdf Manuals
Related Search