Serial number import Atrex v12 or PO -> Receive -> Load from File
Question asked by Sega - 4/28/2021 at 9:33 AM
Answered
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 ?

3 Replies

Reply to Thread
0
Mark Culos Replied
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.
0
Sega Replied
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 ?
1
Terry Swiers Replied
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.

Reply to Thread