This data export includes all serialized records from the main Inventory module including serial numbers and the repair order and sales invoice records to which those serial numbers are assigned (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, and whether to include only assigned or unassigned serial numbers.
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. |
Serial Numbers |
Select whether to include all serial numbers (the system default), only assigned serial numbers, or only unassigned serial numbers. |
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) |
Serial Number |
SerialNo |
Text |
Serial number |
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 |
Number |
Second-last purchase price of inventory item |
Last Purchase Price |
LastPurchasePrice |
Number |
Last purchase price of inventory item |
Avg. Purchase Price |
AveragePurchase |
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 |
|
LinkedFormType |
Text |
R for repair order, or S for sales invoice |
Repair Order Number or Sales Invoice Number |
LinkedFormNo |
Number |
The repair order number or sales invoice number of the record to which the serial number is assigned |
Exporting the serialized inventory is available only for licensed users of version 3.1 and higher, and is available only in the Repair SQL, Repair, and Repair Mobile editions.
(See also Exporting Inventory, and Importing Inventory Serial Numbers.)
More: