=================================================================
VISUAL CONTRACCT README.TXT
Updated 04/10/2023 TLL
Software Version 10.46.06
=================================================================
Job Cost Inc.
208 N Washington Street
Naperville, IL 60540-4514
Phone (630)355-8188
website http://www.jobcost.com
email support@jobcost.com
=================================================================
COMPUTER RECOMMENDATIONS:
=================================================================
SERVER Operating System:
Microsoft Windows 2012 Server or newer
WORKSTATION Operating Systems:
Windows 10 Pro
Processor: Intel i5 or greater
Memory: 4 GB or greater
NOTE: If Windows 64-bit server or workstation, see below “ODBC CONNECTION FOR CRYSTAL REPORTS & CRYSTAL REPORTS VIEWER”
THE FOLLOWING ARE SUPPORTED, BUT NOT RECOMMENDED:
Microsoft Windows 2008 or 2008R2 (security updates will stop January 2020)
Windows 10 Home
Windows 8 or 8.1 Pro or Home
Windows 7 Professional or Ultimate (32-bit or 64-bit) (security updates will stop January 2020)
THE FOLLOWING ARE NOT SUPPORTED:
Non-Microsoft Windows Server products are not supported (e.g. Linux/NAS devices/Apple devices/Other storages devices)
DO NOT USE MAPPED DRIVES
=================================================================
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.
DO NOT USE MAPPED DRIVES
CONFIGURE VISUAL CONTRACCT WITH UNC
Icon Properties
\cscwin\install\WKSetup.ini
\cscwin\ .INI Files
Visual ContrAcct Admin > Miscellaneous > Controls – Data Directory Paths
Visual ContrAcct Admin > Miscellaneous > Users – Each user Crystal Reports Viewer Directory Paths
=================================================================
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 and Malwarebytes 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
* error message – HH.exe could not be open
===================================================================
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)
Error Installing vfpodbc.msi.
Installer Information message box with error Internal Error 2503
Installer Information message box with error Internal Error 2502
Try to save a file to the c:\Windows\Temp folder. If unsuccessful, then the User does not have rights to c:\Windows\Temp folder. Have IT give the User rights to this folder.
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.
R:\CSCWIN\csc.EXE i=tlevinson.ini M=RX
The R tells Visual ContrAcct to do an Alt R (for Reports menu) once in Visual ContrAcct.
The X tells Visual ContrAcct to select Executive Summary.
===================================================================
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
===================================================================
* Array Index out of bound
Visual ContrAcct AR Invoice Email or Purchase Order Email feature uses
Outlook to automatically create an email with AR Invoice or Purchase Order
attachment. If a user attaches an additional document to that email, they
receive “Array Index out of bounds”.
Resolve by updating customer to VC10.45.15 or greater.
This bug only affected users who are on both Windows 10 and Office 365
* Emails begin to send and receive error OR hangs:
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.
Email of Direct Deposit Check Stubs requires Microsoft Outlook 32 bit.
Email of AR Invoices and PO’s works with either Microsoft Outlook 32 bit or Microsoft Outlook 64 bit.
If emails look good run FixWindows1803.reg from c drive
* 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.
Outlook Creates First Email and puts it into draft, Visual Contracct then CRASHES
Mike C did the following to torubleshoot and fix:
Looked at Outlook and it is running Office 365 32-bit.
Looked at the Outlook Profile and found a weird setting for the data file in a location that was not even listed in the system.
Also, there was no mail app inside control panel to modify or delete the Outlook profile.
There was a message on the Outlook task bar icon that said another program has control of Outlook.
We closed Outlook and opened it up again and it still had the same problem.
Since we can’t delete the Outlook profile (no mail program in Control Panel) I recommended that we reinstall Office 32-bit.
He did that with me on the system and then we fired up Outlook and configured it normally.
Now, the Mail app in Control Panel shows up and I can see the Outlook profile in the mail app and it appears that the programs and Outlook profile and data files were located as expected.
We run Outlook and it is caching/downloading email to her system.
Then I fired up VC and went into the Direct Deposit and sent out emails and it worked successfully.
======================================================================================
* MICROSOFT OFFICE 365 V2004 (Build 12730.20206) CAUSED BELOW VISUAL CONTRACT ISSUES
Microsoft Office 365 V2004 12730.20236 resolved.
======================================================================================
To determine Microsoft Office 365 version:
Run Microsoft Office 365 Word > Select File > Select Account – Note Version Information.
If Version 2004 (Build 12730.20206 Click-to-Run),instruct user to select button above
Update Options – Update now. If this process installs update to
Version 2004 (Build 12730.202036 or greater, test VC as issues should be resolved.
* PR EMAIL DIRECT DEPOSIT TO EMPLOYEE ERROR
An error has occurred attempting to email direct deposit
check stubs. Please contact Job Cost, Inc. customer support.
* CERTIFIED Reports will show as emailed (NO ERRORS)but emails will not be sent.
* CRYSTAL REPORT VIEWER ERROR EXPORTING TO CSV
Fatal error: Exception code=C06D007E @ 04/28/2020 10:26
AM. Error log file: C:\Program Files (x86)/Common
Files\Microsoft shared\vfp\vfp9rerr.log
Called from – launchcrystalreportviewer line 3205
(\\jciserver1\jciapps\cscwin\programs\functions.prg
Functions.fxp
Called from – frmcrreportdialog.runcrystalreport line
7 (\\jciserver1\jciapps\cscwin\classes\crystal.vct
\\jciserver1\jciapps\cscwin\classes\crystal.vct)
Called from – frmcrreportdialog.lstreport.dbclick
Line 4 (\\jciserver1\jciapps\cscwin\classes\crystal.vct
\\jciserver1\jciapps\cscwin\classes\crystal.vct)
Called from – crreport line 42
(\\jciserver1\jciapps\cscwin\programs\crreport.prg crreport.fxp)
Called from – ON line 0{}
Called from – sysmain line 568
(\\jciserver1\jciapps\cscwin\programs\sysmain.prg
\\jciserver1\jciapps\cscwin\csc.exe)
===================================================================
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.
VC PR DIRECT DEPOSIT CHECK STUBS HAVE NO YTD TOTALS ON THEM
This happens if there is a future pay period date that is posted before the direct deposit check stubs are sent.
Office PR w/e = 03/19/2022, Field PR w/e = 03/20/2022, Field PR is posted to Employee file before check stubs are emailed for w/e 03/19/2022.
===================================================================
VISUAL CONTRACCT IMPORT FILE TROUBLESHOOTING
===================================================================
* GA Error – Timecard Import – Damaged file – Contact Customer Support
Backup data files
Copy new 14 files
Run 5 DBMaint Steps
* PCPARENT error – AP Invoice Import – costtype was missing on several job line items
===================================================================
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
——————————————————————-
*error on Windows 10 version 1803 OS build 17134.472 workstation,
Windows 10 Home OS updated to Windows 10 Pro before running wksetup.
Error – ‘the c:\windows\system32\hhctrl.ocx could not be opened.
Please check that your disk is not full and that you have access to the destiination directory’.
Deleted the hhctrl.ocx file from c:\windows\syswow64\ then it errored on
the next files of ITIRCL.dll, ITSS.dll, MSVCRT.dll, MSVCRT40.dll, OLEAUT32.dll,
OLEPRO32.dll, ASYCFILT.dll, STDOLE2.tld. Had to delete each file from
c:\windows\syswow64\, then wksetup would run.
* ERROR MESSAGE – “The file ‘C;\Windows\HH.exe’ could not be opened”
Windows 10 workstations, running WKSETUP.EXE 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 or greater
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.
* ERROR MESSAGE – “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.”
Norton Antivirus was blocking wksetup from running. Go into Norton, set exclusion for ‘networkpath\cscwin folder in the behavior section and the scan section of Norton.
* 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 runs without errors but new icon does not appear on the desktop.
Try logging the workstation in as domain admin and run wksetup.exe again.
* 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:
Type in Control Panel in Cortana Search > 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 Medium-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 Medium-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.
This fix though is not always the case.
Here is the second (recommended) option to disable this message:
Hold the Windows Key, then press “R” to bring up the Run Dialog Box.
Type in “gpedit.msc”, then select “OK”.
Go to “User Configuration” > “Administrative Templates” > “Windows Components” >
“Attachment Manager”.
Open the “Inclusion list for moderate risk file types” setting.
Set the policy to “Enabled”, then add “*.exe” or whatever the file extension you are
using to the “Specify moderate risk extensions” box.
Click “Apply” and then “OK”.
* 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.
*”No PARAMETER statement is found” VC Error
Error will occur when there is NO csc.exe file in the CSCWIN folder
Put the file back in place and run WKSetup
This will resolve the issue.
———————————————————————
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.
*Memory full due to WINWORD.EXE file not closing once it opens
Emailing an AR Invoice or AR Invoices Contract creates file WINWORD.EXE which can be seen in Task Manager > Processes.
There would be multiple files open.
Update VC to Version 10.45.26 or greater.
* 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 form alignment issue printed to a Samsung M3320ND printer:
Use Driver: Samsung Universal Printer Driver 3
Do NOT use driver: Samsung M332x 382x 402x Series Driver
——————————————————————-
VISUAL CONTRACCT INVALID SEEK ERROR
——————————————————————-
Program Error: “Error reading file c:\temp\sysmain.fxp”
Second Program Error: “Invalid seek offset.”
To Fix:
Change the environment variable to point to c:\tmp and c:\temp and specifically give the user FULL access to directories.
The Hardware person will have to do this!
——————————————————————-
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.
vf
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.
Crystal Report VC Error “The following crystal reports runtime files are missing/unregistered: crtowords_en.dll”
Crystal Report VC Error “Class definition CRYSTALRUNTIME.APPLICATION is not found.”
To fix: Run WKSetup
Crystal Reports Login Failed Error “s1000 microsoft odbc visual foxpro driver invalid file descriptor”
Check system > advanced system settings > environment variables > TEMP and TMP folders
If the location of either TEMP or TMP folder do not exist, create the folder
This should fix this issue
Crystal Reports Login Failed Error: “Login Failed.”
To fix:
Delete Visual Contracct from USER DSN
Make sure Visual Contracct is set up in SYSTEM DSN
Crystal Reports VC Error “S1000:[Microsoft][ODBC Visual FoxPro Driver]Memo file\\cscwin\companyname\csc.fpt is missing or invalid”
To fix: Run wksetup and reset odbc when asked.
CRYSTAL REPORTS VIEWER ERROR “”the following crystal reports are missing/unregistered: craxdrt9.dll crviewer9.dll”
To Fix: Run VFPODBC and newest WKSETUP
===================================================================
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:
RoutingNocash management bank routing micr for general ledger cash account
BankAccountNOcash management bank account# for general ledger cash account
CheckNo
Date mmddyy
Amount2 decimal – no commas or dollar signs
IndicatorI=Issued or V=Void
Payee Nameemployee 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:
RoutingNocash management bank routing micr for general ledger cash account
BankAccountNOcash management bank account# for general ledger cash account
CheckNo
Date mmddyy
Amount2 decimal – no commas or dollar signs
IndicatorI=Issued or V=Void
Payee Namevendor 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)
AQ Make Receipts (1 logical)
=================================================================
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 # (20 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 numeric)
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
“Skip first row of import file” does NOT support CSV, this is excel only.
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 if no jobid exists.
*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 TypeIf 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.
OKCANCEL
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.
If import contains numeric with a decimal job/phase and/or equipment ID
Highlight Columns E (JOB ID), F (PHASE ID ), and/or V (EQUIPMENT ID)
Right click > Format Cells > Number > Select “Text” > Click Ok
Save
Save As… > Save as Type “CSV (Comma Delimited) (*.csv)
=================================================================
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.
