In Company Configuration > Modules > Sales > Order > Starting Order Number, our value was previously set at 1000. This prevented users from manually defining a SO number over 1000. We always use the next available number in the sequence, and the last number was 34917. I needed to manually create a specific sales order number, so I bumped that 1000 up to 100000. This let me type in any SO number under 100k.
Great! That worked for my test. But now, the sales order person is showing me that when they create a new sales order it defaults the number to next after the sequence range I input. So it gave her SO# 100001, then 100002. I supposed this is to be expected, and I should have fixed it after my test.
I thought I could just change the starting order number back to 1000, and her default sales order number would again go back to the next in the list. However, that never happens, it still defaults to the next number after 100000. (Saved, closed,reopened…) We can manually set the sales order number, but they never had to do that before, and I hate to think a careless mistake on my part is going to cause them to have to manually input every sales order number now.
I am hoping there is a conversion or process I can run that refreshes Epicors next available sales order number, so that 34918 is the next in the series, instead of 100003.
I believe that there is an internal counter BO epicor uses to track things like the “last sales order number” which is decoupled from the setting in company maintenance, i think the bo is called nextnum, let me poke around to find it, but you need to alter the sequence number stored in it.
Thar she blows! I was wondering why I wasn’t finding it in SysSequence or SysBigSequence! too many sequence tables. Thank you sir!
(I wonder what happens when your sequence eventually reaches the existing numbers created. You may want to leave a note to the future-you to adjust the sequence counter up above the max ordernum when it gets into the 100ks )
I don’t have this table available in my BAQ tables. Is there any way to edit that value? Would I need to UBAQ it, or should I ask support to intervene?
Since the Sales Order Number is a key field, any attempt to mess with the guardrails could corrupt your database… and leave you liable for a “termination of service” notice from Epicor (meaning they won’t help you fix it).
)