Section 10: Importing Data > Data Imports for Main Modules

Importing Inventory

This data import will import records for the Inventory main module (see Inventory).

Imported Fields

AYS Field

Field Name Matching

Notes and Data Validation

Part Number

PartNumber, PartNo, Part, or Code

Unique system part number of the inventory item. A unique text string of up to 30 characters for licensed users of version 3.0 and higher, or up to 20 characters for all other versions. It may not begin with an asterisk (*) or a percent sign (%). It is a required field and may not be empty.

Location

Location or Loc

Business location ID for the inventory store to which this item belongs. Any other values will default to Shared. This field is only imported if multiple business locations have been set up (see Business Locations).

Share Part Information Between Locations

Share

Whether or not the inventory item descriptions, purchase vendor information, and make and models information are all shared between the same part number in different inventory stores. A logical Yes or No value. Acceptable values include Yes, No, True, or False. This field is only imported if multiple business locations have been set up (see Business Locations).

Item Description

ItemDescription, Description, Desc, or Item

Item description. A text string of up to 120 characters. It is a required field and may not be empty.

Category

Category, Cat, or Ctgy

Inventory item category. A text string of up to 20 characters.

This field will only be imported for licensed users of version 3.0 and higher.

Primary Vendor

VendorNumber1, VendorNo1, VendNo1, Vendor1, Vend1, PrimaryVendor, or First

Purchase vendor account number for supplier 1. A vendor number from 0 to 9999999 or an alphanumeric vendor quick code of up to 7 characters. The vendor record must already exist. A vendor number of 0 means a miscellaneous vendor.

Vendor Part No

VendorPartNumber1, VendorPartNo1, PartNo1, or Part1

Equivalent part number for supplier 1. A text string of up to 30 characters for licensed users of version 3.0 and higher, or up to 20 characters for all other versions.

Other Vendor

VendorNumber2, VendorNo2, VendNo2, Vendor2, Vend, or Second

Purchase vendor account number for supplier 2. A vendor number from 0 to 9999999 or an alphanumeric vendor quick code of up to 7 characters. The vendor record must already exist. A vendor number of 0 means a miscellaneous vendor.

Vendor Part No

Vendor Part Number 2 or Vendor Part No 2 or Part No 2 or Part 2

Equivalent part number for supplier 2. A text string of up to 30 characters for licensed users of version 3.0 and higher, or up to 20 characters for all other versions.

Other Vendor

Vendor Number 3 or Vendor No 3 or Vend No 3 or Vendor 3 or Vend or Third

Purchase vendor account number for supplier 3. A vendor number from 0 to 9999999 or an alphanumeric vendor quick code of up to 7 characters. The vendor record must already exist. A vendor number of 0 means a miscellaneous vendor.

Vendor Part No

VendorPartNumber3, VendorPartNo3, PartNo3, or Part 3

Equivalent part number for supplier 3. A text string of up to 30 characters for licensed users of version 3.0 and higher, or up to 20 characters for all other versions.

Make

Make

Make of inventory item. A text string of up to 30 characters.

Models

Models or Model

List of models on which the inventory item is used. A list of models separated by the vertical bar (|) character up to a total of 250 characters. Each model can be up to 40 characters. If no vertical bars are included then the single model will be appended to any existing models. If a single model has a leading or trailing vertical bar then it will replace the existing list of models.

Storage Bin

StorageBin or Bin

Bin in which the inventory item is located. A text string of up to 20 characters for licensed users of version 2.7 and higher, or up to 10 characters for all other versions.

Quantity In Stock

QuantityInStock, Quantity, Qty, InStock, or Stock

Quantity of inventory item in stock. A number from -99999.9999 to 99999.9999.

Minimum Required

MinimumRequired, Minimum, Min, Required, or Req

Minimum quantity recommended to be in stock. A number from -99999.9999 to 99999.9999.

Prev. Purchase Price

PreviousPurchasePrice, PrevPurchasePrice, PrevPurchPrice, PreviousBuyPrice, PreviousPrice, PrevBuyPrice, PrevPrice, Previous, or Prev

Second-last purchase price of this inventory item. A monetary amount from -999999.99 to 999999.99, or from -99999999 to 99999999, depending on the number of currency decimal places specified in the Windows regional settings (see Entering Numbers).

Last Purchase Price

LastPurchasePrice, LastPurchPrice, LastBuyPrice, Last Price, or Last

Last purchase price of inventory item. A monetary amount from -999999.99 to 999999.99, or from -99999999 to 99999999, depending on the number of currency decimal places specified in the Windows regional settings (see Entering Numbers).

Avg. Purchase Price

AveragePurchasePrice, AveragePurchPrice, AvgPurchasePrice, AvgPurchPrice, AverageBuyPrice, AvgBuyPrice, AveragePrice, AvgPrice, PurchasePrice, PurchPrice, Average, Avg, or Cost

Average purchase price of remaining items in stock. A monetary amount from -999999.99 to 999999.99, or from -99999999 to 99999999, depending on the number of currency decimal places specified in the Windows regional settings (see Entering Numbers).

MarkupRate

MarekupRate or Markup

Markup rate in percentage. A percentage amount from 0.000 to 9999.999. The number 0 means no markup.

Selling Price

SellingPrice, SellPrice, or Price

Selling price of this inventory item. A monetary amount from -999999.99 to 999999.99, or from -99999999 to 99999999, depending on the number of currency decimal places specified in the Windows regional settings (see Entering Numbers).

Notes

Notes or Note

Notes for the inventory item. An unlimited text string.

 

If an existing record with matching data from both the part number field and the location field is found then that record will be updated.

All fields are processed and validated as if the data was manually entered in each field from the inventory entry module (see Editing Inventory Items). Fields are not validated for required field data as configured under inventory module options (see module option “Required Inventory Fields” under Inventory Module Options). If any required fields are missing then the user will be forced to enter them the next time the imported record is opened for manual editing.

Importing inventory is available only in the Repair SQL and Repair editions.

(See also Importing Inventory Serial Numbers, and Exporting Inventory.)

More:

Importing Inventory Serial Numbers