================================================================= VISUAL CONTRACCT README.TXT Updated 11/17/2017 kja ================================================================= Job Cost Inc. 208 N Washington Street Naperville, IL 60540-4514 Phone (630)355-8188 Fax (630)355-8675 website http://www.jobcost.com email software@jobcost.com ================================================================= HARDWARE RECOMMENDATIONS: ================================================================= SERVER Operating System: Microsoft Windows 2008 or newer WORKSTATION Operating Systems: Windows 10 Pro (Windows 10 Home is NOT recommended) Windows 8 or 8.1 Pro or Enterprise Windows 7 Professional or Ultimate 32-bit or 64-bit Processor: Intel i3 or greater Memory: 2 GB or greater Windows Version 64-bit server or workstation, see "(64-bit)". ================================================================= CONNECTION INFORMATION: All Servers (that store Visual ContrAcct) and all workstations that run Visual ContrAcct: Should be running at a 1 Gigabit (1,000 Mb/s) connection speed or better. No servers or workstations (running Visual ContrAcct) should be running at 10/100 Mb/s. All workstations (running Visual ContrAcct) should be plugged directly into a Gigabit switch NO WORKSTATIONS (RUNNING VISUAL CONTRACCT) SHOULD BE PLUGGED INTO AN IP PHONE. ================================================================= POWER OPTIONS/SETTINGS FOR WORKSTATIONS AND SERVERS ALL servers and workstations should have the Power Options/Plan set to High performance In addition, the plan settings should be set for the following: Put the computer to sleep: NEVER Hard disk – Turn off hard disk after: NEVER Adapter Settings – Power Saving Mode: Maximum Performance Sleep – Sleep after: NEVER Sleep – Allow hybrid sleep: OFF Sleep – Hibernate after: NEVER Power buttons and lid – Sleep button action: DO NOTHING ================================================================= ANTI-VIRUS SOFTWARE (SERVER/EACH WORKSTATION) Scanning Visual ContrAcct can cause damaged files, slowness, locking problems and erroneous errors when running Visual ContrAcct. Anti-Virus must be set to EXCLUDE Visual ContrAcct database files ...\cscwin and all subfolders at the server AND each workstation. SCANNING RECOMMENDATIONS Visual ContrAcct Multi User – Server/ Peer-to-Peer Run Anti-Virus on the file server scan all files EXCEPT Visual ContrAcct and all subfolders example: \CSCWIN, \cscwin\data1, \cscwin\democompany Run Anti-Virus on the workstations Scan every file on the workstation. Do not scan network drives - the server Anti-Virus will handle these files. Visual ContrAcct Single User Run Anti-Virus Scan all files EXCEPT Visual ContrAcct and all subfolders example: \CSCWIN, \cscwin\data1, \cscwin\democompany We recommend you manually scan Visual ContrAcct when software is NOT in use. ================================================================= VISUAL CONTRACCT BACKUPS DO NOT BACKUP VISUAL CONTRACCT WHILE PROGRAM IS IN USE. Visual ContrAcct database files are constantly changing. Backing up data files in use can cause damaged files, slowness, locking problems and erroneous errors when running Visual ContrAcct. Visual ContrAcct programs and data are located in ...\cscwin and subfolders. We recommend scheduled backups when all users are out of Visual ContrAcct. CONTINUOUS BACKUPS can NOT be run on Visual ContrAcct when software is in use. ================================================================= VISUAL CONTRACCT OFFLINE FILES DO NOT SYNC OFFLINE FILES. We recommend you DISABLE offline files. Control Panel > Sync Center > Manage offline files - Disable Offline files Offline file syncing can utilize system resources that are needed for Visual ContrAcct. ================================================================= VISUAL CONTRACCT WORKSTATION SETUP - WKSETUP.EXE Run WKSetup.exe at each workstation needing access to Visual ContrAcct. WKSetup.exe will do the following: * Install system files on your local computer(.dll's). * Give you the option to install an ODBC connection if Crystal Reports or Crystal Report Viewer will be used with Visual ContrAcct * Create an ICON on your desktop - which may require modifications outlined below * Create option under Start > Programs - Visual ContrAcct - which may require modification as outline below WKSETUP.EXE INSTALLATION You must know the location of Visual ContrAcct to run wksetup.exe. Visual ContrAcct will be located in a folder called cscwin. Example: \\2k8server1\cscapps\cscwin Wksetup.exe and Wksetup.ini are normally located in \cscwin\install. Verify Wksetup.ini contains correct UNC path of cscwin folder. Example: [Setup] MainDir= \\2k8server1\cscapps\cscwin If Visual ContrAcct is located on a server, the workstation must be networked and logged onto the network. Start Run Browse Find the cscwin folder Double click on ...\cscwin\install\wksetup.exe Run Next Take default directory (Next) Do you want to install Visual Contracct ODBC Yes if this is a new workstation that will be running Crystal Reports Note if you say yes it will overwrite the existing Visual Contracct ODBC No if this workstation will not be running Crystal or the ODBC already exists. IF No Next Finish IF Yes Next Under path Browse to your data directory and click on csc.dbc OK Finish A new Icon "Visual ContrAcct" will appear on your desk top and a new option will be added to Start > Programs - Visual ContrAcct. We suggest you delete one or the other to avoid having to maintain both. Most customers prefer to run the Icon from the desktop. To set Visual ContrAcct to point to the correct data: Right click on Visual ContrAcct Icon Click on Properties Add i={company name}.INI to the end of Target Example of settings: Target: \\2k8server1\cscapps\cscwin\csc.exe i=demo.ini Start in: \\2k8server1\cscapps\cscwin Verify VC Login Works Verify VC Help Works - troubleshoot in "help does not work" section Verify VC Reports > AR > Agings/Statements > Customer Totals - display to screen. Verify VC Reports > AR > Agings/Statements > Statements - Crystal Reports - display to screen. IF YOU RECEIVE ERRORS RUNNING WKSETUP, see troubleshoot section "ERROR RUNNING WKSETUP.EXE" It contains information on: * administrative rights * UAC * mapped drive in wksetup.ini WKSETUP.EXE ERROR - "The file 'C;\Windows\HH.exe' could not be opened" On Windows 10 workstations, when running WKSETUP.EXE you might get a error message: "The file 'C;\Windows\HH.exe' could not be opened. Please check that your disk is not full and that you have access to the destination directory." Note: This error began occuring on some Windows 10 Computers around 06/30/2017 - reason is unknown. To troubleshoot: Verify user has administrator rights. Verify ..\install\wksetup.exe is dated 03/16/2017 If not, send new wksetup.exe and test. Gather Operating System Information from system Right click on Windows Start Select System Get screen shot of information Gather Operating System Information from DOS PROMPT Right click on Windows Start Select Run Type WINVER Get screen shot to see Version # Delete hh.exe and hhctrl.ocx from C:\Windows Run WKSETUP.exe as an admin and in Compatability Mode. If last two steps do not work, try the following: Then turn on Compatability mode for Windows XP SP3. Right Click on \cscwin\install\wksetup.exe Select Properties Select Compatibility Tab Check “Run this program in compatibility mode for: Select Windows XP (Service Pack 3) ***Note: This may error with message "The Setup routines for the Microsoft Visual FoxPro Driver ODBC Driver could not be loaded due to system error code 126: The specified module could not be found. (C:\WINDOWS\system32\vfpodbc.dll). But it should still work. =================================================================== ODBC CONNECTION FOR CRYSTAL REPORTS & CRYSTAL REPORTS VIEWER Crystal Reports & Crystal Reports Viewer use an ODBC connection. Run \cscwin\misc\vfpodbc.msi to install the Visual Foxpro Database Driver (If it just flashes on the screen, then goes away, it is already installed) OPERATING SYSTEMS: Windows7/Windows8/Windows10 (32-bit) Run c:\windows\system32\odbcad32.exe System DSN (tab) Add Microsoft Visual FoxPro Driver set the database source name = Visual ContrAcct browse to set the path = ...cscwin\yourcompanyname\csc.dbc OK > OK Windows7/Windows8/Windows10 (64-bit) Run c:\windows\syswow64\odbcad32.exe System DSN (tab) Add Microsoft Visual FoxPro Driver set the database source name = Visual ContrAcct browse to set the path = ...cscwin\yourcompanyname\csc.dbc OK > OK ================================================================= VISUAL CONTRACCT LOGIN DEFAULT Visual ContrAcct Login will default based on Login/Profile name. Note: It does not default based on Computer/Workstation name. =================================================================== VISUAL CONTRACCT AUTO RUN DEFAULT *Auto Run Visual ContrAcct Menu Option on Login (Icon properties command line switch) If you would like Visual ContrAcct to automatically default to a specific menu on login: right click on the Visual ContrAcct Icon click properties add M= Example to auto run File > Job Cost > Jobs: F:\cscapps\cscwin\csc.EXE I=csc.INI M=FJJ The F tells Visual ContrAcct to do an Alt F once in Visual ContrAcct. The J tells Visual ContrAcct to select Job Cost. The J tells Visual ContrAcct to select Jobs. =================================================================== VISUAL CONTRACCT PDF EMAIL FEATURES ACCOUNTS PAYABLE ELECTRONIC PAYMENT ACCOUNTS RECEIVABLE INVOICE PAYROLL DIRECT DEPOSIT PAYROLL WEEKLY CERTIFIED REPORTS PURCHASE ORDER EMAIL CLIENT REQUIREMENTS: Microsoft Outlook 2007 32-bit Microsoft Outlook 2010 32-bit Microsoft Outlook 2016 32-bit Not supported: Microsoft Outlook 2007 64-bit Microsoft Outlook 2010 64-bit Microsoft Outlook 2010 32-bit iSEDQuickPDF.dll must exist in \cscwin folder to create a PDF file. It does not get registered. PDF files are created on the workstation local drive-windows temp folder. PDF files do not get deleted once attached. =================================================================== VISUAL CONTRACCT PDF EMAIL ERROR TROUBLESHOOTING =================================================================== * Emails begin to send and receive error: An error has occurred attempting to email direct deposit check stubs. Please contact Job Cost, Inc. customer support. Resolve by checking sent items and drafts to determine last email sent. Verify the last email sent and the next email to send have a valid email address on employee file. * If you receive error: "There is no default mail client." or "The default email client Windows Mail is not supported by Visual ContrAcct." Version <10.36.05 need to programmatically access the Windows registry key: HKEY_LOCAL_MACHINE\Software\Clients\Mail The data value of the (Default) key must be “Microsoft Outlook”. This user might not have permission to access/change registry values. Email Registry Key (run 'regedit') HKEY_LOCAL_MACHINE\Software\Clients\Mail (Default) Value Data must be Microsoft Outlook The changes are inherited by all users. Restart computer. Version > 10.35.04 does not access the registry and always runs Microsoft Outlook Object. * If you receive error: "The current mail client cannot fulfill the messaging request." on a Windows7 Workstation WITH Office 2010 64-bit: Please run Microsoft Outlook and set it as the default mail client. An error has occurred attempting to email direct deposit check stubs. Please contact ContrAcct Systems customer support. Microsoft recommends you remove Office 2010 64-bit and install Office 2010 32-bit. There is a known problem with Microsoft Outlook 64-bit when receiving information from a third party software and trying to attach a pdf using Outlook 2010 64-bit. The AR Invoice email and PO Email work. This only occurs when using the redemption.dll to auto launch emails. Researched on 10/27/2011. * If you receive error: "Unable to start Microsoft Outlook." We determined outlook directory was changed on 06/11/14 by looking at date on outlook directory c:\program filesx86\Microsoft office\office14 Also, an outlook security certificate error existed but error was hidden by outlook after email was sent from vc but if you minimize you can see it. THIS WAS RESOLVED BY IT UNINSTALLING OUTLOOK AND REINSTALLING OUTLOOK.. Note: we found this at a client that had Microsoft Outlook 2010 32 bit June 2014. * If you receive error: "Error: 1426 Message: OLE error code 0x80080005: Server execution failed. Program: USERHASOUTLOOKDEFAULTSIGNATURE Line:3298" E-mail won't create, gives second error of "Unable to start Microsoft Outlook" This is due to something wrong with the users profile on that computer. =================================================================== VISUAL CONTRACCT EMAIL PAYROLL DIRECT DEPOSIT TROUBLESHOOTING (OUTLOOK 2016) =================================================================== Outlook 2016 has an issue with the VC email of Payroll Direct Deposit. If a customer has a problem emailing direct deposit and has Outlook 2016, send them the NEW wksetup.exe (03/31/16 or greater) and run on workstation. When they run the email Payroll Direct Deposit have them make sure that Outlook is open (running). It will send the emails first to draft and slowly move them to sent. If outlook is NOT open , the last email may stay in draft folder. WKSETUP.EXE ERROR WHEN WKSETUP.INI HAS INVALID PATH OR MAPPED DRIVE VERSES UNC Windows cannot find c:\windows\Mcros~1.net\framew_1\v20~1.507\misc\foxhelp'. Make sure you typed the name correctly, and using UNC verses Mapped drive. =================================================================== VISUAL CONTRACCT PDF EMAIL PRINT SIZE & SCREEN DISPLAY TROUBLESHOOTING (MAGNIFY) =================================================================== * Visual ContrAcct Reports (Payroll Precheck/Postcheck Register)Cut Off/Chop Off Data * PDF Emailed Page Size is greater than 8 1/2 X 11 when printed. Version <10.38.00 Resolve by changing Control Panel-Display-Change Display to 100% OR Request a Visual ContrAcct Update to Version 10.38.00 or greater and custom screen display (magnificaiton) can be > 100%. Once updated to Version 10.38.00 or greater, set Visual ContrAcct Admin > Miscellaneou > Users - Custom Display per below: Windows 7/8 32-bit Screen Display > 100% - set Custom Display% = Screen Display% Windows 7/8 64-bit Screen Display between 101% and 125% - set Custom Display% = Screen Display% Windows 7/8 64-bit Screen Display > 125% - set Custom Display% = 100% If a user logs into different computers with different display settings support should have them create multiple VC logins so Custom Display% can be set differently per VC user login. If a user creating email with attached PDF has Custom Display% > 100, printing of the PDF will have smaller font and page spacing. If a user creating email with attached PDF has a default printer driver set to a PDF printer driver(cutepdf)& person who opens the email with attached PDF had adobe print dialog Size Options set to ACTUAL, printing the PDF will chop off top and possably other margins. Resolve by changing default printer driver to a real printer driver so it has default margins and resend .PDF file. =================================================================== VISUAL CONTRACCT TROUBLESHOOTING =================================================================== ERROR RUNNING WKSETUP.EXE ------------------------------------------------------------------- * SECURITY ISSUES WHEN RUNNING WKSETUP.EXE ADMINISTRATOR RIGHTS The workstation must be logged in as a user with administrative rights. If you receive errors running WKSetup the first thing to check is administrative rights. * WKSETUP.EXE ERROR WHEN WKSETUP.INI HAS INVALID PATH OR MAPPED DRIVE VERSES UNC Windows cannot find c:\windows\Mcros~1.net\framew_1\v20~1.507\misc\foxhelp'. Make sure you typed the name correctly, and using UNC verses Mapped drive. * WINDOWS7/WINDOWS8/WINDOWS10 WORKSTATION USER ACCOUNT CONTROL (UAC) If running WKSetup on a Windows7/Windows8/Windows10 workstation you may have to: Disable user account control to allow wksetup to work for foxhelp. Run MSCONFIG from: Start Run Type MSCONFIG in Open Box OK Click on the Tools tab. Click on Change User Account Control Settings. Click Launch Button We recommend setting UAC back to original after WKSETUP.EXE-so document setting. Pull bar down to Never Notify Setting. OK OK Reboot the computer for changes to apply. After WKSETUP is done, repeat above steps to set UAC back to original setting. * WINDOWS7/WINDOWS8/WINDOWS10 WORKSTATION MAPPED DRIVE If \cscwin\install\WKSetup.ini has a mapped drive you will receive an error: Windows cannot find C:\windows\.........\misc\foxhhelp. Make sure you typed the name correctly, and then try again. If running WKSetup on a Windows7/Windows8/Windows10 workstation \cscwin\install\WKSetup.INI file can NOT reference a mapped drive. It must have the UNC and the UNC must match the UNC of the workstation that you are trying to run WKSetup. Some workstations may use the ComputerName (NetBIOS) name of the server (e.g. 2k8server1) to map their network drives or they may use the IP address of the server (e.g. 192.168.252.2) to map their network drives. Example of a UNC: MainDir= \\2k8server1\cscapps\cscwin or MainDir= \\192.168.254.2\cscapps\cscwin Example of Mapped Drive - will NOT work with a Windows7/Windows8/Windows10 workstation: MainDir= R:\cscwin * "path not found" Add the path to the local intranet site. Example: if Visual ContrAcct resides in r:\cscwin, add r:\ to the local intranet site. Open internet explorer Click on tools Go down to internet options and double click on internet options Click on the security tab Click on the local intranet icon Click on the sites button Click on advanced button Type in r:\cscwin in the box under add this website to the zone Click on add Click on close Click on ok Close internet explorer * GLJ189.tmp - Ordinal Not Found. The ordinal 1132 could not be located in the dynamic link library CRPE32.dll If you get the above message, your CRPE32.dll is corrupted. Go to a workstation that works. copy \windows\system32\crpe32.dll from the workstation that works to \windows\system32\crpe32.dll of the workstation that does not work. Register CRPE32.dll - go to Start > Run ; and type in 'regsvr32 crpe32.dll' ; then click Run * The file C:\windows\system32\VFP6R.DLL could not be opened. Please check that your disk is not full and that you have access to the destination directory. Access is denied. You do not have rights to copy a file into \windows\system32. Login as administrator or a user that has administrator rights. * "The application has failed to start because MSVCR71.DLL was not found. Re-installing the application may fix this problem." Go to a workstation that works with the same operationg system: windows 7 windows 8.1 copy \windows\system32\msvcr71.dll from the workstation that works to \windows\system32\msvcr71.dll of the workstation that does not work. ------------------------------------------------------------------- ERROR RUNNING VISUAL CONTRACCT ICON ------------------------------------------------------------------- * User can run Visual ContrAcct but additional users can't run (or it's slow to run - 5 minutes) Visual ContrAcct Icon. Check all workstation: Control Panel > Sync Center to see of OFFLINE FILES is enabled. If so, this could be causing the issue. Check with customers IT before proceeding. If a client has offline files enabled and they wish to turn off, determine if it was on by default and not needed by the customer. Windows uses the folder C:\windows\csc for storing offline versions of network files. When offline files is turned on, you can browse out to network files/folders , right click on an item, and you will see an option to “make available offline”. When you choose that option, the file/folder will be cached to your computer (in the C:\windows\csc folder). If you are turning it off and the customer was NOT using it, no problem. If the customer WAS using it and they still want to turn it off, verify all the offline files are synchronized from the station to the server that it is in sync with. When they are connected, click on the Sync process in the right bottom tray and request a synchronization and make sure it completes successfully. That way any changes that were on the station will be pushed to the server. Check Offline File settings by going into: Control Panel Sync Center Manage offline files If the “Enable offline files” button is present, you will see “Offline Files is currently disabled” below that button. If offline files are enabled, you should disable. You will have to reboot for this to take effect. Note: This was found on a server by analyzing the server process failures. The failures referenced C:\WINDOWS\CSC folder. * Error "Microsoft Visual Foxpro error - Microsoft Visual FoxPro has encountered a problem and needs to close. We are sorry for the inconvenience" The path is broken in the environment path. The environmental path is a windows setting that can be found by: right click on my computer click on properties click on advanced tab (windows7/windows8/windows10 - click on Advanced System Settings) click on environmental variables Look in the system variables section for path and double click to open it up. Make sure that each path statement is separated by a semi colon(;). OR VFP9*.dll's exist in \windows\system32 directory Rename the VFP9*.dll's verses deleting them in case they are being used by another application. We suggest you rename each file so it includes your name. This will leave a trail in the event the renaming of the files cause a problem in another application. * Error "Visual fox pro library not found." Run wksetup.exe. If error continues, you don't have admin rights to the local computer so wksetup could not install necessary files (DLL's). * Error "Visual foxpro cannot start. Could not read local resources." Delete \cscwin\VFP6R.DLL file You should not have ANY .DLL files in \cscwin folder, EXCEPT iSEDQuickPDF.dll. * Message "The publisher could not be verified. Are you sure you want to run this software?" If you get this message you can disable by performing the following: Click on Start/Control Panel/Internet Options. Click on the Security tab then click on the Internet (the world icon). If the Default Level button is NOT greyed out click the Default Level button to set the Internet security back to the default level of Med-High. Then click on the Local intranet (the monitor screen with the world behind it) If the Default Level button is NOT greyed out click the Default Level button to set the Internet security back to the default level of Med-low. Then click on the Sites button. Then click on the Advanced button. Add the drive letter that the station attaches to in order to run visual contracct(f:\ or s:\) then click Add. Then click close. Then click OK and click OK again to get out of the Internet Options. * Microsoft VISUAL FOXPRO ERROR "The resource file is not valid. Overwrite it with a new empty one?" or "Invalid Path or filename". This error occurs if FoxUser.DBF is bad or missing from \cscwin folder. Contact Customer Support for this file. * "Function argument value, type, or count is invalid." This error occurs if you are running an old Visual ContrAcct version on a 64-BIT OPERATING SYSTEM. This error should NOT occur if your Visual ContrAcct version is: between 7.60.31 and 7.99.99 between 8.13.02 and 8.99.99 9.00.00 or greater Contact Customer Support regarding updating to a newer version of Visual ContrAcct. * AVG ANTI-VIRUS (03/07/2008) Error "Windows cannot access the specified device, path or file. You may not have the appropriate permissions to access the item." To resolve, set AVG to NOT scan \cscwin folder or subfolders. --------------------------------------------------------------------- ERROR/ISSUES WITHIN VISUAL CONTRACCT --------------------------------------------------------------------- * Visual ContrAcct slowness issue at a customer on 10/12/15. Customer upgraded from 2003 physical server to virtual 2008 R2 server with a 2012 host running HyperV. They reported the new server was slower than the old server. They were able to determine it was a port on a network switch that was the cause of the slowness. For some reason this port was slowing the software down between the main server switch and the workstations. They did not notice this during the testing phase because they were testing with devices that were on the server side switch. Once they fixed the port on the switch issue, speed is now lighting fast with Visual ContrAcct. * Toolbar disappeared from Visual ContrAcct Visual ContrAcct Version less than 10.39.7: delete C:\windows\csc.ini When you run your VC Icon, it will create a new csc.ini and the toolbar will reappear. Visual ContrAcct Version 10.39.7 or greater (12/5/2014): We renamed toolbar file to VCToolbar.ini. We moved toolbar settings to Windows Temp folder. We default toolbar to dock if VCToolbar.ini is not found. If Toolbar disappears, delete VCToolbar.ini from the workstations windows TEMP directory. * Reports > Job Cost > Detail Ledger hanging or extremely slow We found customers TEMP folder with exactly 1000 files. We deleted them and the report ran properly. See below for finding TEMP folder Temp directory can be found as follows: Log on to the Windows7/Windows8/Windows10 station. Go to your Desktop. Press Windows + R keys simultaneously to initialize the Run command box. In the available field in the Run command box, type %TEMP% and press Enter. Click on VCToolbar.ini Select delet to delete VCToolbar.ini Run Visual ContrAcct Icon and new toolbar should appear. * Visual Contracct Toolbar will not dock on Windows7/Windows8/Windows10 workstation You may need to lower your UAC and then dock the toolbar. *If you search for the VCToolbar.ini and it does not find it in the search, use the following steps. Click on (C:) Drive > Users > Current User's Name > AppData > Local > Temp, then scroll down to find VCToolbar.ini Click on VCToolbar.ini Select delet to delete VCToolbar.ini Run Visual ContrAcct Icon and new toolbar should appear. For instructions on lowering UAC, go to section above under: ERROR RUNNING WKSETUP.EXE WINDOWS7/WINDOWS8/WINDOWS10 WORKSTATION USER ACCOUNT CONTROL (UAC) * Visual Contracct Icon will not pin to the taskbar on Windows7/Windows8/Windows10 workstation We recommend pinning to the taskbar. Go into \cscwin\ folder and right click on csc.exe > copy and paste to desktop. Click and drag the csc.exe icon to the taskbar and pin it Right click on taskbar csc.exe icon > right click Visual ContrAcct > properties Go back to your desktop and right click on your VC Icon that you currently use > properties In the VC Icon properties that you currently use, copy and paste the Target: and Start In: data into the csc.exe properties > apply. Close out on both properties. Verify the VC Icon on the taskbar works. Delete csc.exe icon on desktop. We recommend you delete the original VC Icon from your desktop to avoid confusion. * Error running progress bar. Aging reports use progress bar. AP Select Checks & Print also uses a progress bar. OCX must exist on each workstation. If it does not, you will receive errors when progress bars try to run. Test each workstation by printing an aging. If you receive and error: If Windows 2000 Professional: Copy \cscwin\misc\COMCTL32.OCX to c:\winnt\system32\COMCTL32.OCX Other operating systems: Copy \cscwin\misc\COMCTL32.OCX to c:\windows\system32\COMCTL32.OCX Run the following: Start Run regsvr32 comctl32.ocx Test aging report. * AP Select Checks and AR Enter Receipts gave 'error 1924 LOPROGRESS is not an object' on new windows 10 workstation. Another error was an OLE error that COMCTL32.OCX was not found. Ran wksetup to fix this. * *Visual ContrAcct - Reports > Payroll > Monthly > Union - Crystal Reports Error "This field is not known." Verify the user login has administrative rights. If so, login as administrator, or another user with administrator rights, and test. If other logins work, the login that errors has a BAD profile. We are not sure what is wrong with the profile. To resolve, create a new profile and remove bad profile. * Lookup is in LARGE font causing columns to be cut/chopped off. Resolve by changing Control Panel - Display - DPI setting from Large size (120DPI) to Normal size (96DPI). To change DPI setting: Start Control Panel Display Properties Settings Tab Advanced Button General Tab Change DPS setting to Normal Size (96 DPI) * Terminal Server - Locking Problem File, IN, Transaction Import, [...] locked up DBMaint locked up Register comdlg32.ocx * DELAYED WRITE FAILED Visual ContrAcct intermittently reporting "Delayed write failed" error message. Start Run Regedit Click the enablesecuritysignature value under the following key in the registry: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Lanmanserver\Parameters On the Edit menu, click Modify. In the Value data: box, type 0, and then click OK. Quit Registry Editor. Stop and then restart the server service, or restart the computer. *Peer to Peer environment – “access denied” on remote station find the folder or drive off of which \cscwin\ is located, ie c:\cscapps\cscwin go to properties> sharing and security> security> advanced> permissions> check the following options> inherit from parent the permission entries that apply to child objects. Include these with entries explicitly defined here. Replace permission entries on all child objects with entries shown here that apply to child objects. Click OK – click YES ------------------------------------------------------------------- HELP DOES NOT WORK ------------------------------------------------------------------- The help window will appear but the right side might say: “Action canceled - Internet Explorer was unable to link to the Web page you requested” or “Navigation to the webpage was canceled“ or "Blank" If the workstation has Internet Explorer version 6 then run \cscwin\misc\fix.reg. If the workstation has Internet Explorer version 7 or greater and is 32-bit run \cscwin\misc\ie7fix.reg. If the workstation has Internet Explorer version 7 or greater and is 64-bit run \cscwin\misc\ie7fix64bit.reg. If you are running fix from a network and receive Registry Editor Error "Cannot import r:\cscwin\misc\ie7fix64bit.reg. Error opening the file. There may be a disk or file system error", try copying fix program to the local computer C drive and run locally. You can also try running \cscwin\misc\vchelp.bat You can also try to run a new \cscwin\install\WKSetup.exe If you receive errors running above suggestion, lower the workstations UAC. For instructions on lowering UAC, go to section above under: ERROR RUNNING WKSETUP.EXE WINDOWS7/WINDOWS8/WINDOES10 WORKSTATION USER ACCOUNT CONTROL (UAC) If after running the ie7fix files with the UAC turned off you are getting Navigation to the webpage was canceled. You can try to open file properties and click on Unblock button. Error running Wksetup.exe Error message: Windows cannot find ‘C:\Windows\MICROS~1.NET\FRAMEW~1\V20~1.507\misc\foxhelp’. Make sure you type the name correctly, and then try again. After hitting okay, you will recieve another error message: Could not execute the external program, C:\Windows\MICROS~1.NET\FRAMEW~1\V20~1.507\misc\foxhelp To fix this, go to the cscwin\install folder and open the WKsetup.ini in notepad. Verify the ‘MainDir=’ UNC path of cscwin folder. Example: MainDir= \\2k8server1\cscapps\cscwin Next, compare this line to another ‘MainDir=’ path for a working company .ini file. If the two are different, change the WKsetup.ini ‘MainDir=’ path to the correct path. ------------------------------------------------------------------- VISUAL CONTRACCT PRINTING ISSUES ------------------------------------------------------------------- * Windows7/Windows8/Windows10 (64-bit) If you have an issue with printing, you may need to download a Windows7/Windows8/Windows10 printer drivers for your printer. It is possible an old printer will not offer an updated drivers for Windows7/Windows8/Windows10. If so, we recommend you purchase a Windows7/Windows8/Windows10 compatible printer. * Windows 10 - LET WINDOWS MANAGE MY DEFAULT PRINTER FEATURE Right side of report is cut off (missing) or out of normal alignment. Windows 10 has new feature "Let Windows manager my default printer." When turned on, the default printer is the last used printer. Workstations printing Visual ContrAcct reports should turn OFF feature: Left Click on the start button Click on Settings Under Setting Menu click on Devices Scroll down to almost bottom of page Turn OFF Let Windows manage my default printer. MAKE SURE your default printer is set to Visual ContrAcct default printer. ------------------------------------------------------------------- Visual ContrAcct Error Printing AR Invoice Lien Waiver or Sworn Statement ARLienISN Error: 1705 Message: File access is denied \\2k8server1\cscapps\cscwin\arlienwaiver.txt. Program: FRMARINVOICELIENWAIVER.PRINTLIENWAIVER Line: 140 Date: 07/01/2015 Time: 11:46:34 Company Name: Version: 10.39.21 Login ID: DEMO This error could relate to Windows 8.1 and default printer HP P2035N or Windows 10 operating system. To resolved, update Visual ContrAcct to version 10.40.04 or greater. ------------------------------------------------------------------- VISUAL CONTRACCT CRYSTAL REPORTS & CRYSTAL REPORTS VIEWER TROUBLESHOOTING ------------------------------------------------------------------- * CRYSTAL REPORT OR CRYSTAL REPORT VIEWER ERROR WITH VFPODBC.DLL NOT FOUND Microsoft ODBC Administrator Error The setup routines for the Microsoft Visual FoxPro Driver ODBC driver could not be loaded due to system error code 126: The specified module could not be found. (C:\Windows\system32\vfpodbc.dll). This error generally occurs when trying to run a crystal report after updating to Windows 10. To resolve, copy c:\windows\syswow64\vfpodbc.dll to c:\windows\system32 folder. If vpfodbc.dll does not exist in c:\system\syswow64, you may be able to find the file in \cscwin\misc. Copy and paste vpfodbc.dll into c:\system\system32 folder. If above does not work, run \cscwin\misc\vfpodbc.msi to install the Visual Foxpro Database Driver. If it just flashes on the screen, then goes away, it is already installed. * CRYSTAL REPORT VIEWER - EXPORT TO FORMAT: SEPARATED VALUES (CSV)MISSING EXPORT TO CSV NOT IN DROPDOWN FORMAT Run wksetup.exe dated 03/31/16 or greater on workstation. Restart workstation. *CRYSTAL REPORT VIEWER - EXPORT TO FORMAT: ACROBAT FORMAT (PDF) CREATES ZERO BYTE FILE WITH NO DATA Export to pdf creates a zero byte file due to Microsoft Update KB3102429 released December 8th 2015. This occurred on a Windows 7 Pro Workstation. Option#1 - Uninstall Windows Update Uninstall this update from windows update in order for the export to pdf to work from crystal reports viewer. To uninstall go to: Control panel Windows update View update history Installed updates Find Update for Microsoft Windows (KB3102429) Right click and uninstall Reboot system and try to export to pdf Option#2 – PRINT to a PDF Printer Driver verses CRV EXPORT to PDF Install/use a printer driver that allows creation/save as to a PDF file. PDF Printer Driver - CUTEPDF WRITER Job Cost Inc uses FREE CutePDF Writer. You must install free cutepdf writer at each workstation. Download the free cutepdf writer at www.cutepdf.com, select free download version. Follow prompts on screen to install on your system. You must also download the free PDF Converter. You will be prompted to download it after you have completed the cutepdf download. PDF Printer Driver - ADOBE PDF - May be another option instead of uninstalling the update. =================================================================== PRINT SCREEN DELUXE 6.0 INSTALLATION Note: We do NOT recommend loading Print Screen on a server. Insert the Print Screen CD into the drive. Your system may automatically run setup.exe. Or click Start, Run, Browse, select your cd-rom drive, select Setup.exe, ok, run. Click [setup] Click [install] Click [no] to "Would you like to create icon for Print Screen Deluxe on your desktop?" Click [yes] to "Would you like to start 'Print Screen Deluxe' now?" Click [Options] click "Automatically scroll the window and capture it's entire contents" click "Include the mouse cursor" click "Automatically start Print Screen Deluxe when Windows starts" UNclick "Automatically popup the Print Screen Deluxe Window when you capture a screen" UNclick "Automatically convert the image to a Gray Scale image" UNclick "Automatically 'invert' the colors of the image" UNclick "Use Time Delay" Click [ok] Exit Printscreen completely, even the icon next to the time/date in the bottom-right corner of your desktop. restart Printscreen from Start > All Programs > American Systems > Print Screen Deluxe ================================================================= PRINT SCREEN DELUXE 6.0 - REMOVE FROM WORKSTATION To remove Print Screen Deluxe 6.0 from a workstation Click Start Click Control Panel Click Add or Remove Programs This will open a new window "Currently installed programs" You may receive a message "Please wait while the list is being populated" Once you have the list of programs, find Print Screen Deluxe 6.0. and highlight. Click Remove ================================================================= GADWIN PRINTSCREEN INSTALLATION - FREE PRINTSCREEN PROGRAM To download this free print screen program Go to http://www.gadwin.com/download/ Scroll down to Gadwin PrintScreen Click on the link "Download Now". You can either 'run' or 'save' the files. If you choose to 'save': In the Save As dialog box, select a folder on your hard disk. The file will be copied into this folder. Any folder or hard drive is OK. The name of the folder is shown to the right of the words "Save in:." Write down where you are saving the file so you can find it later. To Install: If you saved the file, run Windows Explorer. Find the file and double-click it(PrintScreen44_Setup.exe) to run it. If you choose 'run' after "Download Now" Select Installer Language It defaults to English Click Next Click 'I agree' Click Install Click Finish ================================================================= Visual ContrAcct Reports - File Export If you select a report to file, you are required to type in a filename or use the ellipse to browse to the directory/filename. Following are the types of files you can create Extension .XLS - Excel file Extension .CSV - Comma Separated Variable We have enhanced the print to file option on all lists (example: vendor list, customer list, employee list) to include all fields in the file. You may see additional fields exported. ================================================================= Job Cost Inc. (630)355-8188 PAYROLL DIRECT DEPOSIT EXPORT FILE (DDyymmdd.TXT): FILE SPECIFICATIONS Format: NACHA File Location: Admin > Miscellaneous > Controls - Data Directory Tab - Payroll Directory Filename: DDyymmdd.txt (yymmdd represents payroll week ending date) ================================================================= Job Cost Inc. (630)355-8188 PAYROLL POSITIVE PAY EXPORT FILE Format: CSV - comma separated variable File Location: Admin > Miscellaneous > Controls - Data Directory Paths - Payroll Directory Filename: PP-PRyymmdd.csv (yymmdd represents file creation date) File contains: RoutingNo cash management bank routing micr for general ledger cash account BankAccountNO cash management bank account# for general ledger cash account CheckNo Date mmddyy Amount 2 decimal - no commas or dollar signs Indicator I=Issued or V=Void Payee Name employee name Sample: 987654321,1203956435, 54363,041413,709.64,I,"Abraham Lincoln" 987654321,1203956435, 54364,041413,229.39,I,"Ronald Reagan" 987654321,1203956435, 54365,041413,629.32,I,"Theodore Roosevelt" 987654321,1203956435, 54366,041413,755.95,I,"George Washington" ================================================================= Job Cost Inc. (630)355-8188 ACCOUNTS PAYABLE POSITIVE PAY EXPORT FILE Format: CSV - comma separated variable File Location: Admin > Miscellaneous > Controls - Data Directory Paths - AP Directory Filename: PP-APyymmdd.csv (yymmdd represents file creation date) File contains: RoutingNo cash management bank routing micr for general ledger cash account BankAccountNO cash management bank account# for general ledger cash account CheckNo Date mmddyy Amount 2 decimal - no commas or dollar signs Indicator I=Issued or V=Void Payee Name vendor name Sample: 123456789,789534124, 1000,042613,15000.00,I,"Concrete, Inc." 123456789,789534124, 1001,042613,2000.00,I,"Dig-It Excavating" 123456789,789534124, 1002,042613,1966.52,I,"Ace Building Materials" 123456789,789534124, 1003,042613,640.95,I,"Vendor for payroll taxes" ================================================================= Job Cost Inc. (630)355-8188 ACCOUNTS PAYABLE ELECTRONIC SPEND PLATFORM (SUNTRUST ESP)E Format: TAB DELMITED with .TXF file extension File Location: Admin > Miscellaneous > Controls - Data Directory Paths - AP Directory Filename: ESPyymmdd-000.txt ESP160405-000.txt(yymmdd represents file creation date) File is Tab Delimited per Specifications of SunTrust Bank. File contains 1 record for each AP Invoice Detail record paid in a check run. The file is created after the check run. File Specifications: PAYABLES Invoice Number Amount Invoice Purchase Order Number Vendor Name Vendor Supplier Number Contact Text – “Contact “ + Admin > Miscellaneous > Users – Employee Name + Company Phone# Check Number Vendor Sub Supplier Number Tax Amount - $ (from check) Discount Amount - $0 (always) Freight Amount - $0 (always) Sample: PAYABLES 1-1 123.00 VENDOR1 1 ESP Card Vendor 1 ESP VENDOR 1 45678901234567890 Contact John Judge 8816085000 SUB456789012345678901234567890 0.00 0.00 0.00 PAYABLES ZERO 60.00 PO ZERO 1 ESP Card Vendor 1 ESP VENDOR 1 45678901234567890 Contact John Judge 8816085000 SUB456789012345678901234567890 0.00 0.00 0.00 ================================================================= Job Cost Inc. (630)355-8188 EQUIPMENT IMPORT FILE (EQUIPS.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Equipment ID (10 alpha) *B Class ID (10 alpha) C Equipment name (40 alpha) D Job cost rate (999999999999.9999) E Job cost UM (10 alpha) F Rental rate (999999999999.9999) G Rental rate UM (10 alpha) H Note (60 alpha) I Purchase from (20 alpha) J Purchase reference(10 alpha) K Purchase condition(10 alpha) L Date purchased M Date sold N Date registered O Purchase cost (999999999999.9999) P Cubic yard capac (999999.99) Q PM interval (1 alpha) R Labor account# (10 alpha) S License# (20 alpha) T Lic expire date U Vehicle sticker# (20 alpha) V Inspection ex date W Empty weight (999999999) X Tire size (10 alpha) Y Year (9999) Z Machine make (20 alpha) AA Machine model (20 alpha) AB Machine serial# (20 alpha) AC Engine make (20 alpha) AD Engine model (20 alpha) AE Engine serial# (20 alpha) ================================================================= Job Cost Inc. (630)355-8188 INVENTORY ITEM IMPORT FILE (INITEM.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Item # (20 alpha) B Bar Code (20 alpha) C Reference# (20 alpha) D Description (60 alpha) E Manufacturerid (10 alpha) F Product Class (10 alpha) G Cost Type (10 alpha) H Expense GL Account(10 alpha) I Location (10 alpha) J Pack Size (10 alpha) K Qty U/M (6 alpha) L Price U/M (6 alpha) M Purchase Price (999999999.99) N Purchase PriceDate O Sales Price (999999999.9999) P Sales Price Date Q Sales Markup% (999999999.99) R Job Price (999999999.9999) S Job Markup% (999999999.99) T Reorder Quantity (999999999.99) U Reorder Level (999999999.99) V Days (999) W Taxable (1 logical) X Make Requisitions (1 logical) Y User Field Date 1 Z User Field Date 2 AA User Field Date 3 AB User Field Date 4 AC User Field Num 1 (9999999999.99) AD User Field Num 2 (9999999999.99) AE User Field Num 3 (9999999999.99) AF User Field Num 4 (9999999999.99) AG User Field Text 1 (100 alpha) AH User Field Text 2 (100 alpha) AI User Field Text 3 (100 alpha) AJ User Field Text 4 (100 alpha) AK User Field Text 5 (100 alpha) AL User Field Text 6 (100 alpha) AM User Field Text 7 (100 alpha) AN User Field Text 8 (100 alpha) AO User Field Text 9 (100 alpha) AP User Field Text 10(100 alpha) ================================================================= Job Cost Inc. (630)355-8188 PURCHASE ORDER IMPORT FILE (POTRAN.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Purchase order# (20 alpha) *B Vendor ID (10 alpha) C Purchase contact (30 alpha) D Billing vendor ID (10 alpha) E To be ordered date F Required date G Acknowledged date H Approved date I Approved emp ID (10 alpha) J Approved name (30 alpha) K Ordered date L Ordered emp ID (10 alpha) M Ordered name (10 alpha) N Service call ID (10 alpha) O Direct ship e (1 logical) P Ship to job ID (10 alpha) Q Ship to name (40 alpha) R Ship to address 1 (30 alpha) S Ship to address 2 (30 alpha) T Ship to city (21 alpha) U Ship to state (10 alpha) V Ship to zip (11 alpha) W Ship via (30 alpha) X Ship terms (30 alpha) Y Billing terms (30 alpha) Z Job ID (10 alpha) AA Phase ID (10 alpha) Note: necessary if using Job ID in field Z AB Cost type (numeric 1-6 where journaltype=PO or AP) Note: necessary if using Job ID in field Z AC GL account# (10 alpha) AD Item ID (20 alpha) AE Description (60 alpha) AF Quantity ordered (9999999999999.9999) AG Quantity UM (6 alpha) AH Price (9999999999999.9999) AI Price UM (6 alpha) AJ Discount percent (999999.99) AK Discount amount (99999999999.99) AL Sales tax percent (999999.99) AM Sales tax amount (99999999999.99) AN Freight percent (999999.99) AO Freight amount (99999999999.99) AP Received quantity (9999999999999.9999) AQ Received date AR Invoice# (15 alpha) Example: 15282,54285,,,,060204,,,,,060204,,,,,,,IL/PEMBROOK WOODS C.C.,WASHINGTON,NAPERVILLE,IL,60047,,,,301264,100,,,,12 THHN SOL RED|CU WIRE 500' SPL,1000,E,0.04228,,,,,,,,,, 15282,54285,,,,060204,,,,,060204,,,,,,,IL/PEMBROOK WOODS C.C.,WASHINGTON,NAPERVILLE,IL,60047,,,,301264,100,,,,12 THHN SOL BLU|CU WIRE 500' SPL,1000,E,0.04228,,,,,,,,,, 15282,54285,,,,060204,,,,,060204,,,,,,,IL/PEMBROOK WOODS C.C.,WASHINGTON,NAPERVILLE,IL,60047,,,,301264,100,,,,12 THHN SOL PUR|CU WIRE 500' SPL,1000,E,0.04228,,,,,,,,,, 15282,54285,,,,060204,,,,,060204,,,,,,,IL/PEMBROOK WOODS C.C.,WASHINGTON,NAPERVILLE,IL,60047,,,,301264,100,,,TAX,TAX,1,E,57.9,,,,,,,,,, EOF ================================================================= Job Cost Inc. (630)355-8188 INVENTORY RECEIPT/REQUISITION IMPORT FILE (INTRAN.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Receipt/Requisition # (10 alpha) B Employee id (10 alpha) *C Date D Job id (10 alpha) E Phase id (10 alpha) *F Warehouse (10 alpha) *G Item id or Barcode or ReferenceID (20 alpha) H Quantity (99999999.9999) I Item Price/Unit (9999999999.9999) Note: If no price/unit in file If record is a requisition: If Inventory Control Requisition Method is Purchase Price then set equal to Item Purchase Price If Inventory Control Requisition Method is Weighted Average then set equal to Item Weighted Average Price If record is a receipt: Set equal to Item Purchase Price J Job Price (9999999999.9999 - Requisiton Only) Note: If no job price in file Set equal to the above price/unit K Transaction Type (1 alpha - R for Receipt - Q or blank for Requistion) L Cost type (10 alpha - Requisition Only) Note: If no Cost Type Set equal to Item Cost Type M General Ledger Account id (10 alpha - Requisition Only) Note: If jobid on requisition If Admin, Job Cost, Controls has controlled account for the above cost type set equal to controlled account. If jobid on requisition If Admin, Job Cost, Controls does NOT have a controlled account for the above cost type, set equal to accountid in this file. If no accountid in this file set equal to Item Expense GL Accountid If no accountid, set equal to Admin, Inventory, Controls Expense GL Accountid N Description (60 alpha) Note: Only 1 description per Receipt/Requisition #, see field A O PO# (10 alpha) P Vendor id (10 alpha - Used on Receipt ONLY) Q Posted (T or Y for True - F, N or blank for False) R Accounting Month/Year (mmyy or mmyyyy) Example: 32423 ,, 90905 ,,, ,"0349 ",-2 , 145 ,,R,,,REQ 32423,,,T, 905 32423 ,, 90905 ,,, ,"0350 ", 70 , 10.14 ,,R,,,REQ 32423,,,T, 905 32423 ,, 90905 ,,, ,"0351 ",-38 , 8.75 ,,R,,,REQ 32423,,,T, 905 32423 ,, 90905 ,,, ,"0352 ",-95 , 3 ,,R,,,REQ 32423,,,T, 905 EOF ================================================================= Job Cost Inc. (630)355-8188 INVENTORY ITEM CUSTOMER/JOB PRICING IMPORT FILE (INPRIC.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. A Job ID (10 alpha) B Customer ID (10 alpha) C PriceType (10 integer) *D Item ID (20 alpha) E Markup/Discount% (99.99) Enter markups as a positive percentage & discounts as a negative percentage F Sales Price (999999999.9999) Example: 12345, 45678,1,1 1/2 BOLT,10.25, 12345, 45678,2,WIDGET,,103.2154 EOF ================================================================= Job Cost Inc. (630)355-8188 ACCOUNTS PAYABLE VENDOR IMPORT FILE (APVEND.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Vendor ID (10 alpha) *B Vendor name (40 alpha) C Address 1 (32 alpha) D Address 2 (32 alpha) E City (25 alpha) F State (10 alpha) G Zip code (9 alpha) H Telephone# (10 alpha) I Fax# (10 alpha) J Attention (60 alpha) K EMail (100 alpha) L Web site (100 alpha) M Insurance Cert Req (1 alpha) N Certificate date O Billing Vendor# (10 alpha) P Federal tax ID (20 alpha) Q Vendor account ID (30 alpha) R Dept Code (10 alpha) S Purchase account# (10 alpha) T Purchase contact (30 alpha) U Ship via (30 alpha) V Ship terms (30 alpha) W Bill terms (30 alpha) X Discount % (99.9999) Y Discount days (999) Z Discount day/month (99) AA Days until due (999) AB Due day of month (999) AC Tax Status (1 alpha:E/N/T/U/Z) AD 1099 Code (2 alpha: 0-14) AE State income (999999999.99) AF 1099 adjustment (999999999.99) AG State tax withheld (999999999.99) AH Misc Code (10 alpha) AI Check Detail (10 alpha:INVOICE/LINEITEM) ================================================================= Job Cost Inc. (630)355-8188 ACCOUNTS PAYABLE TRANSACTION IMPORT FILE (APTRAN.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. A PO# (20 alpha) *B Vendor ID (10 alpha) *C Invoice # (15 alpha) *D Invoice Date E Accting Month/Year (999999) F Discount $ (99999999.9999) G Due Date H Discount date I Job ID (10 alpha) J Phase ID (10 alpha) K Cost Type (10 alpha) L GL Account # (10 alpha) M Line Item $ (9999999999.99) N Line Item Retent $ (99999999.9999) O Quantity (99999999999) P Unit of Measure (6 alpha) Q Description (40 alpha) R Posted (alpha- True or False) ================================================================= Job Cost Inc. (630)355-8188 ACCOUNTS RECEIVABLE CUSTOMER IMPORT FILE (ARCUST.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Customer# (10 alpha) B Customer name (40 alpha) C Address 1 (32 alpha) D Address 2 (32 alpha) E City (25 alpha) F State (10 alpha) G Zip code (11 alpha) H Telephone# (10 alpha) I Fax# (10 alpha) J Attention/Contact (60 alpha) K Title (60 alpha) L Email (100 alpha) M Web site (100 alpha) N Salesman code (10 alpha) O Sales account# (10 alpha) P Discount % (99.9999) Q Discount days (999) R Discount day/month (99) S Days until due (999) T Due day of month (99) U Print statements (1 alpha) V Tax exempt (1 alpha) ================================================================= Job Cost Inc. (630)355-8188 ACCOUNTS RECEIVABLE TRANSACTION IMPORT FILE (ARTRAN.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Customer# (10 alpha) *B Invoice# (10 alpha) *C Transaction date *D Total Invoice $ (99999999.9999) *E Account# (10 alpha) F Description (28 alpha) G Job# (10 alpha) H Phase# (9999999999) I Accting Month/Year (mmyy or mmyyyy) J Quantity (99999999999.9999) K Unit/Measure (10 alpha) L Price/Unit (99999999.99) M Due Date N Discount$ (99999999.9999) O Retention$ (99999999.99) P Record type (10 alpha) Q Record Status (9) 5=posted R Note 1 (60 alpha) ... DM Note 100 (60 alpha) ================================================================= Job Cost Inc. (630)355-8188 JOB COST JOB IMPORT FILE (JCJOBS.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Job ID (10 alpha) B Job name (40 alpha) C Job address #1 (30 alpha) D Job address #2 (30 alpha) E Job city (21 alpha) F Job state (10 alpha) G Job zip (11 alpha) H Job telephone# (10 alpha) I Job fax# (10 alpha) J Job status (1 alpha:C/F/O/P/R) K Customer ID (10 alpha) L Owner ID (10 alpha) M Owner name (40 alpha) N Architect ID (10 alpha) O Sales account# (10 alpha) P Union ID (10 alpha) Q Salesman ID (10 alpha) R Estimator ID (10 alpha) S Supervisor ID (10 alpha) T Furnish descript (60 alpha) U Entry date V Completion date W Contract type (10 alpha) X Covered area (10 alpha) Y Department# (10 alpha) Z Retention% (99999999.9999) AA General/Sub (G/S) AB Taxable (1 alpha: T/N/U/E/Z) AC Tax exempt ID (20 alpha) AD Certified (10 alpha:CHICAGO/HOUSING/LCEXPORT/WH347JAN09/SBE48JAN09) AE Certified weeks (999999) AF Route (21 alpha) AG County (21 alpha) AH Section (21 alpha) AI Project (21 alpha) AJ Contract# (21 alpha) AK Controlled (1 logical: T/F) AL No work this week(1 logical: T/F) ================================================================= Job Cost Inc. (630)355-8188 GENERAL LEDGER ACCOUNT IMPORT FILE (GLACCT.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality an * Fields are required. *A GL Account # (10 alpha) *B Account Name (40 alpha) C Type (BS-A1 to BS-A6, BS-L1 to BS-L3, IS-1 to IS-9 or R) ================================================================= Job Cost Inc. (630)355-8188 GENERAL LEDGER TRANSACTION IMPORT FILE (GLTRAN.TXT): File -> General Ledger -> Ledger Transaction Import Create the file in a Comma Separated Value (csv) or Excel format. EXCEL IMPORT FILE Import supports Excel file types: XLS XLSX XLSM Excel Import supports import option: Skip first row of import file Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A GL Account # (10 alpha) B Job# (10 alpha) Required if phase# exists C Phase# (10 alpha Required if job# exists. *D Date If blank, will set to 12/31/2099 E Amount (999999999.99) F Units (999999999.9999) *G Journal type (10 alpha) Must be GJ. H Cost type (10 alpha) Required if jobid exists. Must be 1-6 for cost, 7 production or 8 billings. Otherwise, must be blank. *I Reference ID (20 alpha) If referenceid already exists, it will add to existing entry, posted or not. J Description (40 alpha) K Vend#/Cust#/Emp# (10 alpha) Vendor, Customer or Employee name looked up based on Journal Type or Subsystem Type. If a match is found, source name will be written. *L Transaction type (10 alpha) Must be N=normal, R=reversing or S=standard. If blank, will set to N. M Posted to GL (1 logical) FALSE or TRUE N Posted to JC (1 logical) FALSE or TRUE O Subsistance NOT USED *P Accounting Month/Year(mmyy or mmyyyy)Must enter a valid unposted month/year. If blank, will set to be Month/Year of Date in import row. Q Retention Amount (999999999.99) R Subsystem Type (10 alpha) If Journal Type = "GJ", must be AP, AR, CM, EQ, GJ, IN, or PR - If blank, will set to GJ. S Reference2ID (20 alpha) T UM (6 alpha) U Production Units (999999999.9999)If blank and CostType = 7, defaults to Units Example: 4750.2,,,103104,-2475,0,GJ,,DEPR1,accrued depreciation,,S,TRUE,FALSE,0,1004,0,GJ,Ref#2,EA,0 2420,8710,8,103104,2475,0,GJ,5,DEPR1,accrued depreciation,,S,TRUE,FALSE,0,1004,0,GJ,Ref#2,EA,0 EOF Import errors are reported in file GLTranErrorLog.txt, with error message at the end of the row. When running import from File menu, NO records will save to General Ledger - Ledger if ANY errors occur during import. ---------------------------------------------------------------------------------- DATA CONVERSION ONLY Import from Admin -> Miscellaneous -> Imports -> General Ledger -> Ledger Transactions, should ONLY be used by Job Cost Inc Customer Support for data conversions due to validation. When importing from Admin -> Miscellaneous -> Imports -> General Ledger -> Ledger Transactions: User can wait until end of import to display errors Automatically have import create new Job w/Name UNKNOWN if import job is invalid (requires Customer ZZZZZZZZZZ) Automatically have import create new Phase from Master Phase (if found) if import phase is invalid Automatically have import create new Phase w/Name UNKNOWN if import phase is invalid Validation Rules: A GL Account # GL Account # must exist in VC and not be marked inactive B Job# Job # must exist in VC, unless user has selected to automatically create invalid Job IDs. If not blank, requires Phase# C Phase# Phase# must exist on Job#, unless user has selected to automatically create invalid Phase IDs. If not blank, required Job# D Date No validation performed E Amount If NOT conversion, all amounts in import file must balance to 0 F Units No validation performed G Journal Type If NOT conversion, must be GJ. If Conversion, must be one of AP, AR, CM, EQ, GJ, IN or PR. If imported from File -> General Ledger -> Ledger Transaction import, must be GJ. If imported from Admin -> Miscellaneous -> Imports -> General Ledger -> Ledger Transactions, must be AP, AR, CM, EQ, GJ, IN or PR. H Cost Type If Job/Phase is being imported, must be blank. Otherwise, must be valid cost type: 1-6 for cost, 7 for production or 8 for billings. I Reference ID No validation performed J Description No validation performed K Vend#/Cust#/Emp# No validation performed L Transaction Type If not conversion, must be N, R, or S. If Conversion, must be N, R, S, or I M Posted to GL No validation performed N Posted To JC No validation performed O Subsistance No validation performed P Accounting Month/Year Must be greater than or equal to Month/Year of GL Control. If GL Control Month/Year is blank, must be greater than or equal to 01/1980 Q Retention Amount No validation performed R Subsystem Type If importing from Admin -> Miscellaneous -> Imports -> General Ledger -> Ledger Transactions, if blank, field derives from JournalType. Validation based on Journal Type If Journal Type = "GJ", must be AP, AR, CM, EQ, GJ, IN, or PR If Journal Type = "AP", must be AP, AP INVOICE, AP CHECK D, or GJ If Journal Type = "AR", must be AR, AR INVOICE, AR RECPT H, AR RECPT D, or GJ If Journal Type = "CM", must be CM or GJ If Journal Type = "EQ", must be PR, GJ, or EQ If Journal Type = "IN", must be INREQ or GJ If Journal Type = "PR", must be PR or GJ S Reference2ID No validation performed T UM No validation performed U Production Units Must be blank or 0 if Cost Type does not equal 7 Import errors are reported in file GLTranErrorLog.txt, with error message at the end of the row Job/Phase records that are automatically created are reported in file GLTranImportLog When running import from Admin menu, all records that do not error will save to VC. ================================================================= Job Cost Inc. (630)355-8188 GENERAL LEDGER ACCOUNT BALANCE IMPORT FILE (GLABAL.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Accounting Month/Year (mmyy or mmyyyy) *B GL Account # (10 alpha) *C Beginning Balance (99999999.9999) *D Net Change (99999999.9999) *E Type (1 alpha) Only imports R ================================================================= Job Cost Inc. (630)355-8188 PAYROLL EMPLOYEE IMPORT FILE (PREMPS.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. * A Employee# (10 alpha) B Nonpaycheck Emp(1 alpha) C Confidential (1 alpha) D First Name (20 alpha) E Middle Initial (2 alpha) F Last Name (20 alpha) G Employee Name (30 alpha) H Soc Sec# (9 alpha) I Address 1 (25 alpha) J Address 2 (25 alpha) K City (22 alpha) L ST (10 alpha) M Zip Code (11 alpha) N Telephone# (10 alpha) O Email (100 alpha) P Date of Birth Q Marital Status (10 alpha) R Ethnic (10 alpha) S Sex Code (10 alpha) T Terminated (1 alpha) U Terminated Date V Hired Date W Department (99) X Bill Rate$ (99999999.9999) Y Remain Vac Hrs (999.99) Z Labor Acct (10 alpha) AA Remain Sick Hrs(999.99) AB Union # (10 alpha) AC Work Class (10 alpha) AD Work Stat (10 alpha) AE Current Status (10 alpha) AF Previous Status(10 alpha) AG Preprinted (1 alpha) AH Pay Code (10 alpha) AI Pay Rate (99999999.9999) AJ Pay Per/Yr (999) AK Last Pay Period AL Work Comp Code (10 alpha) AM Hours/Day (99) AN Hours/Week (99) AO Pension (1 alpha) AP FICA Exempt (1 logical) AQ Phase ID (10 alpha) AR SWT state (10 alpha) AS SUT state (10 alpha) AT Equipment ID (10 alpha) AU FWT Status (10 alpha) AV FWT Extra (999999999.99) AW FWT Exemptions (99) AX Direct Deposit (1 alpha) AY 1st DD Code (2 alpha) AZ 1st DD Routing#(9 alpha) BA 1st DD Account#(17 alpha) BB 2nd DD Code (1 alpha) BC 2nd DD Routing#(9 alpha) BD 2nd DD Account#(17 alpha) BE 2nd DD Amount (999999999.99) BF 2nd DD Percent (999.999) BG Deduct Code 1 (10 alpha) BH Deduct Code 2 (10 alpha) BI Deduct Code 3 (10 alpha) BJ Deduct Code 4 (10 alpha) BK Deduct Code 5 (10 alpha) BL Deduct Code 6 (10 alpha) BM Deduct Code 7 (10 alpha) BN Deduct Code 8 (10 alpha) BO Deduct Code 9 (10 alpha) BP Deduct Code 10 (10 alpha) BQ Deduct Type 1 (10 alpha) BR Deduct Type 2 (10 alpha) BS Deduct Type 3 (10 alpha) BT Deduct Type 4 (10 alpha) BU Deduct Type 5 (10 alpha) BV Deduct Type 6 (10 alpha) BW Deduct Type 7 (10 alpha) BX Deduct Type 8 (10 alpha) BY Deduct Type 9 (10 alpha) BZ Deduct Type 10 (10 alpha) CA Deduct Freq 1 (10 alpha) CB Deduct Freq 2 (10 alpha) CC Deduct Freq 3 (10 alpha) CD Deduct Freq 4 (10 alpha) CE Deduct Freq 5 (10 alpha) CF Deduct Freq 6 (10 alpha) CG Deduct Freq 7 (10 alpha) CH Deduct Freq 8 (10 alpha) CI Deduct Freq 9 (10 alpha) CJ Deduct Freq 10 (10 alpha) CK Deduct Rate 1 (999999999.99) CL Deduct Rate 2 (999999999.99) CM Deduct Rate 3 (999999999.99) CN Deduct Rate 4 (999999999.99) CO Deduct Rate 5 (999999999.99) CP Deduct Rate 6 (999999999.99) CQ Deduct Rate 7 (999999999.99) CR Deduct Rate 8 (999999999.99) CS Deduct Rate 9 (999999999.99) CT Deduct Rate 10 (999999999.99) CU Temp 1 Amount (999999999.99) CV Temp 2 Amount (999999999.99) CW Temp 3 Amount (999999999.99) CX Temp 4 Amount (999999999.99) CY Temp 5 Amount (999999999.99) CZ Temp 6 Amount (999999999.99) DA Temp 7 Amount (999999999.99) DB Temp 8 Amount (999999999.99) DC Temp 9 Amount (999999999.99) DD Temp 10 Amount (999999999.99) DE Temp 1 Accum (999999999.99) DF Temp 2 Accum (999999999.99) DG Temp 3 Accum (999999999.99) DH Temp 4 Accum (999999999.99) DI Temp 5 Accum (999999999.99) DJ Temp 6 Accum (999999999.99) DK Temp 7 Accum (999999999.99) DL Temp 8 Accum (999999999.99) DM Temp 9 Accum (999999999.99) DN Temp 10 Accum (999999999.99) DO CYTD Ded 1 (999999999.99) DP CYTD Ded 2 (999999999.99) DQ CYTD Ded 3 (999999999.99) DR CYTD Ded 4 (999999999.99) DS CYTD Ded 5 (999999999.99) DT CYTD Ded 6 (999999999.99) DU CYTD Ded 7 (999999999.99) DV CYTD Ded 8 (999999999.99) DW CYTD Ded 9 (999999999.99) DX CYTD Ded10 (999999999.99) DY SWT Status (10 alpha) DZ SWT Exemptions (99) EA SWT Extra (999999999.99) EB CYTD SWT (999999999.99) EC SWT % FWT (999.99) ED Quarter 1 Gross(999999999.99) EE Q1 FICA Exempt (999999999.99) EF Q1 Social Sec (999999999.99) EG Q1 Medicare (999999999.99) EH Quarter 2 Gross(999999999.99) EI Q2 FICA Exempt (999999999.99) EJ Q2 Social Sec (999999999.99) EK Q2 Medicare (999999999.99) EL Quarter 3 Gross(999999999.99) EM Q3 FICA Exempt (999999999.99) EN Q3 Social Sec (999999999.99) EO Q3 Medicare (999999999.99) EP Quarter 4 Gross(999999999.99) EQ Q4 FICA Exempt (999999999.99) ER Q4 Social Sec (999999999.99) ES Q4 Medicare (999999999.99) ET Q1 FWT Exempt (999999999.99) EU Q1 FWT (999999999.99) EV Q1 EIC (999999999.99) EW Q2 FWT Exempt (999999999.99) EX Q2 FWT (999999999.99) EY Q2 EIC (999999999.99) EZ Q3 FWT Exempt (999999999.99) FA Q3 FWT (999999999.99) FB Q3 EIC (999999999.99) FC Q4 FWT Exempt (999999999.99) FD Q4 FWT (999999999.99) FE Q4 EIC (999999999.99) FF YTD Nontax Gr (999999999.99) FG CYTD Reg Hr (99999.99) FH CYTD Reg $ (999999999.99) FI CYTD OT Hr (99999.99) FJ CYTD OT $ (999999999.99) FK CYTD Dbl Hrs (99999.99) FL CYTD Dbl $ (999999999.99) FM CYTD VacHr (99999.99) FN CYTD Vac $ (999999999.99) FO CYTD HolHr (99999.99) FP CYTD Hol $ (999999999.99) FQ CYTD SicHr (99999.99) FR CYTD Sic $ (999999999.99) FS CYTD Commis Hrs(99999.99) FT CYTD Commis $ (999999999.99) FU CYTD Bonus Hour(99999.99) FV CYTD Bonus $ (999999999.99) FW CYTD Gr Tx (999999999.99) FX FYTD RegHr (999999.99) FY FYTD Reg $ (999999999.99) FZ FYTD OT Hr (999999.99) GA FYTD OT $ (999999999.99) GB FYTD Dbl Hours (999999.99) GC FYTD Dbl $ (999999999.99) GD FYTD VacHr (999999.99) GE FYTD Vac $ (999999999.99) GF FYTD HolHr (999999.99) GG FYTD Hol $ (999999999.99) GH FYTD SicHr (999999.99) GI FYTD Sick$ (999999999.99) GJ FYTD Commis Hrs(999999.99) GK FYTD Commis $ (999999999.99) GL FYTD Bonus Hour(999999.99) GM FYTD Bonus $ (999999999.99) GN FYTD Taxable (999999999.99) ================================================================= Job Cost Inc. (630)355-8188 EMPLOYER-PROVIDED HEALTH INSURANCE OFFER AND COVERAGE 1095-C IMPORT FILE (1095-C.xlms) Visual ContrAcct Version 10.40.07 or greater imports Excel Workbook. EXCEL IMPORT FILE Import supports Excel file types: XLS XLSX XLSM Excel import reads data from worksheet named: 1095-C Export for VC Import Excel import has option: Ignore First Row A EmployeeID B Print 1095-C Y/N C 14 Offer Of Coverage All Months D 14 Offer Of Coverage January E 14 Offer Of Coverage February F 14 Offer Of Coverage March G 14 Offer Of Coverage April H 14 Offer Of Coverage May I 14 Offer Of Coverage June J 14 Offer Of Coverage July K 14 Offer Of Coverage August L 14 Offer Of Coverage September M 14 Offer Of Coverage October N 14 Offer Of Coverage November O 14 Offer Of Coverage December P 15 Minimum Value All Months $ Q 15 Minimum Value January $ R 15 Minimum Value February $ S 15 Minimum Value March $ T 15 Minimum Value April $ U 15 Minimum Value May $ V 15 Minimum Value June $ W 15 Minimum Value July $ X 15 Minimum Value August $ Y 15 Minimum Value September $ Z 15 Minimum Value October $ AA 15 Minimum Value November $ AB 15 Minimum Value December $ AC 16 Safe Harbor All Months AD 16 Safe Harbor January AE 16 Safe Harbor February AF 16 Safe Harbor March AG 16 Safe Harbor April AH 16 Safe Harbor May AI 16 Safe Harbor June AJ 16 Safe Harbor July AK 16 Safe Harbor August AL 16 Safe Harbor September AM 16 Safe Harbor October AN 16 Safe Harbor November AO 16 Safe Harbor December Example: ADAMSJ,Yes,,1B,1B,1B,1B,1B,1B,1B,1B,1B,1B,1B,1B,,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,,2D,2D,2D,2D,2D,2E,2E,2E,2E,2E,2E,2E, ================================================================= Job Cost Inc. (630)355-8188 PAYROLL TIMECARD IMPORT FILE (PRTIME.TXT or EXCEL FILES) Visual ContrAcct imports CSV or Excel files. EXCEL IMPORT FILE Excel import feature requires Version 10.28.2 or Greater Import supports Excel file types: XLS XLSX XLSM Excel import reads data from worksheet named: Timecards Excel import has option: Ignore First Row CSV IMPORT FILE The import supports Comma Separated Value (CSV) format WITHOUT Header Row. If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The file may contain variable length records. Each line should end with a carriage return. FILE SPECIFICATIONS The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy Each line (record) may contain the following data fields: * Fields are required. *A EMPLOYEE ID (10 alpha) B UNION# (10 alpha) C DAY CODE (1 alpha: 1 to 14, W,R,V,H,S,B,N,C) D DATE *E JOB ID (10 alpha) *F PHASE ID (10 alpha) G GL Account ID (10 alpha) H WORK CLASS (10 alpha) I WORK STATUS (10 alpha) J WORKER COMP CODE (10 alpha: 5190, 8810) K REGULAR HOURS (numeric) L OVERTIME HOURS (numeric) M DOUBLETIME HOURS (numeric) N ADD-ON HOURS (numeric) O REGULAR PAY RATE (numeric) P OVERTIME PAY RATE (numeric) Q DOUBLETIME PAY RATE (numeric) R ADD-ON RATE (numeric) S TAXABLE AMOUNT (numeric) T NON-TAXABLE AMOUNT (numeric) U NON-TAXABLE CODE (10 alpha) V EQUIPMENT ID (10 alpha) W EQUIPMENT HOURS (numeric) X PRODUCTION UNITS (numeric) Y SUPERVISORID (10 alpha) Z WITHHOLDING STATE (10 alpha) AA UNEMPLOYMENT STATE (10 alpha) AB BILLABLE (1 logical: (T/F) AC LOCAL TAX (10 alpha) AD MISC (10 alpha) Example: JOE,U1234,,04/15/06,J03-001,P100,GL444,CLASS1,STATUS1,IL5514,8,2.25,0,0,20.0,30.00,40.00,0,0,0,,EQ222,10.25,0,,IL,IL,F,IN-PORTER,COOK IMPORT PROCEDURES Import Visual ContrAcct timecards from File > Payroll > Time Card Imports > Standard. Import has dialog option "Ignore First Row of Excel File". If importing an Excel file and a Header Row exists on First Row, select "Ignore First Row of Excel File". Note: This option only pertains to EXCEL files and is ignored if importing a CSV file. Import will skip blank rows of an EXCEL FILE. Import will report blank rows as invalid data of a CSV file. If invalid data exists, import will report to screen. Example of an Invalid EmployeeID Import Error Invalid EmployeeID John Smith on employeeID John Smith, day code 2, date mm/dd/yyyy OK will write the invalid record to ..\cscwin\data\import\PRTimeErrorLog.txt Cancel will exit without saving any records. OK CANCEL OK will write the invalid record to error file and continue importing. Cancel will exit without saving ANY records or renaming files. On completion of import: You will receive message "Time Cards Imported". If import filename is TIMECARD-WEEKLY.* OR TIMECARD-MONTHLY.* the filename will remain unchanged for future imports. Otherwise, the import file is renamed & moved into Payroll Directory as filename PrtYMMDD.###. ### is a sequential number beginning with 001. Note: If an Excel file was imported and you want to open the original file which was renamed to PrtYMMDD.####, make sure you open with Excel. If import created PRTimeErrorlog.txt error file: The file is a CSV file containing ONLY invalid records reported on import. The file must be renamed before another import can be run. Renaming of file is requires to ensure users review time cards that did not import. We suggest you manually fix the bad data in the file and import the renamed file. ================================================================= Job Cost Inc. (630)355-8188 PAYROLL HARD DOLLAR TIMECARD IMPORT FILE (PRTIME.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. A PAYPERIOD DATE (10 alpha) NOTE: THIS FIELD IS NO LONGER USED, THEREFORE CAN BE LEFT BLANK *B EMPLOYEE ID (10 alpha) *C JOB ID (10 alpha) *D PHASE ID (10 alpha) E REGULAR HOURS (numeric) F OVERTIME HOURS (numeric) G DOUBLETIME HOURS (numeric) H REGULAR PAY RATE (numeric) I OVERTIME PAY RATE (numeric) J DOUBLETIME PAY RATE (numeric) K UNION ID (10 alpha) L WORK CLASS (10 alpha) M WORK STATUS (10 alpha) N EQUIPMENT ID (10 alpha) O EQUIPMENT HOURS (numeric) P DAY CODE (1 alpha: 1 to 14, W,R,V,H,S,B,N,C) NOTE:DURING LAST TESTING, NUMERIC DAYCODES DID NOT WORK Q GL Account ID (10 alpha) R NON-TAXABLE CODE (10 alpha) S TAXABLE AMOUNT (numeric) T WORKER COMP CODE (10 alpha) U ADD-ON HOURS (numeric) V ADD-ON RATE (numeric) W NON-TAXABLE AMOUNT (numeric) X PRODUCTION UNITS (numeric) Y SUPERVISORID (10 alpha) Z WITHHOLDING STATE (10 alpha) AA UNEMPLOYMENT STATE (10 alpha) AB BILLABLE (1 logical: T/F) AC LOCAL TAX (10 alpha) ================================================================= Job Cost Inc. (630)355-8188 PAYROLL UNION IMPORT FILE (PRUNIN.TXT): Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. * A Union ID (10 alpha) B Local ID (10 alpha) C Union account# (11 alpha) D Union name (40 alpha) E Address 1 (40 alpha) F Address 2 (40 alpha) G City (21 alpha) H State (10 alpha) I Zip code (11 alpha) J Phone (10 alpha) K Fax (10 alpha) L Agreement (15 alpha) M Category (30 alpha) N Reg hours/day (99) O Reg hours/week (99) P Cap pay rate (99999999.9999) Q Capped hours (999.99) R Report type (10 alpha) S A/D/F/R (1 alpha) T Code (10 alpha) U Type (10 alpha) V Frequency (10 alpha) W Work class (10 alpha) X Work status (10 alpha) Y Amount/pay rate(99999999.9999) Repeat S-Y up to sixty total times ================================================================= Job Cost Inc. (630)355-8188 LOCAL 134 REPORTING IMPORT FILE (UNEMYYMM.TXT) Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A EMPLOYEEID (10 alpha) *B SOCIALSECURITYNO (999999999) *C FIRST NAME (20 alpha) *D LAST NAME (20 alpha) *E ADDRESS (25 alpha) *F CITY (20 alpha) *G STATE (2 alpha) *H ZIP (99999999999) *I BIRTH DATE (mmddyy) Example: 40 , 222124578 ,"MATT ","DUNPHY ", "930 LAKE STREET ","OAKBROOK ",IL, 603016621 ,022550 30 , 555963222 ,"JOSE ","CRUIZ ", "502 SOUTH MAPLE AVENUE","AURORA ",IL, 605068596 ,120756 ================================================================= Job Cost Inc. (630)355-8188 LOCAL 134 REPORTING IMPORT(UNTCYYMM.TXT) Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A AGREEMENT (15 alpha) *B JOB CATEGORY (30 alpha) *C PREPRINTED (Y/N) *D EMPLOYEEID (10 alpha) *E PREVIOUS STATUS (10 alpha) *F CURRENT STATUS (10 alpha) *G HOURS (9999999.99) *H WAGES (99999999.9999) *I WEEKS (99999999.9999) *J ENDDATE (mmddyy) *K NECA GROSS (99999999.9999) L CSC UNION# (10 alpha) Example: "COMM01 ","COMMUNICATION EMPLOYEE ",Yes, 40 ,ACT,ACT, 175 , 4343.5 , 1 ,072500,136 "MAINT01 ","SIGN & MAINTENANCE ",Yes, 30 ,ACT,ACT, 160 , 2960 , 1 ,072500,135 "CONSTR01 ","APPRENTICE 40% ",Yes, 20 ,ACT,ACT, 120 , 1464 , 1 ,072500,120 "CONSTR01 ","JOURNEYMAN ",Yes, 10 ,ACT,ACT, 170 , 4182.5 , 1 ,072500,134 ================================================================= Job Cost Inc. (630)355-8188 MISCELLANEOUS NOTES IMPORT FILE: Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. If importing to notes: If importing to user defined fields: *A TABLENAME (10 alpha) *TABLENAME (10 alpha) *B PRIMKEY (20 alpha) *PRIMKEY (20 alpha) C NOTELINE1 (100 alpha) USER TEXT 1 (100 alpha) D NOTELINE2 (100 alpha) USER TEXT 2 (100 alpha) E NOTELINE3 (100 alpha) USER TEXT 3 (100 alpha) F NOTELINE4 (100 alpha) USER TEXT 4 (100 alpha) G NOTELINE5 (100 alpha) USER TEXT 5 (100 alpha) H NOTELINE6 (100 alpha) USER TEXT 6 (100 alpha) I NOTELINE7 (100 alpha) USER TEXT 7 (100 alpha) J NOTELINE8 (100 alpha) USER TEXT 8 (100 alpha) K NOTELINE9 (100 alpha) USER TEXT 9 (100 alpha) L NOTELINE10 (100 alpha) USER TEXT 10 (100 alpha) M NOTELINE11 (100 alpha) USER DATE 1 N NOTELINE12 (100 alpha) USER DATE 2 O NOTELINE13 (100 alpha) USER DATE 3 P NOTELINE14 (100 alpha) USER DATE 4 (100 alpha) Q NOTELINE15 (100 alpha) USER NUMBER 1 (100 alpha) R NOTELINE16 (100 alpha) USER NUMBER 2 (100 alpha) S NOTELINE17 (100 alpha) USER NUMBER 3 (100 alpha) T NOTELINE18 (100 alpha) USER NUMBER 4 (100 alpha) U NOTELINE19 (100 alpha) NOTELINE1 (100 alpha) V NOTELINE20 (100 alpha) NOTELINE2 (100 alpha) W NOTELINE21 (100 alpha) NOTELINE3 (100 alpha) X NOTELINE22 (100 alpha) NOTELINE4 (100 alpha) Y NOTELINE23 (100 alpha) NOTELINE5 (100 alpha) Z NOTELINE24 (100 alpha) NOTELINE6 (100 alpha) AA NOTELINE25 (100 alpha) Etc. AB NOTELINE26 (100 alpha) AC NOTELINE27 (100 alpha) AD NOTELINE28 (100 alpha) AE NOTELINE29 (100 alpha) AF NOTELINE30 (100 alpha) AG NOTELINE31 (100 alpha) AH NOTELINE32 (100 alpha) AI NOTELINE33 (100 alpha) AJ NOTELINE34 (100 alpha) AK NOTELINE35 (100 alpha) AL NOTELINE36 (100 alpha) AM NOTELINE37 (100 alpha) AN NOTELINE38 (100 alpha) AO NOTELINE39 (100 alpha) AP NOTELINE40 (100 alpha) AQ NOTELINE41 (100 alpha) AR NOTELINE42 (100 alpha) AS NOTELINE43 (100 alpha) AT NOTELINE44 (100 alpha) AU NOTELINE45 (100 alpha) AV NOTELINE46 (100 alpha) AW NOTELINE47 (100 alpha) AX NOTELINE48 (100 alpha) AY NOTELINE49 (100 alpha) Etc. ================================================================= Job Cost Job/Phase Import File (JCPhas): JOB COST JOB IMPORT FILE (JCPHAS.TXT) Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A Job # (10 alpha) *B Phase# (10 alpha) C Phase Name (40 alpha) D Billing JTD $ (99999999.9999) E Cost1 JTD $ (99999999.9999) F Cost2 JTD $ (99999999.9999) G Cost3 JTD $ (99999999.9999) H Cost4 JTD $ (99999999.9999) I Cost5 JTD $ (99999999.9999) J Cost6 JTD $ (99999999.9999) K Production JTD Units (9999999999999.9999) L Billing JTD Units (9999999999999.9999) M Cost1 JTD Units (9999999999999.9999) N Cost2 JTD Units (9999999999999.9999) O Cost3 JTD Units (9999999999999.9999) P Cost4 JTD Units (9999999999999.9999) Q Cost5 JTD Units (9999999999999.9999) R Cost6 JTD Units (9999999999999.9999) S Billing Orig Est $ (99999999.9999) T Cost1 Orig Est $ (99999999.9999) U Cost2 Orig Est $ (99999999.9999) V Cost3 Orig Est $ (99999999.9999) W Cost4 Orig Est $ (99999999.9999) X Cost5 Orig Est $ (99999999.9999) Y Cost6 Orig Est $ (99999999.9999) Z Prod Orig Est Units (9999999999999.9999) AA Billing Orig Est Units (9999999999999.9999) AB Cost1 Orig Est Units (9999999999999.9999) AC Cost2 Orig Est Units (9999999999999.9999) AD Cost3 Orig Est Units (9999999999999.9999) AE Cost4 Orig Est Units (9999999999999.9999) AF Cost5 Orig Est Units (9999999999999.9999) AG Cost6 Orig Est Units (9999999999999.9999) AH Billing CO $ (99999999.9999) AI Cost1 CO $ (99999999.9999) AJ Cost2 CO $ (99999999.9999) AK Cost3 CO $ (99999999.9999) AL Cost4 CO $ (99999999.9999) AM Cost5 CO $ (99999999.9999) AN Cost6 CO $ (99999999.9999) AO Prod CO Units (9999999999999.9999) AP Billing CO Units (9999999999999.9999) AQ Cost1 CO Units (9999999999999.9999) AR Cost2 CO Units (9999999999999.9999) AS Cost3 CO Units (9999999999999.9999) AT Cost4 CO Units (9999999999999.9999) AU Cost5 CO Units (9999999999999.9999) AV Cost6 CO Units (9999999999999.9999) AW Billing YTD $ NOT USED AX Cost1 YTD $ NOT USED AY Cost2 YTD $ NOT USED AZ Cost3 YTD $ NOT USED BA Cost4 YTD $ NOT USED BB Cost5 YTD $ NOT USED BC Cost6 YTD $ NOT USED BD Production YTD Units NOT USED BE Billing YTD Units NOT USED BF Cost1 YTD Units NOT USED BG Cost2 YTD Units NOT USED BH Cost3 YTD Units NOT USED BI Cost4 YTD Units NOT USED BJ Cost5 YTD Units NOT USED BK Cost6 YTD Units NOT USED BL Billing MTD $ NOT USED BM Cost1 MTD $ NOT USED BN Cost2 MTD $ NOT USED BO Cost3 MTD $ NOT USED BP Cost4 MTD $ NOT USED BQ Cost5 MTD $ NOT USED BR Cost6 MTD $ NOT USED BS Production MTD Units NOT USED BT Billing MTD Units NOT USED BU Cost1 MTD Units NOT USED BV Cost2 MTD Units NOT USED BW Cost3 MTD Units NOT USED BX Cost4 MTD Units NOT USED BY Cost5 MTD Units NOT USED BZ Cost6 MTD Units NOT USED CA Billing U of M (10 alpha) CB Cost1 U of M (10 alpha) CC Cost2 U of M (10 alpha) CD Cost3 U of M (10 alpha) CE Cost4 U of M (10 alpha) CF Cost5 U of M (10 alpha) CG Cost6 U of M (10 alpha) CH Production U of M (10 alpha) CI Billable (1 logical) CJ Sort Group (10 alpha) formerly Total Level CK Not Used CL Type (10 alpha) CM Job Size (10 alpha) CN Contract Type (10 alpha) CO Item # NOT USED CP Retention% (99999999.9999) CQ Last Posted Date CR Labor Expense GL# (10 alpha) CS Workers Comp Code (10 alpha) CT Vendor# (10 alpha) CU Sales Tax Rate (99999999.9999) CV Sales GL# (10 alpha) CW Billing Price/Unit (99999999.9999) CX Units 2Inv (99999999.9999) CY Cost to Complete (99999999.9999) CZ Subcontract 100% (1 alpha) ================================================================= Job Cost Inc. (630)355-8188 JOB COST JOB/PHASE ESTIMATE IMPORT FROM HARDDOLLAR (JCPHES##): (This import is designed to import one job.) The standard ASCII text file format required for importing is as follows: Each line (record) may contain the following data fields: * Fields are required. # Field Type Jst St Ln Dec #Recs A Record Type A L 1 5 BID = Bid Items 1-x WBS = WBS Activities 0-x BOND = Bond amount 0-1 ESC = Escalation 0-1 FIN = Finance Charge 0-1 * New for 97.2 * MKD = Direct Markup 0-1 * New for 97.2 * MKO = Overhead Markup 0-1 TAX = Tax Add Ons 0-100 GOH = General Overhead 0-150 JME = Job Mngmt & Equip 0-100 IND = Indirects 0-100 WPA = Work Plan Add Ons 0-100 B Account Number A L 6 15 C Account Desc A L 21 30 D Account Qty N R 51 20 5 E Account UM A L 71 2 F Id A L 73 20 G Description A L 93 30 H Bid Qty N R 123 20 5 I Forecast Qty N R 143 20 5 J UM A L 163 2 K Labor Amt N R 165 20 5 L Labor Burden Amt N R 185 20 5 M Labor Hrs N R 205 9 N Equip Own Amt N R 214 20 5 O Equip Op Amt N R 234 20 5 P Equip Hrs N R 254 9 Q Rental Amt N R 263 20 5 R Supply Amt N R 283 20 5 S Material Amt N R 303 20 5 T Subcontract Amt N R 323 20 5 U Other Amt N R 343 20 5 V Tax Amt N R 363 20 5 W Total Amt N R 383 20 5 X Bid Item Line N R 403 5 Y Bid Item Code A L 408 20 Z Bid Item Desc A L 428 25 AA Bid Item Qty N R 453 20 5 AB Bid Item ToQty N R 473 20 5 AC Bid Item UM A L 493 2 AD Bid Item Price N R 495 20 5 AE Job Code AS L 515 8 AF Job Desc AS L 523 30 AG County AS L 553 25 AH State AS L 578 2 AI Planned Start Date AS L 580 10 (mm/dd/yyyy) AJ Planned Comp Date AS L 590 10 (mm/dd/yyyy) AK CRLF 600 2 Record Length 601 Type: A = Alphanumeric N = Numeric S = Static - the same data in every record Jst: L = Left justified R = Right justified St: Starting position in record Ln: Data length Dec: Decimal precision (decimal aligned, trailing zeros included) All amount fields are extended amounts, not units. Bid Item (record type BID) records contain prices (revenue) and their sum will equal the total bid PRICE for the job. All other record types contain costs, and their sum will equal the total bid COST of the job. Field #23 is the total of the amounts in fields 11-12, 14-15 and 17-22 which are the 10 standard Hard Dollar categories. Fields 24-30 apply only to Bid Item (BID) and Work Breakdown Structure (WBS) type records. For WBS records these fields will contain the Bid Item information only if the WBS activity is assigned to a Bid Item. Fields 31-36 are static fields, and contain the same job information in each record. Example: "WBS","100-MOB","Mobilization",1.00000,"LS"," 1 1","Move equipment in",1.00000,1.00000,"LS",968.00000,200.00000,80.00,486.80000,430.00000,40.00,0.0 0000,0.00 000,0.00000,0.00000,0.00000,0.00000,2084.80000,1,"A-000001","MOBILIZATION",1.0 0000,1 .00000,"LS",9229.34000,"EOS99","EOS Sampler 2001","MARICOPA","AZ","11/01/1998","08/16/1999" When you import job/phases, the import program will ask you for the following: Customer # (10 alpha) This field is required to be entered on screen in order to import a file. ================================================================= Job Cost Inc. (630)355-8188 JOB COST JOB/PHASE ESTIMATE IMPORT (JCPHES.TXT): (This import is designed to import one job.) Create the file in a Comma Separated Value (csv) format. Note: If file is created in Excel, you can convert the file into a Comma Separated Value (csv) format by using the "save as" functionality and choose the .csv file type. The file cannot contain commas inside the fields. The date fields can be provided in the formats: mmddyy or mm/dd/yy or mmddyyyy or mm/dd/yyyy or mddyy or m/d/yy or mddyyyy or m/dd/yyyy The file may contain variable length records. Each line should end with a carriage return. Each line (record) may contain the following data fields: * Fields are required. *A PHASE/ITEM/COSTCODE/BIDITEM # (10 alpha) B PHASE NAME (40 alpha) C BILLING COST TYPE #8 UNITS (99999999999999.9999) D BILLING COST TYPE #8 UM (6 alpha) E COST TYPE #1 UNITS (usually LABOR HOURS) (99999999999999.9999) F COST TYPE #1 $ (usually LABOR) (999999999999.99) G COST TYPE #2 $ (usually LABOR OH) (999999999999.99) H COST TYPE #3 $ (usually EQUIPMENT) (999999999999.99) I COST TYPE #4 $ (usually MATERIAL) (999999999999.99) J COST TYPE #5 $ (usually SUB) (999999999999.99) K COST TYPE #6 $ (usually MISC) (999999999999.99) L BILLING/CONTRACT/REVENUE COST TYPE #8 $ (999999999999.99) M WORKERS COMP CODE (State/Code) (10 alpha) N PHASE TYPE (10 alpha) O Change Order ID (10 alpha) P Change Order Status (PENDING, APPROVED or REJECTED) Q Sort Group (10 alpha) R PRODUCTION COST TYPE #7 UNITS (99999999999999.9999) S PRODUCTION COST TYPE #7 UM (6 alpha) T COST TYPE #2 UNITS (usually LABOR OH) (99999999999999.9999) U COST TYPE #3 UNITS (usually EQUIPMENT) (99999999999999.9999) V COST TYPE #4 UNITS (usually MATERIAL) (99999999999999.9999) W COST TYPE #5 UNITS (usually SUB) (99999999999999.9999) X COST TYPE #6 UNITS (usually MISC) (99999999999999.9999) Y COST TYPE #1 UM (usually LABOR) (6 alpha) Z COST TYPE #2 UM (usually LABOR OH) (6 alpha) AA COST TYPE #3 UM (usually EQUIPMENT) (6 alpha) AB COST TYPE #4 UM (usually MATERIAL) (6 alpha) AC COST TYPE #5 UM (usually SUB) (6 alpha) AD COST TYPE #6 UM (usually MISC) (6 alpha) AE Vendor ID (10 alpha) Example: 200,Demolition,1200,CY,80,2400,960,5760.50,0,0,0,20000,IL8810,C,CO1,PENDING,2,80,200,0,0,0,HR,HR,HR,,,,1200,CY,100 1600,Electric,1,LS,0,0,0,0,10000,20000,0,40000,IL8810,C,CO2,APPROVED,3,0,0,0,1,0,,,,,LS,,1,LS,1100 When you import job/phases, the import program will ask you for the following: JOB # (10 alpha) This field is required to be entered on screen in order to import a file.