I am working on a situation where there are 3 different Sales Order Types with their distinct prefixes:
I know I can set up separate No Series for each of these types, but what if I want them to share the same numerical sequence? For instance:
- EQ046027
- PG046028
- TC046029
- PG046030
I don't see anywhere in the No. Series setups or Relationships where I can choose one as the "master" for shared numerical sequencing, then just add the correct prefix based on the selected Series.
Only thing I can think of is to setup each No. Series separately with the same numerical ranges, and add some AL Code and synchronize the Last Date Used and Last No. Used values for each Series every time a new Sales Order is entered.
Is there a better way that I am overlooking?