Section 10: Importing Data > Data Imports for Main Modules

Importing Inventory Serial Numbers

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:

Importing New Repair Orders