Any help on this error? I’m not a serial number expert and one of our users changed a serial prefix for the year change. I was told he did this when there were parts with old format SN’s already assigned to jobs in WIP, but none were in stock so he was able to change it on both the part header and the site tab, but now he gets this error when trying to assign a new SN to a new job.
Prefix is set for 9622 and it’s a 4 digit serial number with leading zeros. Nothing else is enabled.
For reference last SN that was assigned to that part was 96212109
So you only have 4 digits for the numeric part of your serial number. You are trying to go past 96229999.
I’m not sure if it will work but you can try to change the Number of Digits from 4 to 5. If it works, your serial numbers will now be 9 digits. Make sure labels and other stuff work.
If that doesn’t work, you may have to create a Mask with a higher number of digits and then assign that here.
There are no SN’s that exist with 9622 prefix. It was just changed to this prefix and the last SN assigned to a job for that PN was 96212109. The next SN that I expect them to be generating is 96220001. I looked back in all generated SN’s and each year prefix change it starts back up at 0001 for the first part of the year.
I’ve been told they do this every year, but clearly something different happened to cause this error. I’m just lucky enough to be the guy who has to find a way to fix it after it’s broken.
Unless something has changed, it doesn’t care what the prefix is. Once the counter overflows, you’re done. It doesn’t roll over and I’m not sure why. But I’ve never been able to reset the counter before.
The only way around it that I’ve found was to define a Mask (the same way as the part), assign it to the part, use the Mask sequence numbers, and then start the counter over.
I could understand that if there were only 9999 parts ever made with SN’s but since 2013 when they started tracking this part they have generated 12625 Serial numbers, each year the prefix changing and the 4 digit number starting over again.
We can’t change the SN format, length, due to a customer requirement, there has to be a way to fix this otherwise this is a ridiculous problem with Epicor that I can not believe no one has found yet.
If serial numbers use the NextValue API, and you’re on prem, and you determine that someone did blow through all the remaining serial numbers, you could find the counter in the database and reset it. I don’t remember the table names that NextValue uses, but I remember them being easy to find by querying sys.tables and sys.columns.
Why would this coincide with them changing the prefix though? It’s not like it just started when they were assigning a number, it happened immediately after they changed the prefix on multiple different PN’s.
