SKU number generator
Hi all, Is there any way I auto-generate a sequential number and include it to the SKU number without depending on the record ID? (last 3 digits) I'm still figuring things out and these are my f...
Forum Discussion
It can be done. You will need a table of item types where the key field is the item type. Then a relationship to the items.
Then a summary maximum of the increment counter portion of the SKU.
Then look that up down to the items,
Then make a snapshot of yhat lookup,
Then add 1 to it for the next item.
It�s a bunch of work to set up and awkward to get the numbering stared when you have existing data.
You will have to decide if it�s really worth spending hours getting it built and the data loaded. You would need an SKU override field to load the initial data..
Then a summary maximum of the increment counter portion of the SKU.
Then look that up down to the items,
Then make a snapshot of yhat lookup,
Then add 1 to it for the next item.
It�s a bunch of work to set up and awkward to get the numbering stared when you have existing data.
You will have to decide if it�s really worth spending hours getting it built and the data loaded. You would need an SKU override field to load the initial data..