If you pull up the job in Job Set  Up and select "Status".  System tracks Start and completion date, the last cost update date.  You can also ask your accoutant/ Controller to let you know which projects have been closed out on the books per the WIP schedule.  Hope this helps.

If you pull up the job in Job Set  Up and select "Status".  System tracks Start and completion date, the last cost update date.  You can also ask your accoutant/ Controller to let you know which projects have been closed out on the books per the WIP schedule.  Hope this helps.

Thanks for the reply and the notes.  I am the accountant/controller.  :-)  We are unsure if these are very old jobs needing to be closed (zero transactions) or very new jobs (with zero transactions).   A job setup date would help solve that issue.

This is a great idea. I was assuming the start date hasn't been entered. If the users have been entering the dates, that would be the best solution. However, the system doesn't record the Start and End Dates and, in my experience, they are often left blank. The one date that is updated automatically by the system is the "Last Cost Update". This would be very helpful, but I have seen some databases with incorrect dates - if an AP invoice is entered wtih a date in 2029, for example, that date becomes the Last Cost Update date. It is only updated when an entry after that date is posted. 

Interesting. I'm not giving up yet. Have you checked the Date Stamp on the Job table? It should show the last date the Job was modified.

When you say "the date stamp" field, I am not sure what you are referring to.  The start and completion date fields that AnaC mentioned above are manually edited fields by users.  In my case, nothing as been manually entered.  I am looking for a system recorded field that tells me when the job was created.  (as you said below, that doesnt exsist.  

I also have ODBC connection to the JCM_Master_Job table and I am not seeing any data fields with populated data that resemble a "Date Modified".  Perhaps I am just overlooking it, but maybe not if it just doesnt exsist.

Sorry for not being clearer - I think I mentioned in my earlier post that the Date Stamp field is automoatically assigned by the system. This applies to transations as well as master files, such as the Job. Every time an update is made to the Job or an entry is posted to it, the date stamp is updated to the actual date of the change. It's not using the Transaction Date or Accounting Date, it's the date on your server.

You may want to consider adding a Job Custom field to track the date the Job was created going forward. As previously mentioned, there isn't a field that tracks this automatically on the Job. The Date Stamp on the JC Record will be updated any time anything is updated on that Job (even if you just go into Setup Jobs and change something and click Save.)  You could feasibly use the Estaimated and/or Revised Start Dates for this purpose as well, but those are there for another purpose so if you really want to be able to keep track of when the Job was added in Job Cost, create a custom field.  You can make it required but keep in mind that if you make it required you will need to populate it on all existing jobs as well, or Job Cost won't let you out of Setup Jobs until you do.

do these jobs have estimates?  if so you can see when the estimates were entered by going job cost, transactions, cost/estimate transactions.  go to the job number and you will see the estimate and date of estimate.