Problem
the code numbers in the master index don't match / correspond
with lookups names in MacNail construction accounting software.
It shows the wrong 'jobsite' or 'job name', or is not matching job# code
Diagnosis
Happens when they have nonsequential or very high job numbers, or use letter codes for jobs. Usually
it puts in office as job.
May also happen if they've previously removed the job in question (Lookup will then get the next higher job)
Solution
Get into job costing manager and choose Put Projects
in Order, which will sort the code numbers.
Also make sure the job is really there!
If that still doesn't fix it, check Lookup formulas-- may need to put them back in so the changes are transferred.
NOTE-- Our newer Goldenseal accounting software does
not require Excel, and it is also much easier to set up. It avoids
all the complexities caused by linking data between different
worksheet files.
Comments
Entered 3/10/93 by Dennis. Updated 11/7/2010.
|
