Skip to main content
Question

SKU number generator

  • January 17, 2019
  • 0 replies
  • 55 views
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 following results as it is still dependant on the RecordID:

8652674-210-001
8557-233-002
CC-220-003

This is my code:

(
& "-" &
[Equipment Type] & "-" 
& Right("000" & ToText([Record ID#]),3))

I want to be able to create the SKU number based on the sequential # of that specific number type. Hence, the ideal results would be for the number to automatically generated, given the condition that it is the same type of item.

8652674-210-001, 8652674-210-002, 8652674-210-003....
8557-233-001, 8557-233-002, 8557-233-003...

Any help or idea to implement this would be greatly appreciated!

Thank you.



This topic has been closed for replies.

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..
Terms & ConditionsAccessibility statement