Serial Numbers

(0) Share

Report

Posted on by Community Member

We are trying to receive a PO to the warehouse. There are serialized items on the PO, the manuf. sent us the serial numbers, but were not scanned and received. So, we have to receive them manually.

The question is, is there a way to upload the serial numbers from a spreadsheet, instead of keying in 80 serial numbers?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report

RE: Serial Numbers

If the serial numbers are sequential, you can 'auto-generate' them

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: Serial Numbers

No, you need custom solution. we have done this customization for one of our client.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Serial Numbers

How do they auto generate if I have a list of them from the manufacturer?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Serial Numbers

On the Purchasing serial number entry screen, you could enter the quantity to generate - enter the starting serial number (ie 20) and enter a serial number mask (ie 0000001) then click on 'auto-generate'. All the serial numbers will then be created

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Serial Numbers

It looks like I cannot choose alphanumeric value... I can either choose Numeric or Alpha...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Serial Numbers

Are your serial numbers always in the same format? ie AAA123BBB456? You could make segments out of the serial number and then do the auto-generate....

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Serial Numbers

The format could be the same, but they are not in sequential order. One could be 8567432RVM, the second would be 856892432BB

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (1)

Report

RE: Serial Numbers

Hi,

It sounds like you just need to use integration manager to import these transactions. If you do not own IM, you can use the Mail-Merge technique to create a Macro that will do the transaction for you.

Kind regards,

Lesllie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Serial Numbers

Thank you very much for the information. This is very helpful

And thanks to everyone who proved helpful answers.

Was this reply helpful? Yes No