take the first three digits of the supplier number and then auto generate the next three digits was my thought while still somehow dealing with duplicates. a bit surprised it’s not built in