Syteline V3.5 Job Order No. Reset

richardk

New Member
Hi All,
does anybody know how to reset the Production Job Order No. as my counter is fast approaching the limit?
Any help on this would be great.
 

darrenk

Member
Check you lasttran table. Cannot remember if your version stated above contains the Job last transaction field.
That's where you would (carefully) update it (if available to you).
If not, a better way would be to write a custom trigger upon creation of new jobs to sequence them with alpha and numeric characters - not just numerics.
The issue is with resetting the last Job # would be that you "run into" and existing job number again somehow.
That would most likely crash the DB.
 

richardk

New Member
Check you lasttran table. Cannot remember if your version stated above contains the Job last transaction field.
That's where you would (carefully) update it (if available to you).
If not, a better way would be to write a custom trigger upon creation of new jobs to sequence them with alpha and numeric characters - not just numerics.
The issue is with resetting the last Job # would be that you "run into" and existing job number again somehow.
That would most likely crash the DB.
Many thanks for your reply. Unfortunately the Job last transaction field is not available, but you can change the jobs with a prefix.
I will investigate this to see if this a work around without crashing the DB.
 
Top