Section 11: Exporting Data > Data Exports from Main Modules

Exporting Serialized Inventory

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
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

 

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:

Exporting Service Codes