Troubleshooting
Refer to this section for help with errors you may encounter when validating or importing information.
Compile Error
If you have upgraded from a previous version of Job Import, you may encounter the following situation the first time you are working with the spreadsheet and choose to Validate Only or Update Job Cost. Microsoft Visual Basic for Applications opens, with the error message, Compile error: Can't find project or library.
Steps to work around:
- In the error message window, choose OK. The References - JobCostImport window opens. You can also open this window by choosing Tools > References.
- Unmark the checkbox next to WSJobImport.
Scroll down and mark the checkbox next to Signature Excel Job Import.
If step 3 fails, you can also mark the Signature Excel Job Import checkbox by using the Browse button to open the WSJobImport.tlb file from the location where Job Import is installed, for example, C:\Program Files\Signature\Signature Job Import 2016.
- Choose OK.
Cost Code Error
You may receive an error message telling you that the master cost code does not exist. This cost code does not exist in the cost code master table and cannot be imported. Please set up the master cost code.
- If you are using cost code posting, job information cannot be imported if a cost code is missing from the cost code master table. You must set up the cost code before the import can be completed successfully.
- If you are using division posting, the Cost Code Must Exist in Master Job Import Setup option determines if you can import job information when the cost code does not already exist in Job Cost.
Accounts Index Error
You may receive an error message telling you that the GL account does not exist.
The account number is missing. The cost code cannot be imported. Please set up the master cost code table.
If you are using cost code posting, the GL account index for a cost code cannot equal zero. If the GL account is missing from the master table for one of the cost codes, you must set up the account index before the import can be completed successfully.