Start Auto Sequence Item with Already Opened Item Sequence
We're looking for some guidance on our item code generation process. We're currently creating new item code rules based on a combination of our "Major Category Code" and "Minor Category Code."
Our current item code structure looks something like this:[PREFIX] - [Major Category]-[Minor Category]-[Sequence Number].
For instance, you might see codes like:
7251-001-0001-0001
7251-001-0001-0002
7251-001-0002-0001
The challenge we're facing is that the sequence number (the last part, e.g., -0001, -0002) restarts from '1' for each new unique combination of Major and Minor Category.
Our main question is: When we define these new item code rules in the system, how do we tell the system what the starting sequence number should be for each specific Major/Minor Category combination?