Home

Textura Viewpoint Integration Manual

1. 0 E E A A AAA a q E E amp E g VA Purge Master Audit VA Report Security VA Scheduled Changes This is a Programs Folder Yiew Details Sort Title E PSample la class1 Co 3 4 start Y 3 Main Menu for Proje 019225 Textura Viewpoint Integration Manual 7 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management 4 In the Report Security Screen change company option to Across All Companies and press REFRESH CE dfinterfaces2 texturallc net Remote Desktop Connection Ea Xx M3 YA Report Security for Project Management Company MEJ xi Edit Options Tools Windows Help ews Filters Group User ww PO id Company Select Company 3 Project Management Comp C User O C Across All Companies gt Refresh Access Level Allowed None Denied o Initialize H Apply x Cancel Report ID Title Security Group Description Access Show reports For this module only leave blank for all Co 3 q Start E Y 3 Main Menu for Project fr 3 YA Report Security 7 OMAR 5 5 The system will display a list of reports available across all companies 6 In the Title filter enter Tex and select REFRESH 7 The system will display a list of Textura Reports Textura Viewpoint Integration Manual 8 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Managem
2. Retainage Discs Discount 0 00 0 00 10 00 0 00 0 00 0 00 gt Freight 0 00 Sales Tax D 00 Dise Total A A AS ST EE EEE FSLITestSL Load Subcontract Gross LS 0 00 M 0 00 0 T 450 00 pad p poy Last Record View Cae eel 2 Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM 44 Textura Confidential Pa Textura Construction Payment Management SUBCONTRACTOR PAYMENTS INTRODUCTION The following is a guideline for recording the payment of invoices paid via ACH managed by Textura Funds will be disbursed in Textura as they are today Once funds have been disbursed the ACH payment information will be provided to the Viewpoint interface for posting Only ACH payment information will be provided to Viewpoint for posting Any checks written against a Textura invoice are assumed to have been written in Viewpoint and posted against the appropriate invoice 9 2 EXPORT SUBCONTRACTOR PAYMENTS From the Textura Draw Home Page under the green and white section labeled Interfaces select the link labeled Export Payment Records y Textura Draw Home Page Se see Construction Payment Management ect UNL Abel Test 001321009 ee an Hep General Construction i 5 01 18 08 Draw Date 01 18 08 Period Ending 01 31 08 Draw Summary Draw Actions Show draw summary Subcontractor Invoice Status Your Draw Documents Subcontractors Invited 3 Invoice Invoices Received 3 Lien
3. Construction Payment Management Tanie Durkee a Textura Project Home Page NL Ce Son ct Prairie Lake Es Construction Payment Management Project Summary Project Actions 3 Unread messages Show project summary None Subcontract Change Orders Prime Contract Change Orders a Show Prime Contract Change Orders Pending Draws Show Subcontract Change Orders None None 63751 2003 2007 Textura Corporation Log Out Tarrie Durkee mu l a Textura Project Home Page ae Construction Payment Management Project Erite Lake Estates Sees re me Pl Draw Interfaces So Subcontracts Change Orders Project Setup Reports Compliance Project Summary Project Actions e SLES Show project summary Prime Contract Change Orders Subcontract Change Orders z 2001 Change Order 1 Show Subcontract Change Orders Pending Draws None 33751 2003 2007 Textura Corporation Notice that the SoV Subcontracts menu is red notifying you that you now have unallocated Change Orders 6 Click the red SoV Subcontracts menu and select Edit Schedule of Values Unallocated Change Orders Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 29 Pa Textura Construction Payment Management Subcontract List Create Subcontract Edit Schedule of Values Setup Invoice Codes Assign Invoice Codes a e View Ss che du le of Values The sy
4. 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 Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management Came Durkee yo Text U ra Subcontra ct istina Heiberg Developers 5 Construction Payment Management Prairie Lake Estates Sta General Conatructicn Create Men Sub oF rack Suben Suman Anami Paid To Data Retention Held Balance Duro incompleto Sub H dere Comi act ihaihier Cerne Dio iar HVE DEDO OORT _ DEMOLITION DEJO ul PANTO DST i STUDS AND ROCK OSADO FIRE PROTECTION GPT sia Pk Pe AA ey DEUT T 070715049 To complete the subcontracts 1 Click the Contract Number link for each Incomplete Subcontract Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the Contract Maintenance page 2 Click on the Edit Settings button J Text ura Contract Maintena nce Heiberg Developers Construction Payment Management 070715800 HVAC Save Changes Revertto Saved Reallocating for Draw 1 Not yet initiated Delete Subcontract Add New Component Copy Selected Delete Selected Contract Components Chg Orders Phase ae Account Category Subcontract Original Subcontract Retention Code Descrip
5. and dates are populated with the import information Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management Mg Textura Construction Payment Management Project Home Log Out Torn Jones Document Compliance View a raconti Project Hill School 0514a Help Organization Document Expiration Document Name ID Action Ins Certificate Received Received v 03 10 08 Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 64 Pa Textura Construction Payment Management 3 To edit legal document requirements return to the Legal Document Status page and click Edit Legal Document Requirements Add Additional Requirements by clicking the Add Requirement button Delete requirements by checking the Delete box to the right of each requirement and click the Delete Requirements button Mg Textura Construction Payment Management Hill School 0514 Setup Document Requireme a Project Organization Document Expiration Document i Name Status ID Date Date Action issi Auto Insurance Automobile Insurance General Liability Insurance Ins Certificate Received Umbrella Insurance Worker s Compensation Insurance Hill School Sub1 Not Received Y Received v Px985181 03 18 02 03 18 03 Received v 5C0522788301 0318 02 03 18 03 Rec
6. 7 Allocate the change order to the appropriate line s for each change order that was imported 8 Click Save Changes The system displays a Status page notifying you that the budget for General Construction has been saved Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management Home a Textura Status ie Construction Payment Management oject Prairie Lake ESTO The budget for has been saved To edit the budget again click here To allocate additional imported Prime Contract Change orders click the link that states To edit the budget again click here The system displays the Edit Schedule of Values page Repeat steps 6 8 until all lines have been allocated When finished return to your Project Home Page Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management EXPORT SUBCONTRACTOR INVOICES FROM TEXTURA INTRODUCTION Vendors subcontractors will enter invoices in Textura After approved by the general contractor in Textura invoices are imported into Viewpoint Imported records with duplicate invoice numbers invoice number already exists for a vendor will be rejected by Viewpoint EXPORT INVOICES FROM TEXTURA To export invoices from Textura 1 From the Project Home Page click to open a draw The system displays the Draw Home Page
7. Pa Textura Construction Payment Management INTEGRATION USER MANUAL FOR VIEWPOINT VO SOFTWARE VERSION 6 3 MARCH 1 2011 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 2011 All rights reserved Textura LLC Processes and technologies described in this document have US and Global Patents Pending Pa Textura Construction Payment Management Table of Contents Table of ONIS eras 3 OVINA 4 PSS COO eter vieteice ye E E nap canseencnssaiesseespisuneutes edn cuss E E E 4 POU Viewpoint VV OUT WY caras 4 Subcontracts and Subcontractor Change Orders ccccccssseccccsseccccencccccesececeeeceeceecceeeeeeesseecesseseceeteeaeeeeas 5 AF ON 5 Compliance DOUNE etnia E 6 o E E E A A A E E E A NE 6 Textura Viewpoint Initial Interface Setup occoonccconociconnceconncconcncnnancnnnnncnnnncnnnnrnnnnrrnnnnrnnannenannno 7 MUSOU ON e E ce wen eran ary ne er et rene ee ae aero ee erect een re ee 7 Setting Up your Viewpoint to Textura EXPOPts ccccscccseccseccseccseceseceseeceecceusceusceuscesscaeesseeeeseceseceseeeseenseenes 7 Identifying y
8. Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management A Construction Company OF x File Edit Options Tools Windows Help So iy ImportID Template lap Pay Txt AP Payment Textura Import File P viewpoint Transfer pave cs ay Browse ey Execute Import Results Starting import process For AF Pay Txt File pay2 cow 11 36 13 Transferring data From text File 11 36 15 Transferring data to IM Work Edit 11 36 27 2 records created in IM Work Edit 11 36 33 Formatting data 11 36 33 Appling defaults 11 36 34 Appling cross references 11 36 34 Applying template defaults 11 36 35 Appling User routine 11 36 36 Updating IM Work Header table 11 36 36 Transferring data to IM Work Edit 11 36 37 2 records created in IM Work Edit 11 36 35 Formatting data 11 36 38 Enter the Import ID Cor 2 7 Click Execute The system displays the Import Results on the IM Import screen The program is done importing when a dashed line displays at the bottom of the display information see screen above Textura Viewpoint Integration Manual 53 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management UPLOADING PAYMENTS IN VIEWPOINT 1 In Viewpoint click the Imports folder click the Processing folder and then click the IM Upload icon YA 2 Main Menu for Yista Construction
9. Update Organization If your Accounting Package is not set up when you edit your organization contact your Textura System Administrator and they will be able to identify your Accounting Package Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM 11 Textura Confidential Pa Textura Construction Payment Management When creating a project type your Viewpoint 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 GC Project Information Project Name Project Type Internal Project Number Contract Description Advance Billing Open Book Create Paired Lines by Phase Code Current Estimated Start Date Current Estimated Completion Date Maximum Loan To Value Percent Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Commercial Mew General Construction Project Owner Contract Date Original Contract Yalue Contract Mumber GC Retention Percent Original Estimated Start Date Original Estimated Completion Date Textura Confidential t 020 2006 495000 00 10 00 22008 22 DO0S 12 Pa Textura Construction Payment Management EXPORT AND IMPORT SUBCONTRACTS AND SUBCONTRACTOR CHANGE ORDERS INTRODUCTION Subcontracts and subcontract change orders may be entered in Viewpoint a
10. At the bottom of the screen is the contract component Type in 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 Add New Component Copy Selected Delete Selected k Contract Components Chg Orders Phase Joge Account Category 2 Subcontract Original Subcontract z i Retention Code Description Code Code Subjob tem Y Budget Amount Paid To Date To Date Balance Due Hvac ao A Y hh 5 728 00 Totals 5728 00 5128 00 Textura Viewpoint Integration Manual 21 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the Status message notifying you that Changes to the contract have been saved and the contract is complete J Textura Statu Construction Payment Management 0002 Changes to contract have been saved The contract is complete To edit this contract again click here To create a new subcontract click here To return to the subcontract listing click here To create another incomplete subcontract click the appropriate link in the Status page Repeat steps 1 through 6 for each incomplete subcontract When finished return to your Project Home Page Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 22 Pa Textura Construction Payment Management IMPORT SUBCONTRACTOR CHANGE ORDERS If the import file contains a subc
11. Company File Folders Items View Options Links Windows Help 0 E al a ya de E 2 Vista Construction Company ki Vista Construction Company Menu My View pour Folders Items in Imports Programs vista Constructia Last Accessed A Li My Tasks 03 IM Batch Id 1 24 2011 9 00 48 AM a L Accounts Payak gagIM Cross Reference 1 11 2011 10 17 39 _ Programs Gy IM Import 3 8 2011 11 30 54 AM i Reports 471M Import Purge 1 24 2011 8 49 14 AM L Accounts Recel Im Template 1 24 2011 8 49 02 AM G Cash Manageme eit perp SS A ONT 11 34 06 Ni _ Document Man o e A Equipment Man e IM Work Edit 3 8 2011 11 46 46 AM _ General Ledger Cd Headquarters _ Human Resourc GI Imports 2 Programs Cd Reports GI Inventory CA Job Billing GJ Job Cost LJ Material Sales _ Payroll Cd Project Manage Cd Purchase Order GI Reports CA Programs This is a Programs Folder View Details Sort Title 4 WPSample a classi Com 2 O E El El El El E E dE E El El El E E The system displays the IM Upload dialog box Textura Viewpoint Integration Manual 54 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management EA Construction Company OF ES File Edit Options Tools Windows Help Sy Irniportid Template AP Payment Textura Import Form Description AF Payment Posting Enter the Import ID of the File to upload Coe 2 2 Type Textura in th
12. Construction Company al Fa File Edit Options Tools Windows Help y ImportID Template fap Pay Txt AP Payment Textura Import File A Browse FP Execute Enter the Import ID Co 2 3 Type AP Pay Txt in the Template field 4 Type Textura in the ImportID field 5 Click Browse to locate the import file The ImportID is just a label that is given to the invoice detail that is going to be imported Any name can be used The same ImportID can be used over and over again The program will display a warning ImportID currently exists for this template Overwrite existing import data Always answer YES The system displays the Open dialog box Textura Viewpoint Integration Manual 51 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management Please choose a file to import Ei E4 Look in G Viewpoint Transfer a y ful E invoices 1000 csv Te involces 10 3 c5w My Recent invoices 10235plib csv Documents payl csw pay cs pav1023 1 c5w Desktop pay1023 2 csv pay1023 split cs gt SL Textura Subcontract Compliance Export Ext SL Textura Subcontract Export Est My Documents My Computer N bio Network File name Places Files of type Text Files tet ase cay aha tty Cancel 2 6 Locate and select the Textura import file and then click Open The system inserts the file name in the Import File field
13. Export button Print Report Ma ox File h JC Textura Owner Change Orders Export Company 99 Beginning Job Ending Job Egos et Lrystal Engine 11 Ml y Textura Viewpoint Integration Manual 24 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the Export dialog box Export Format Destination j Disk File pr 3 Select Text TXT from the Format drop down menu The system defaults the Destination to Disk file 4 Click OK The system displays the Export to Text dialog box Export to Text E Characters per inch 20 Recommended value between 8 and 16 Cancel Number of Lines Per Page lo 0 Do not paginate Ensure the Characters per inch is set to 20 and the Number of Lines Per Page to 0 5 Click OK The system displays the Choose Export File dialog box Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management Choose Export File Save Ir E My Documents de Fe My Recent Documents Desktop io My Documents gr My E omputer de hy Network File name Testura O COE sport tet z save as lype Paginated Text txt gt Cancel EA 6 Type the File name and the location where you want to save the file Save in field 7 Click Save Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential
14. Options Links Windows Help 3 a 2D E ge 3 Project Management Company Project Management l VI EWPOINT Company Menu Items in Viewpoint Administration Programs L2 Project Management Company Tite ooo lastaccesed Oooo U o L3 My Tasks W VA Audit Log Viewer 7 L3 Textura Reports _ VA Business Intelligence Mgmt LJ Accounts Payable 4 VA Change Server Name 10 18 2008 8 54 46 Accounts Receivable SVA Copy Company Security gt Cash Management He VA Copy User Group Security a sella management 3 vA Custom Field Combo Boxes i Equipment Management BVA Custom Fields Wizard L3 General Ledger a e 1 Headquarters VA Custom Form Buttons LI Human Resources VA Custom Form Tabs i Imports BvA Data Security Access GI Inventory VA Data Security Purge LI Job Biling va Data Security Setup LI Job Cost y VA Datatype Label LI Programs VA Form Properties LI Reports IVA Form Security 1 7 2009 6 03 01 PM L3 Material Sales J VA Menu Templates L2 Payroll Y VA Message Archive L2 Project Management VA Message Archive Purge a Purchase Order CAVA Messages 1 12 2009 9 04 49 PM L Reports vA My VP Queries a Subcontract Ledger J WA My VP Query Security 0 ile J VA My VP Template Security LA User Database 3 Viewpoint Administration 12 Programs EI Reports amp VA Security Groups LI Workflow VA Site Settings 1 7 2009 6 03 20 PM 4 VA User Delete DPva User Profile 1 7 2009 6 03 13 PM gP VA View Generator
15. file 4 Ensure the Characters per inch is set to 20 and the Number of Lines Per Page to 0 6 Click SAVE Textura Viewpoint Integration Manual 14 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the Choose Export File dialog box Choose Export File Save IF E My Documents qe t O E My Recent Documents Deskto p My Documents My Computer r Ma Ai My Network File name ftexturaslexporti Ent Places save as type Paginated Text txt Cancel 2 7 Type the File name and the location where you want to save the file Save in field 8 Click Save Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management IMPORT SUBCONTRACTS INTO TEXTURA The file that you export from Viewpoint and import into Textura contains subcontracts and Subcontract Change Orders When Textura receives a subcontract that has already been imported or created Textura attempts to update the existing subcontract and contract components as identified by Subcontract Number and Subcontract Vendor Number If the import file contains a Subcontract Change Order that already exists in Textura then Textura will reject the import record as a duplicate To import subcontracts into Textura 1 From the Project Home Page click the Interfaces menu and select Import Accounting Informatio
16. 3 Select Text TXT from the Export Type drop down menu The system defaults the Destination to Disk file 4 Ensure the Characters per inch is set to 20 and the Number of Lines Per Page to 0 6 Click SAVE Textura Viewpoint Integration Manual 59 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the Choose Export File dialog box Save Report SL Textura Subcontract Compliance Export Ei x Save I 6 Viewpoint Transfer y tule Fe SL Textura Subcontract E F SL Textura Subcontract Export Ex My Recent Documents Deskto p My Documents Sr My Computer A Ai bly k File name SL Testura Subcontract Compliance Export tut Places Save as type Text Ext Cancel 2 7 Type the File name and the location where you want to save the file Save in field 8 Click Save Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management IMPORT LEGAL DOCUMENTS AND REQUIREMENTS INTO TEXTURA Note This is available at an Organization Wide Level see Organization Wide Documentation l Overview Each time the import is run all status data for each subcontractor relative to the compliance documents stored in Viewpoint will be refreshed with the data in the import file The status for each legal document is as follows e Ifthere is no information regarding the insuranc
17. 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management UPLOADING INVOICES IN VIEWPOINT 1 In Viewpoint click the Imports folder click the Processing folder and then click the IM Upload icon WW 2 Main Menu for Yista Construction Company File Folders Items View Options Links Windows Help a i E Bla Vista Construction Company H j 2 Vista Construction Company b Menu My Viewpoint Folders Items in Imports Programs vista Constructia Last Accessed J LA My Tasks E IM Batch Id 1124 2011 9 00 48 AM Fl LA Accounts Payak Im Cross Reference 1 11 2011 10 17 30 w Programs Wy IM Import 3 8 2011 11 39 54 AM Ed Reports 491M Import Purge 1 24 2011 8 40 14 AM Accounts Recel 1 Template 1 24 2011 8 49 02 AM 5 Cash Manageme E ROA Els CRC 9 act Me Wa IM Work Edit 3 8 2011 11 46 46 AM _ General Ledger Cd Headquarters _ Human Resourc Cd Imports 4 Programs Cd Reports Cd Inventory _ Job Billing LA Job Cost LA Material Sales Cd Payroll Cd Project Manage _ Purchase Order Cd Reports CA Programs r This is a Programs Folder Yiew Details Sort Title A WPSample a classi Com 2 O E E El El El E E dE El El El El El E The system displays the IM Upload dialog box Textura Viewpoint Integration Manual 39 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the IM Upload d
18. 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management IMPORT TEXTURA INVOICES INTO VIEWPOINT To alleviate the need to re enter invoices in Viewpoint a file containing the subcontractor invoice information for a draw is imported into Viewpoint 1 Transfer the Textura import file to the Viewpoint Server Y 2 Main Menu for ista Construction Company File Folders Items View Options Links Windows Help ae 3lad Vista Construction Company a 2 Wista Construction Company hi Menu biy Yiewpoint Folders Items in Imports Programs vista Constructia Last Accessed 7 Ld My Tasks J IM Batch Id 1 24 2011 9 00 48 AM El Le Accounts Payak gra Cross Reference 1 11 2011 10 17 39 2 Programs E EE OTE Sa o Ld Reports la Import Purge 1 24 2011 8 49 14 AM LJ Accounts Recel ef IM Template 1 24 2011 8 49 02 AM Cash Manageme TM Upload 3 8 2011 11 44 06 AM CA Document Man r E Equipment Man SIM Work Edit 318 2011 11 46 46 AM _ General Ledger Cd Headquarters _ Human Resourc _ Imports 7 Programs Cd Reports GI Inventory CA Job Billing _ Job Cost Cd Material Sales _ Payroll Cd Project Manage Cd Purchase Order GI Reports CA Programs This is a Programs Folder View Details Sort Title A YPSample a classi Com 2 O E E El El El E E dE E El El El E E 2 From Viewpoint s Main Menu click the Imports folder click the Processing fold
19. Cancel SL Textura Subcontract Compliance Export 300 Report Security Administrator 0 Allowed ar facct SL Textura Subcontract Compliance Export 310 Project Manager Reports 1 None Acct SL Textura Subcontract Compliance Export 331 a E a BA viewoint E SL Textura Subcontract Compliance Export 35 SL Textura Subcontract Compliance Export 35 SL Textura Subcontract Compliance Export 36 gr SL Textura Subcontract Compliance Export 39 4 SL Textura Subcontract Export 30 SL Textura Subcontract Export 311 SL Textura Subcontract Export 330 Accounts Payable Reports 1 None SL Textura Subcontract Export 340 Payroll Reports 1 None SL Textura Subcontract Export 350 My Viewpoint Reports 1 None SL Textura Subcontract Export 355 My Viewpoint Queries 1 None SL Textura Subcontract Export 360 My Viewpoint Templates 1 None SL Textura Subcontract Export 399 Audit Distribution Lists 1 None Allow access to all reports in the grid Are you sure M 3 Main Menu for Project 1 3 a Report Security 9 In the dialog box select YES Textura Viewpoint Integration Manual 10 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management 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 Tex
20. Pa Textura Construction Payment Management IMPORT OWNER PRIME CONTRACT CHANGE ORDERS INTO TEXTURA If the import file contains an Owner Change Order that already exists in Textura Textura will reject the record To import Owner Prime Contract Change Orders into Textura 1 From the Project Home Page click the Interfaces menu and select Import Accounting Information Interfaces ff Im Pi Accounting Information Manage Exports The system displays the Import Accounting Information page P Textura Import Accounting Information Construction Payment Management source Viewpoint V2 File te import impetCSVFie Cora 3 Click Browse to locate the CSV file you want to import 4 Click Import CSV File Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Brower 10 27 Pa Textura Construction Payment Management Home Log Out a Textura kii 43mm Viewpoint Construction Payment Management Your import has been submitted for processing import tracking number is 1232 To view the status of your import click here To process another import click here Done o temet 100 The system displays the Status page notifying you that Prime Contract Change Orders have been imported 5 Return to the Project Home Page click Show Prime Contract Change Orders Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 28 Pa Textura
21. TRANSACTIONS The sample import file testimport txt created the following two AP transactions in Viewpoint Pr testimport txt Notepad File Edit Format View Help O7fo1 2004 1004 1004 01 Test SL Load 0715 2004 1000 00 1 07 01 2004 1 Test SL Load O41018C01 1 1000 00 LS 0 00 0 00 1 O7fO1 2004 1004 1004 02 Test SL Load 0715 2004 500 00 2 07 01 2004 1 Test SL Load 041025001 i 500 00 LS 0 00 0 00 2 The following screen was created from the first two records in the sample import file Take note that the seq matches the record key Note that the Job Phase CT and retainage are filled in even though the import file does not provide for them Textura Viewpoint Integration Manual 42 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management ar Transaction Entry Test Company Aa E File Edit Records Options Window Help Month a Batch ler Seg i Header Payment Info Address Override amp 1099 Info O Notes Memos Action AP Trans Wendor AP Reference Description Invoice Date Disc Date Due Date Invoice Total ja 1004 1004 01 Test SL Load jor 504 osa 4 04 1 000 00 Yendor Lottzakrakza Concrete Address F O Box 125 Chandler 82 12347 gt Line fi Line Other Info O Notes Memos Acton Type Subcontract ltem JC Cot Job Phase CT JC UM A afse effosioiscor 1 f 3 pr pue fa is Description GL Co GL Account U
22. Viewpoint Reports 355 My Viewpoint Queries 360 My Viewpoint Templates 399 Audit Distribution Lists 300 Report Security Administrator 310 Project Manager Reports 330 Accounts Payable Reports 340 Payroll Reports 350 My viewpoint Reports 355 My viewpoint Queries 360 My viewpoint Templates 399 Audit Distribution Lists 300 Report Security Administrator 310 Project Manager Reports 330 Accounts Payable Reports 340 Payroll Reports 350 My Viewpoint Reports 355 My Viewpoint Queries 360 My Viewpoint Templates 399 Audit Distribution Lists 8 Select Allowed in the access level and INITIALIZE Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None 1 None Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Acct Co 3 o 99A8a Pa Textura Construction Payment Management CE dfinterfaces2 texturallc net Remote Desktop Connection M3 YA Report Security for Project Management Company File Edit Options Tools Windows Help E ae E Filters Group User Module SL Subcontract Ledger pi Company select company PT e eZ Across All Companies gt Refresh Access Level Allowed None Denied e H apply a
23. Waiver Invoices Approved 3 View Uploaded Files 0 Manage Draw Assemble Draw Documents for Printing Vi n View Draw Request Legal Document Status Draw Reports Retention Report Payment Lien Waivers Review Lien Waivers Lien Waiver Tracking Manage Payments View Subcontractor Affidavit Interfaces Export Subcontractor Invoices Export Payments Report Manage Exports 920 03 2007 Textura Corporation l https www5 texturallc comfintdemo InterfaceExportPayment psp projectID 1 748 amp drawRequestID 3940 amp contractID 17601 a FE 10 ey E e Internet 100 a From the Generate Payment screen click button labeled Generate Payment File and select the projects to include in the payment file generation Textura Viewpoint Integration Manual 45 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management a Home E y 6 3 Vrenoini lu Viewpoint ee Hen Generate Exports My Textura Construction Payment Management Target Viewpoint V2 E include ireoicas E inciuda Payments Generale Exports Include in Export Exclude trom Export TIS Tar Propeor E include Project Exclude Project Subcontractor Diganizatian 2 Vendor ID Check Include Payments Click Generate Exports Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential la Pa Textura Construction Payment Management Pa Textura Status Construction Payme
24. _ P Textura Draw Home Page Construction Payment Management Prane LPeelales 03001 contract General Construction Draw 1 05 13 08 Draw Date 03 13 08 Period Ending 03 31 08 Draw Summary Draw Actions Show draw summary Subcontractor Invoice Status Your Draw Documents Subcontractors Invited 3 Invoice Invoices Received 3 Lien Waiver Invoices Approved 3 View Uploaded Files 0 Manage Oram Assemble Draw Documents for Printing Legal Document Status view Draw Request Draw Reports Retention Report Review Lien Waivers Lien Waiver Tracking Manage Payments Payment Receipt view Subcontractor Affidavit Interfaces Export Subcontractor Invoices Export Payments Report Manage Exports 2 Click Export Subcontractor Invoices under the Interfaces heading Textura Viewpoint Integration Manual 32 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the Generate Invoice page displaying the vendors vendor ID and Accounting Period Pa Textura Construction Payment Management Generate Invoice Prairie CAMeeEstates 03001 General Construction 1 03 13 08 Target Viewpoint Subcontractor Organization Vendor ID sub 1 3735 sub 2 5857 Subsurface Construction 6240 Select values for export Accounting Period 3 31 2008 SES Invoice File Carrie Durkee Heiberg Developers 3 Type the Accounting Period 4 Click Generat
25. d Change Orders from Viewpoint to Textura Change orders Export owner prime contract change orders from Viewpoint to Textura Invoice entry Export a file containing the subcontractor invoice information for a draw and import the invoice details into the Viewpoint accounting system Payment entry Export subcontractor ACH payment information from Textura to a file formatted for posting in Viewpoint Compliance Logs Export required compliance documentation from Viewpoint to Textura Textura Viewpoint Integration Manual 4 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management TEXTURA BILLING PROCESS Subcontractor ev LEW Initiate Draw web based ni ntractor a invoice entry io TUN ices nA Return Invoice to Subcontractor Finalize GC Pay Application Invoices ubcontractor 7 Request Current tl Kare Receive Current Subcontractor came Subcontractor Subcontractor Lien Waivers collection Lien Waivers Lien Waivers Textura E 3 Forward LWs to Release Current Accounting System m Owner Title Co Subcontractor Lien Waivers GC Personnel Interaction O interface Point SUBCONTRACTS AND SUBCONTRACTOR CHANGE ORDERS Enter Subcontracts in Viewpoint and export them to Textura Subcontracts can have multiple item distributions between phase codes and cost types Enter approved subcontract change orders in Viewpoint and export them to Textura Only approved change orders are exporte
26. d to Textura Textura will accept all new change orders and reject duplicate or previously exported change orders AP INVOICES Vendors subcontractors will enter invoices in Textura After approved by the general contractor in Textura invoices are imported into Viewpoint Imported records with duplicate invoice numbers invoice number already exists for a vendor will be rejected by Viewpoint Textura Viewpoint Integration Manual 5 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management COMPLIANCE DOCUMENTS Insurance effective dates expiration dates and policy numbers for Auto Insurance General Liability Insurance Umbrella Insurance and Worker s Compensation Insurance may be exported from Viewpoint to Textura During the export priority for the source of insurance information can be selected from the following choices Information Retrieved from Latest expiration date The date for each type of insurance on the commitment subcontract record will be compared to the date on the vendor record Information from the record with the latest date per type of insurance will be exported Commitment subcontract record The information will be taken from the commitment subcontract record if the information is available otherwise it will be taken from the vendor record if it is available Vendor record The information will be taken from the vendor record if it is available otherwise it is taken from the s
27. e Importld 3 Click Upload Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 99 Pa Textura Construction Payment Management The system will notify you that the upload was successful IM Ea i Upload successful 4 Click OK The system displays the IM Batch ID screen which displays the AP Transaction batch number created MI 2 IM Batchid Detail ila Es File Edit Records View Options Windows Help z ac 7 j A B i g A LL i zr k e Grid La ees 2 By Import ID Batch ID Date Created Record Count Record 0 of 0 A Grid Cod z Make note of the batch number Proceed to the AP Transaction Entry and process the batch under your normal batch processing procedures Textura Viewpoint Integration Manual 56 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management EXPORT AND IMPORT LEGAL DOCUMENTS AND REQUIREMENTS INSURANCE EXPIRATION DATES INTRODUCTION Subcontracts and subcontract change orders may be entered in Viewpoint 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 Viewpoint will export only approved change orders Duplicate
28. e Invoice File The system displays the Invoice Report page Pa Textura Construction Payment Management Export Date 03 10 2008 2 20 PM Invoice Report Prairie LIMestates 03001 General Construction 1 09 13 08 Target Viewpoint pemioes CSV File Log Out Carrie Durkee Heiberg Developers Vendor Name Subsurface Construction Vendor Number 6240 Project Number 03001 Humber of Invoices For Vendor Draw Number 4 Invoice Humber Invoice Date Invoice Amount 1 0310 2008 20 117 00 Vendor SubTotal 20 117 00 Vendor Hame sub 1 Vendor Humber 3735 Project Humber 03001 Humber of Invoices For Vendor Draw Humber 1 Invoice Humber Invoice Date Invoice Amount 1 0310 2008 28 505 00 Vendor SubTotal 23 505 00 Vendor Hame sub 2 Vendor Number 5857 Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 33 Pa Textura Construction Payment Management 5 Click the Download CSV File button 6 Click Save to Disk and then OK Opening invoice 154 627277 csv E ou hawe chosen to open ENI invoice 1547 6222 c5Y which is a Microsoft Office Excel Comma Separated Values File From http fenvi texturallc net What should Firefox do with this File Do this automatically For Files like this From now on The invoice file must be saved to a folder on the Viewpoint server for it to import properly Textura Viewpoint Integration Manual
29. e type for the subcontractor the status is set to Not Received e lf there is an existing record for the insurance type for the subcontractor that has a status of Not Applicable the status will remain at Not Applicable e If information is supplied for a particular insurance type for a subcontractor the status is set to Received e The first time a project is included in the import file Textura will automatically add the compliance document requirements exported out of Viewpoint 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 ll Importing Legal Documents and Requirements To import Legal Documents and Requirements into Textura e 1 From the Project Home Page click the Interfaces menu and select Import Accounting Information Interfaces Im Pi Accounting Information Manage Exports The system displays the Import Accounting Information page e 2 Click the Legal Documents and Requirements radio button e 3 Click Browse to locate the CSV file you want to import Textura Viewpoint Integration Manual 61 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management s 6 3 Viewpoint Import Accounting Information ae o Viewpoint gt gt Eg Textura o Construction Payment Management Source Viewpoint V2 File to import Brow
30. eived v 02 07 08 Received v ERUO006009 03 16 02 03 18 03 Received v D0200224862 10 01 02 10 01 03 Log Out 4 When finished return to your Project Home Page Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Selected 65
31. ent CE dfinterfaces2 texturallc net Remote Desktop Connection M3 YA Report Security for Project Management Company File Edit Options Tools Windows Help Select Company 3 Project Management Comp C User O C Across All Companies Access Level Allowed None Denied gt Initialize tex _ Report 1D Security Group Description Access Type gt Refresh H Apply a Cancel JC Textura Change Order Export JC Textura Change Order Export JC Textura Change Order Export JC Textura Change Order Export JC Textura Change Order Export JC Textura Change Order Export JC Textura Change Order Export JC Textura Change Order Export SL Textura Subcontract Compliance Export SL Textura Subcontract Compliance Export SL Textura Subcontract Compliance Export SL Textura Subcontract Compliance Export SL Textura Subcontract Compliance Export SL Textura Subcontract Compliance Export SL Textura Subcontract Compliance Export SL Textura Subcontract Compliance Export SL Textura Subcontract Export SL Textura Subcontract Export SL Textura Subcontract Export SL Textura Subcontract Export SL Textura Subcontract Export SL Textura Subcontract Export SL Textura Subcontract Export SL Textura Subcontract Export 4 start EY 3 Main Menu for Project 17 3 YA Report Security 300 Report Security Administrator 310 Project Manager Reports 330 Accounts Payable Reports 340 Payroll Reports 350 My
32. er and then click on the IM Import icon Textura Viewpoint Integration Manual 35 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the IM Import screen A Construction Company OF ES File Edit Options Tools Windows Help 7 mm T E ImportID Textura Template lap Inv Txt AP Textura Subcontract Invoice Import File ay Browse ey Execute Import Results Enter the text File to import Coe 2 3 Type AP Inv Txt in the Template field 4 Type Textura in the ImportID field 5 Click Browse to locate the import file The ImportID is just a label that is given to the invoice detail that is going to be imported Any name can be used The same ImportID can be used over and over again The program will display a warning ImportID currently exists for this template Overwrite existing import data Always answer YES The system displays the Open dialog box Textura Viewpoint Integration Manual 36 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management Please choose a file to import Ei E4 Look in G Viewpoint Transfer a y ful E invoices 1000 csv Te involces 10 3 c5w My Recent invoices 10235plib csv Documents payl csw pay cs pav1023 1 c5w Desktop pay1023 2 csv pay1023 split cs gt SL Textura Subcontract Compliance Export Ext SL Textura Subcontract Export Est My D
33. h the name Payment Draw csv File Download x Do you want to open or save this file eh Name payment 1748 3940 csv Type Microsoft Office Excel Comma Separated Values File From waww5 texturallc com Open Save i While files from the Internet can be useful some files can potentially Q harm your computer If you do not trust the source do not open or save this file Whats the risk Warning Ensure that the existing file named Payment Draw has been processed prior to overwriting with manual file If manual file is saved it will overwrite any automatically produced file waiting for import 48 Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management To view the audit report by clicking on the link in the audit report column B punu a gt A Textu Fa Payment Report a abia gt Coriirucis Pipi Basket TED Ba Pat PE 104 201 H aa Let Cr a ae z Target JO Edwards Enterprise 1 A a AA A PA Wed rr a A Be E r A e Y ereber Pie 194 8008 27 fF AA area are hrd rl e ap a Preis Pr E Made el Prieta Pos Suen ida e Ge e e LE Fiel reira Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management IMPORT TEXTURA PAYMENTS INTO VIEWPOINT To alleviate the need to re payments in Viewpoint a file containing the subcontractor payment information f
34. ialog box E Construction Company OF ES File Edit Options Tools Windows Help PAT Importld Template AP Inv Txt AP Textura Subcontract Invoice Import Formi APENEry Description AF Transaction Entry Enter the Import ID of the File to upload Coe 2 2 Type Textura in the Importld 3 Click Upload Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 40 Pa Textura Construction Payment Management The system will notify you that the upload was successful IM Ea i Upload successful 4 Click OK The system displays the IM Batch ID screen which displays the AP Transaction batch number created AN 2 IM Batchid Detail Al ES File Edit Records View Options Tools Windows Help p a ae i i i Bn ABG Li OO E Mr i ge ds E Es Grid 2 4P Entry 01111 3 8 11 Record 1 of 1 Y arid Cor 2 Make note of the batch number Proceed to the AP Transaction Entry and process the batch under your normal batch processing procedures Textura Viewpoint Integration Manual 41 8 30 2011 10 50 00 AM Textura Confidential a Textura Construction Payment Management TROUBLESHOOTING IMPORT ERRORS This section addresses possible errors you may encounter during the upload with the message referencing an invalid field and how to fix the error This is usually caused by an invalid subcontract code or invalid subcontract item The subcontract set
35. n Interfaces ff Im au Accounting Information Manage Exports The system displays the Import Accounting Information page Home Toy Out Textu ra Import Accounting Information avapor Construction Payment Management Source Viewpoint V2 File to Import Browse Dion i internet a ORK Textura Viewpoint Integration Manual 16 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management 3 Click Browse to locate the CSV file you want to import 4 Click Import CSV File The system displays the Import Accounting Information screen with the results of the import Home Log Out Eg Textura oe enon Viewpoint Construction Payment Management Your import has been submitted for processing import tracking number is 1232 To view the status of your import click here To process another import click here Done rrene 100 Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 17 Pa Textura Construction Payment Management To view the Subcontracts added to the project 1 Click the SoV Subcontracts menu on the Project Home Page and select Subcontract List acts Erem E Create Subcontract Setup Invoice Co Assign I view Schedule of Value The system displays the Subcontract Listing page with the subcontracts Subcontracts will be imported as incomplete if the Vendor ID has not been assigned to a project previously and the GC s
36. ncncnnnnononnnnocononononononononononononnnrrnnrnonnnnnnnnrnnnrnnnrnnarenanons 35 Uploading Invoices In WIC WO ONAN oasis noia 39 Troubleshooting IMpori EnO escote 42 Sample OF Created Manacor NNN 42 DUDGOMUTACLOR Pa MEN Susini Ea EO E E EEEa 45 ginge elt E e a P A o E EENEN AT 45 9 2 Export Subcontractor Payments essre R 45 Import Textura Payments into Viewpoint sssssssessessrssrsrrsessersesssessessessesseesessessesresrrsseeseeseeseesersresreseeseese 50 Uploading Payments in VIEW DOIN avalan 54 Export and Import Legal Documents and Requirements Insurance Expiration Dates 57 MUOU O E E A E 57 Export SUDCONEPACTS from VIEW DOING armarse eii idad 57 Import Legal Documents and Requirements into Textura ccoccoccconconccoononccnacenaronnenaronnnnanonnos 61 OOR APP E T E E A E Error Bookmark not defined Textura Viewpoint Integration Manual 3 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management OVERVIEW DESCRIPTION This manual is a guide for setting up the interface between Textura and Viewpoint and processing the related workflow in Viewpoint It is not intended to be a complete guide for Viewpoint For more information regarding Viewpoint see the Viewpoint documentation TEXTURA VIEWPOINT WORKFLOW Integrate Textura s services with Viewpoint to optimize your payment process The most common interface points are Subcontracts Export subcontracts and associate
37. nd 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 Viewpoint will export only approved change orders Duplicates will be rejected in Textura EXPORT SUBCONTRACTS FROM VIEWPOINT EXPORT THE SL TEXTURA SUBCONTRACTS EXPORT REPORT 1 FROM EITHER THE RP OR SL MENU OPEN THE TEXTURASLEXPORT RPT 2 From the Print Report dialog box click the Export button MN 1051 SL Textura Subcontract Export Launcher al ES File Help SL Textura Subcontract Export Inputs Report Info Motes Company a Beginning Job Ending Job D Preview 45 Export amp Cancel Coe 2 Textura Viewpoint Integration Manual 13 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the Export dialog box M2 RP Report Export Options Al ES Title SL Textura Subcontract Export Export Type Text bet Characters per inch 20 Recommended value between 8 and 16 Lines per page ol 0 Do not paginate P Email a Open in Application Hg Save ES Cancel Coe 2 O Donok paginate 3 Select Text TXT from the Export Type drop down menu The system defaults the Destination to Disk
38. nt Management Your aporta hive been submitted for processing Expert tracking numbers are as follows please record these for future reference Payment 1234 Invo les 1233 To view the status af your export click ha The system will display a status page where you can click to view the status of the files being generated Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential E Log Out 6 3 Viewpainl A Wikre dine os m T aw a Hele 5 Pa Textura Construction Payment Management J Homa Dep Out a 6 3 View paint a a View Exports ihe i iewpoind A p p a Eg Textura Construchi n Payment Hanag ment Showing AI Esports with a All a T ina eltdi mails eter daia by aaa records per page trons DE Feb 2011 to 00 44 2001 Piller Potion Project Nanm Backing Memi o Gene iid Ry Espo0d Date Expod Type latas Export Fite Avaitable Ada Report Wsp 15 igre Agil Aeir Craw mbi Export Fil Expo Fly 1734 Project Aumente Multiple Multiple Multiple 2001 02 08 1208 18 Export Fike doble 2011 03 08 17 00 10 kraji 6 7 Wespolni Doa 2 Once on the View exports page you can export the file by right clicking on the link in the export file column When prompted click the Save button to save the payments file Navigate to the appropriate folder and save the file wit
39. ocuments My Computer N bio Network File name Places Files of type Text Files tet ase cay aha tty Cancel 2 6 Locate and select the Textura import file and then click Open The system inserts the file name in the Import File field Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management Hm Import Test Company Miel x Template aP Testura SL AF Invoices Import Results Transfering data from text file 5 23 01 PM Transfering data to IM work Edit 5 23 02 PM 2 records created in IM Work Edit 5 23 02 PM Formatting data 5 23 02 PM Appling defaults 5 23 02 PM Applying cross references amp 23 02 PM Applying template defaults 5 23 02 PM Appling user routine 23 02 PM Updating IM Work Header table 5 23 02 PM Transterring data to IM Work Edit 5 23 02 PM 2 records created in IM Work Edit 5 23 02 PM Formatting data 5 23 02 PM Appling defaults 5 23 02 PM Appling cross references 5 23 02 PM Applying template defaults 5 23 02 PM Applying user routine 5 23 02 PM Updating IM Work Header table 5 23 02 PM Import to IMME complete 5 23 02 PM 7 Click Execute The system displays the Import Results on the IM Import screen The program is done importing when a dashed line displays at the bottom of the display information see screen above Textura Viewpoint Integration Manual 8
40. ontract change order that already exists in Textura Textura will reject the record as a duplicate To Import Subcontractor Contract Change Orders follow steps 1 4 listed above under Import Subcontracts title The Subcontractor will need to allocate the Change Order s There is no further action for the general contractor To view The Subcontractor Contract Change orders return to the project home page and click on Show Subcontract Change Orders link mu a sane Cartie Durkee Heiberg Developers Construction Payment Management Log Out Draw Interfaces SoY Subcontracts Change Orders Project Setup Reports Compliance Project Summary Project Actions nread Messages Show project summary Prime Contract Change Order pcontract Change Orders sc Show Prime Contract Change Orders 0005 Pending Draws a None Draw 1 2 15 2008 2 13 2008 Textura Viewpoint Integration Manual 23 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management EXPORT AND IMPORT OWNER PRIME CONTRACT CHANGE ORDERS INTRODUCTION You may enter owner change orders in Viewpoint and then export to Textura Only approved change orders may be exported EXPORT OWNER PRIME CONTRACT CHANGE ORDERS FROM VIEWPOINT Export the JC Textura Owner Change Orders Export Report 1 From either the JC or RP menu open the TexturaOCOExport rpt file 2 From the Print Report dialog box click the
41. or a draw is imported into Viewpoint 1 Transfer the Textura import file to the Viewpoint Server M 2 Main Menu for ista Construction Company File Folders Items Mier Options Links Windows Help 3 ali 2 E 40 Lal t 2 Vista Constructio Vista Construction VIEWPOINT Company n Company Menu Ma Viewpoint Folders Items in Imports Programs LI Vista Constructie Cd My Tasks 3 IM Batch Id 1 24 2011 9 00 48 AM 2 Accounts Payak n IM Cross Reference 1 11 2011 10 17 39 EI Programs A a fe f20d1 10 33 14 aM 7 C3 Reports l IM Import Purge 124 2011 8 49 14 AM LJ Accounts Recei 19 Template 1 24 2011 8 49 02 AM L4 Cash Manageme 21M Upload 1f24f2011 10 17 13 LI Document Man l tee EJ Equipment Man m York Edit 12492011 9 01 34 AM Cd General Ledger CA Headquarters CA Human Resourc CA Imports LF Programs CA Reports CA Inventory GI Job Billing CA Job Cost CA Material Sales A Payroll CA Project Manage CA Purchase Order Cd Reports CA Programs e This is a Programs Folder View Details Sort Title 3 YPSample la class1 Cot 2 O E HHA Hee OEA 2 From Viewpoint s Main Menu click the Imports folder click the Processing folder and then click on the IM Import icon The system displays the IM Import screen Textura Viewpoint Integration Manual 50 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management M2 IM Import for ista
42. our Accounting Package in TeXtura ccccceseseeeseeeeeeeeeeeeeeeeeaeeeeaeeeeeeseaseaeaeaeaeeaeaeens 11 Setting up your Accounting Package ceeccccsssecccceseccceeesecccsesececceseeecsuseceeeneceeseueneeessusecesseneceesegecetsugesss 11 Export and Import Subcontracts and Subcontractor Change OrdeFS concccncccnnccocinnccnnconaconanos 13 OOU EOI APP e E E T pancieee aitsaecaoannonesaneasiennerscd 13 Export Subcontracts from Viewpoint ssssessesesseesssreresrressreressrrerssreresrresssrereseressrereessrerssetreserereseeresreesseerene 13 Import Subcontracts into Textura ccccceecccccceseccccesecccaessececsesecceeeeeccecsesececeecseeeeneceeseuseceseuneceeseuceeeeseneeeten 16 Import Subcontractor Change Orders ccccccssscccceesececceecccceuesececcusececeeecceceuseceeeseeceeeeeecceseeeceseueceeeueeeetas 23 Export and Import Owner Prime Contract Change Orders c ccccesseesseseeeeeeseeeseeeeeeeeeneeseenenes 24 MOU EVO A E AS 24 Export Owner Prime Contract Change Orders from Vi WDPOINt cccccccccccccceeeeeeeeeeeeeececeeeeeeeeeeeeeeeeeeeeees 24 Import Owner Prime Contract Change Orders into Textura ccoooonononnnnncncnononnnnnnnnnnononanonnnananacononacacananonoss 27 Export Subcontractor Invoices from TexXtUlA coooncconnccconnccocncconaccnonnncnnnnnnnnnncnnnnrnnnnrrnanrrnnannenannnos 32 o o e e e O Pe 32 EXPO INVOICes MOM TOKU A seno it 32 Import Textura INVOICES into ViewpOlNt oocccocccncncoc
43. rita Unit Cost ECH Supplier Pay Type Test SL Load fas 03530 00 En oof oof po Gross Freight Mise Inc Tax Type Tax Code Tax Basis Tax Amt Retz Retanage Dic Discount 1 000 00 0 00 IN 0 00 0 00 10 00 100 00 0 00 0 00 gt gt Gross 1 0000 Freight _ 0 00 Sates Taw 0 00 D E SS TNS TS E E 7 SL Test SL Load LS maT 0 00 H 0 00 100 00 g T 1 000 00 pad 4 Po ped First Record View Co 99 4 The following screen was created from the last two records in the sample import file Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management ar Transaction Entry File Edit Records Options Window Help Test Company Miil Ei Month A Batch ez seqH E Header Payment Info Address Override amp 1099 Info O Notes Memos Action SP Trans Wendor AF Reference Description Invoice Date Disc Date a Due Date i 004 fi 004 012 Test SL Load ora 5 04 osa 4 04 500 0 Invoice Total Wendor Lottzakrakza Concrete Addresa JP O Box 123 Chandler AZ 12347 Line ji Line Other Info O Notes Memos Action Type ltemH JC Co Job Phase a 7 sL 04102501 CT JE Uh as inoz y TE 2 Description GL Cot GL Account Units Unit Cost ECM Supplier Pay Type Test SL Load EF oz530 p E 0 000 0 00000 1 Gross Freight Misc Inc Tax Type Tax Code Tax Basis Tax Amt Retz i 500 00 0 00 N
44. s will be rejected in Textura EXPORT SUBCONTRACTS FROM VIEWPOINT Export the SL Textura Subcontracts Export Report 1 From either the RP or SL menu open the TexturaSLExport rpt 2 From the Print Report dialog box click the Export button M 1060 SL Textura Subcontract Compliance Export Launcher File Help Fo SL Textura Subcontract Compliance Export Inputs Report Info Motes Company 3 Beginning Job Ending Job Preview Print 5 45 Export E Cancel Coe 2 Textura Viewpoint Integration Manual 57 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management The system displays the Export dialog box M2 RP Report Export Options O x Title SL Textura Subcontract Compliance Export Export Type Text Ext Characters per inch 20 Recommended value between 8 and 16 Lines per page ol 0 Do nok paginate 5 Email a Open in Application LJ Save ES Cancel 0 Donat paginate Cow z Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 58 Pa Textura Construction Payment Management MN 2 RP Report Export Options Mal ES Title SL Textura Subcontract Export Export Type Text tect Characters per inch 20 Recommended value between 8 and 16 Lines per page ol 0 Do nok paginate A Email a Open in Application LJ Save E Cancel 0 Donat paginate Cow z
45. se L import CSV Filo e 4 Click Import CSV File The system displays the Status page notifying you that legal documents and requirements have been imported Fa Textura Status T gt Construction Payment Management Your import has been submitted for processing import tracking number is 1232 To view the status of your import click here To process another import click here Dore To verify legal documents were imported Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential 62 Pa Textura Construction Payment Management e 1 Fromthe Project Home Page click the Compliance menu and select View Document Status Compliance B Edit Document Status View Document Status Setup Document Requirements View Lien Waiver Status Log Out Fa Textura View Document Status _ General Contractor Construction Payment Management ll School 0514 Expres within Expired 031 400 2006 E fiot Compiiant asue sx a aa a ed rr AAA I at Dates shows are expration dates Migarizato meconplarce of Yeso document requires wil cromado e payers Mhi Ax all open crews Manual Subs Pending Payments Suppliers Subcor actor Supplier Due on Site Actlon on Hold Subsurface Construction e 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
46. stem displays the Edit Schedule of Values page Pa Textura Construction Payment Management Carrie Durkee Heiberg Developers Edit Schedt t Prairie Lake Estateeee Revertto Saved Reallocating for Draw 10 Not yet initiated General Construction Add New Line Copy Selected Delete Selected Chg Orders Total Adjusted Value Paid to Date Balance Due Billed to Date Balance to Complete C O 10 Additional freezer Contract Sum Subcontract Paid To Date Amount To Date Het Change by C O Phase Cade Balance Due Description 100 Excavating 200 Concrete 300 Sewer 400 Plumbing 500 Landscaping 600 Electric 700 General Conditio Working Totals Totals Browse Upload Newfrom CSV Download Example CSV File rele3se 2 0 2 110221 150 000 00 200 000 00 225 000 00 150 000 00 100 000 00 100 000 00 75 000 00 1 000 000 00 1 000 000 00 0 00 0 00 0 00 0 00 0 00 10 000 00 0 00 10 000 00 141 195 00 150 000 00 200 000 00 225 000 00 150 000 00 100 000 00 110 000 00 75 000 00 1 010 000 00 1 141 195 00 150 000 00 200 000 00 0 00 150 000 00 100 000 00 220 000 00 0 00 820 000 00 820 000 00 38 700 00 98 122 50 0 00 40 500 00 0 00 0 00 0 00 177 322 50 177 322 50 111 300 00 101 877 50 225 000 00 109 500 00 100 000 00 110 000 00 75 000 00 832 677 50 963 872 50 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 96 500 00
47. tion Code Code Subjob item Budget Amount Paid To Date To Date Balance Due HVAC 1 5 728 00 5 728 00 0 00 0 00 5 728 00 Totals 5 728 00 5 728 00 a y 5 723 00 Note The Subcontract Item is fed from Viewpoint on import NEVER manually adjust the item number The system displays the Contract Maintenance Page 3 Type in the Subcontractor s Company Name next to Organization click the Find button 4 Select the proper organization name and the grey box above will auto populate Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential a Textura Construction Payment Management 0715800 save Changes Revertto Saved Reallocating for Draw 1 Not yet initiated Hide Settings This is an accounting vendor ID and is stored automatically This may be Contract 07015800 Organization used for reference to assign an org in Contract Amount 5 728 00 Detault Payment Farm Description HA O i Default Retention Controlled Mo Open Book Subcontract Contract 10 01 02 sub SOW Option Date Create Paired Lise Specified Billing Lines by Phase Code Signatory approval 7 Advance Billing of invoices Contract is not Complete Subcontractor cannot modify retention Bonding Institution Note You will only need to assign a subcontractor for a particular Vendor ID once Textura will store the association between the Vendor ID and the subcontractor 6
48. tura the Edit Organization link is displayed on the main home page Click this link The system displays the Edit Organization page Add Secondary Organization Business Information Company Name Country Address Line 1 Address Line 2 City State Zip Code County Phone Alternate Phone Fax Mobile Default Currency General Contractor United States of merica Y 13 Mulberry St Chicago Illinois 60657 cook 312 333 4567 USD Tax ID Organization Type Organization Role 111 11 1111 Corporation Accounting Package Document Imaging System Verify the correct accounting package is selected ViewlEdit Secondary Organization Bank Information 001915 110610000528 Bank Name Bank City Bank State Select State v Bank Account Name Routing Number or SWIFT Code CONCERNING ACH ROUTING NUMBERS Routing numbers often differ from 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 numbers which begin with the digit 5 are not used in the ACH system 123456780 Stored account Bank Account Re enter Bank Account on file ending in 1111
49. ubcontract record 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 Viewpoint Each day one user will need to complete the posting process into Viewpoint Payments made to subcontractors with Textura managed subcontracts via manual check will be handled in the same way they are handled today within Viewpoint Textura Viewpoint Integration Manual 8 30 2011 10 50 00 AM Textura Confidential Pa Textura Construction Payment Management TEXTURA VIEWPOINT INITIAL INTERFACE SETUP INTRODUCTION Before using Textura with Viewpoint there are initial setup procedures and considerations These include verifying or changing settings previously selected in Viewpoint and adding custom reports to the Viewpoint menu This section will explain how these settings control the outcome of the interface and where appropriate will make recommendations for ease of processing SETTING UP YOUR VIEWPOINT TO TEXTURA EXPORTS ASSIGNING REPORT SECURITY 1 In Viewpoint click the Viewpoint Administration Folder 2 Click the Program folder 3 Click the VA Report Security icon C dfinterfaces2 texturallc net Remote Desktop Connection v 3 Main Menu for Project Management Company Fie Folders Items view
50. up in Viewpoint is used to automatically assign mission critical field information such as job phase GL company and GL code If there is an invalid subcontract code or an invalid item for a subcontract then mission critical data is not updated during the import Options to correct the problem include The problem needs to be identified The client can go into the Viewpoint IM Work Edit Form and cycle through the information The problem will usually be in the APLB record and the problem sequence number will have no job code phase code GL company or GL expense account code Once the problem sequence number has been identified the client needs to verify if the problem is due to an invalid subcontract code or invalid subcontract item number Preferred Correction Method Correct the information in Textura and recreate the export file Alternative Correction Method Adjust the Viewpoint import file This may be difficult since the information is somewhat cryptic and the file is exported in a csv format when in reality the file is really a text file Sometimes a client can correct the csv file directly and in doing so take the file out of sync and cause additional erroneous errors A safer way to have the client correct the file is to have them change the extension to a txt file and then make the correction in WordPad The client will still need to make the necessary changes in Textura to prevent errors in future exports SAMPLE OF CREATED

Textura Viewpoint Integration Manual

Contents

Download Pdf Manuals

Related Search

Related Contents