This data export includes all records from the main Vendors module, except for vendor contacts (see Vendors).
The data export defaults to the comma-delimited (.csv) file format. It may be filtered by vendor type, and whether to exclude inactive vendor accounts.
Export Option Fields
Field |
Description |
Vendor Type |
Select whether to include all vendors (the system default), only repair vendors, or only purchase vendors. This export option is available only in the Repair SQL, Repair, and Repair Mobile editions. |
Exclude Inactive Vendor Accounts |
Check this box (the system default) to exclude inactive vendor accounts, or uncheck this box to include all vendor accounts. |
Exported Fields
AYS Field |
Exported Field |
Type |
Notes |
Vendor No. |
VendorNumber |
Number |
Unique vendor account number |
Vendor Name |
VendorName |
Text |
Vendor name |
Vendor Account |
VendorAccount |
Text |
Account number assigned by vendor |
Quick Code |
QuickCode |
Text |
Unique vendor quick-entry code |
Inactive |
Inactive |
Text |
True if the vendor is inactive, otherwise False |
Contact Name |
ContactName |
Text |
Contact name of vendor |
Address Line 1 |
AddressLine1 |
Text |
Address line 1 of vendor |
Address Line 2 |
AddressLine2 |
Text |
Address line 2 of vendor |
City |
City |
Text |
City of vendor |
Province/State |
State or Province (see Americanized Spelling) |
Text |
Province/state of vendor |
Postal/Zip Code |
ZipCode or PostalCode (see Americanized Spelling) |
Text |
Postal/zip code of vendor |
Country |
Country |
Text |
Country of vendor |
Business Phone |
BusinessPhone |
Text |
Business phone number of vendor |
Toll-Free Phone |
TollFreePhone |
Text |
Toll-free phone number of vendor |
Fax |
Fax |
Text |
Fax number of vendor |
|
|
Text |
E-mail address of vendor |
Web Site |
WebSite |
Text |
Web site address of vendor |
Reference 1 |
Reference1 |
Text |
Default reference 1 for this vendor |
Reference 2 |
Reference2 |
Text |
Default reference 2 for this vendor |
Ship Via |
ShipVia |
Text |
Default shipping method for this vendor |
Language |
Language |
Text |
Default language for correspondence with this customer (E for English, F for English/French, or S for English/Spanish) |
Accepts Subcontracted Repairs |
AcceptRepairs |
Text |
True if repairs can be subcontracted to this vendor, else False This field is available only in the Repair SQL, Repair, and Repair Mobile editions. |
Accepts Purchase Orders |
AcceptPurchases |
Text |
True if parts can be purchased from this vendor, otherwise False This field is available only in the Repair SQL, Repair, and Repair Mobile editions. |
Only One Make |
OnlyOneMake |
Text |
True if this vendor only sells parts for a single make, otherwise False This field is available only in the Repair SQL, Repair, and Repair Mobile editions. |
Default Make |
DefaultMake |
Text |
Default make for this vendor This field is available only in the Repair SQL, Repair, and Repair Mobile editions. |
Number of days after which purchase orders for this vendor automatically change to Backordered status |
BackorderDays |
Number |
Number of days after which newly ordered purchase orders for this vendor will automatically be changed to the status of backordered (0 for no automatic status change) This field is available only in the Repair SQL, Repair, and Repair Mobile editions. |
Notes to Print |
NotestoPrint |
Text |
Printable notes for the vendor |
Copy these notes to all Subcontracted Repair Orders and new Purchase Orders for this Vendor |
CopyNotestoPrint |
Text |
True if notes to print from this vendor are to be copied to other notes to print fields, otherwise False |
Private Notes |
PrivateNotes |
Text |
Private notes for the vendor (not to be printed) |
Copy these notes to all Subcontracted Repair Orders and new Purchase Orders for this Vendor |
CopyPrivateNotes |
Text |
True if private notes from this vendor are to be copied to other private notes fields, otherwise False |
The miscellaneous vendor account (i.e. vendor account 0000000) is not included in the data export.
The additional export options are available only for licensed users of version 2.7 and higher.
(See also Exporting Vendors with Contacts, Importing Vendor Contacts, Exporting Vendor Contacts, Exporting Vendor Accounts to QuickBooks, Importing Vendors, Importing Vendor Contacts, and Importing Vendor Accounts from QuickBooks.)
More: