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: