We are needing to restart our job number sequence to a smaller sequence. Example current number is 259339352. We need to restart at 4 or 5 digits like 30000. How can I restart the sequence. Is it something I can do at year end?
We are needing to restart our job number sequence to a smaller sequence. Example current number is 259339352. We need to restart at 4 or 5 digits like 30000. How can I restart the sequence. Is it something I can do at year end?
hi Sarah Kent
is this the Sage 50 product you are using?
Sorry I should have specified Sage 100 Contractor
Moving this post to the Sage 100 Contractor forum in the Sage Construction and Real Estate Support Group.
Thanks,
Derek
If you have the space for the smaller numbers, you will have to override the default every time you create a new job, until you can get the higher job #s archived.
Otherwise, you need a data repair to change the job #s on all the records, costly and time consuming but it can be done by a certified consultant.
Check out Solution ID: 220924360103148 in KB
This is a "fix" on the update released last week:
Accounts Receivable fixes l When you use Next as the default invoice number, the default number is always the next highest number in the system, including when you edit an existing invoice.
Char, Thank you for the response! Can I ask a clarification question. Lets say my current job number in Sage is 65326987. If I archive my closed jobs and after doing so the largest job number left is 5221 will the system then automatically reset and generate the next job number as 5222?
In theorgy yes, but I would create the next job # as 5222 just to make sure it resets
Thanks Kathy!
Hi Char DeLange , if this suggested answer helped, please mark it as verified (by clicking the "Verify Answer" button next to Reply, on the response) for the benefit of others in this forum . Thank you!
Woo Hoo!!!! Sage just released (yet) another update to Version 25.2, that gives us back the ability to change the numbering schema:
With the release of version 25.2, when the program determines the next default number for a field like Invoice# or Order#, it now finds the highest existing purely numeric value and adds 1 to determine the next number. If you prefer the old method of determining the next number, you can modify a special settings file in the \Sage100Con\Common\Customization folder on the server to direct Sage 100 Contractor to find the most recently used number, instead. For instructions on how to use this file, see Knowledgebase article 231019165854183, "How to change the method used by Sage 100 Contractor to determine the next number to use in a character field for a new record."
*Community Hub is the new name for Sage City