Exporting Inventory

Section 11: Exporting Data > Data Exports from Main Modules

Exporting Inventory

This data export includes all records from the main Inventory module (see Inventory).

The data export defaults to the comma-delimited (.csv) file format. It may be filtered by inventory location, category, purchase vendor, make, model, whether to exclude inactive inventory items, and whether to include only low- and minimum-stock inventory items.

Export Option Fields

Field	Description
Inv. Location	Enter or select the inventory location for which to export data or leave blank for all inventory locations.
Category	Enter or select the inventory category for which to export data or leave blank for all inventory categories.
Vendor	Enter an assigned purchase vendor account number for which to export data, 0 for miscellaneous vendor accounts, or leave blank for all vendors. Optionally, select the purchase vendor name for which to export data. The entered vendor filter may match any of the three purchase vendors configured for an inventory item (see Inventory Item - Vendors Tab).
Make	Enter or select the make for which to export data or leave blank for all makes.
Model	Enter or select the model for which to export data or leave blank for all models.
Exclude Inactive Items	Check this box (the system default) to exclude inactive inventory items, or uncheck this box to include inactive inventory items (see Inventory Overview for a definition of inventory items with an “inactive” inventory status).
Include only Low- and Minimum-Stock Items	Check this box to include only low- and minimum-stock inventory items, or uncheck this box (the system default) to ignore the in-stock status of all inventory items (see Inventory Overview for a definition of inventory items with a “low-stock” or “minimum-stock” inventory status).

Exported Fields

AYS Field	Exported Field	Type	Notes
Part Number	PartNumber	Text	Unique system part number of the inventory item
Location	Location	Text	Business location ID for the inventory store to which this item belongs (Shared for the shared inventory store)
Share Part Information Between Locations	Share	Text	True if the inventory item descriptions, purchase vendor information, and make and models information are all shared between the same part number in different inventory stores, otherwise False
Item Description	ItemDescription	Text	Item description
Category	Category	Text	Inventory category
Primary Vendor	VendorNo1	Number	Purchase vendor account number for supplier 1
Vendor Part No	VendorPartNo1	Text	Equivalent part number for supplier 1
Other Vendor	VendorNo2	Number	Purchase vendor account number for supplier 2
Vendor Part No	VendorPartNo2	Text	Equivalent part number for supplier 2
Other Vendor	VendorNo3	Number	Purchase vendor account number for supplier 3
Vendor Part No	VendorPartNo3	Text	Equivalent part number for supplier 3
Make	Make	Text	Make of inventory item
Models	Models	Text	Vertical-bar-delimited (\|) list of models on which the inventory item is used
Storage Bin	StorageBin	Text	Bin in which the inventory item is located
Quantity In Stock	QuantityInStock	Number	Quantity of inventory item in stock
Minimum Required	MinimumRequired	Number	Minimum quantity recommended to be in stock
Prev. Purchase Price	PreviousPurchase Price	Number	Second-last purchase price of inventory item
Last Purchase Price	LastPurchasePrice	Number	Last purchase price of inventory item
Avg. Purchase Price	AveragePurchase Price	Number	Average purchase price of remaining items in stock
MarkupRate	MarkupRate	Number	Markup rate in percentage (0 for no markup)
Selling Price	SellingPrice	Number	Selling price of inventory item
Notes	Notes	Text	Notes for the inventory item

Exporting inventory is available only in the Repair SQL, Repair, and Repair Mobile editions. The additional export options are available only for licensed users of version 2.7 and higher.

Exporting Serialized Inventory