Expand all | Collapse all

SKU number generator

  • 1.  SKU number generator

    Posted 01-17-2019 07:34
    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:


    This is my code:

    ([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.

  • 2.  RE: SKU number generator

    Posted 01-17-2019 12:35
    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..