This data import will import serial numbers for existing records in the main Inventory module (see Inventory).
Imported Fields
AYS Field |
Field Name Matching |
Notes and Data Validation |
Part Number |
PartNumber, Part, or Code |
Part number of an existing inventory item. A text string of up to 30 characters. It is a required field and may not be empty. |
Location |
Location or Loc |
Business location ID for the inventory store to which the inventory item belongs. This field is only imported if multiple business locations have been set up (see Business Locations). |
Serial Number |
SerialNumber or Ser |
Unique serial number for the inventory item. A text string of up to 20 characters. It is a required field and may not be empty. |
If an existing record with matching data from both the part number field and the location field is found then the serial number will be added to that record.
Importing inventory serial numbers is available only for licensed users of version 3.1 and higher, and is available only in the Repair SQL and Repair editions.
(See also Importing Inventory, and Exporting Serialized Inventory.)
More: