Mass Generate Serial Numbers

When a serialized part is purchased, we supply a serial number sequence for the supplier to produce the raw materials. This can be up 1,000 serial numbers. Looking for a workflow/process to pre-generate the serial numbers for these parts at time of PO Entry and hold them for Receipt when they arrive.

It appears that this can only be done at time of Receipt Entry and I would like to happen sooner.

When do you know the S/N’s you expect to get? How is it that info given to the supplier and who is responsible? Do you know the S/N’s when the PO is entered?

Correct, we know the S/N at the time of PO, they supply a range of numbers for every order being placed. The parts can be received the next day or the next month. The supplier is just handed a list of the S/N to use for the order and it usually supplied by the Buyer.

Are they always sequential, like “1001 thru 1500” (for 500 parts)?

Or can the be non-sequential like “1000, 1001, 1002, 1010, 1011, 1012, 1013, 1020, 1021, …” (notice the irregular gaps)?

The PO Receipt of Serialized parts lets you generate the S/N’s when receiving the line.

And it is better to create the S/N’s received, than to assume they match the ones you requested. Unless you’re trying to add a check that the S/N’s received, match those requested.

Correct, is there a way to generate the numbers before receipt and at time of PO Entry.

Nothing standard. I’ve done this in E9 as a customization to PO Entry. Basically "generate serial #‘s’ will go through and create serial #'s using the standard serial# logic/mask, and set them as ‘adjusted’. Then change them all to another status that can be selected at receipt entry.

I don’t think you can create a S/N for a “yet to be received” part, for selecting during PO Receipt Entry. Only on parts to be manufactured.