Serial number import Atrex v12 or PO -> Receive -> Load from File

Hi,

I have the S/Ns of several stock code in a csv file.

Sample...

APPLE PSU 60W.MS2,RR7628607118E

APPLE PSU 61W.USBC,C4H611063PWGN8R2H

APPLE PSU 61W.USBC,C4H611063PWGN8R4E

APPLE PSU 61W.USBC,C4H611063PWGN8R23

DELL PSU 65W 4.5MM,CN-0MGJN9-72438-49Q-5160

DELL PSU 65W 4.5MM,CN-0MGJN9-72438-49Q-5113

DELL PSU 65W 4.5MM,CN-0MGJN9-72438-49Q-5119

Is this the correct format of the file?

I've been attempting PO -> Receive -> Load from File feature for over 5yrs and never got it to work.

It does garbage for the Qty Received, like qty received for 3rd item may be 45635348983

I've also tried Options -> Import -> Serial Numbers,

which do load the S/Ns but then how do I assign them to a PO ?

Mark Culos Replied

4/28/2021 at 10:33 AM

Employee Post

Sega,

The Load from File function does not allow you to specify serial numbers. The ability to supply a delimited list of serial numbers on the Serial Number Processing window while receiving a PO was added in Atrex 16.

Sega Replied

4/28/2021 at 11:01 AM

Oh!

1) So after u created a PO then later go PO -> Receive.

What does the "Load from File" option does?

2) When u import the SNs via Options -> Import how do u assign them to a PO ?

Terry Swiers Replied

4/28/2021 at 1:14 PM

Employee Post Marked As Answer

The load from file during PO receiving allows you to receive the quantities for non-serialized items from a file rather than manually receiving them.

Importing serial numbers via the Options - Import function adds the serial numbers directly to the database. You cannot associate them with a PO number using that method.

3 Replies

Reply to Thread

Related Knowledge Base Articles