Exporting Vendors with Contacts

Section 11: Exporting Data > Data Exports from Main Modules

Exporting Vendors with Contacts

This data export includes all records from the main Vendors module with their corresponding 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
E-mail	Email	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
Contact Name	ContactContact Name	Text	Name of vendor contact
Title	ContactTitle	Text	Title or position of vendor contact
Business Phone	ContactBusiness Phone	Text	Business phone number of vendor contact
Mobile Phone	ContactMobile Phone	Text	Mobile phone number of vendor contact
Fax	ContactFax	Text	Fax number of vendor contact
E-mail	ContactEmail	Text	E-mail address of vendor contact

The miscellaneous vendor account (i.e. vendor account 0000000) is not included in the data export. And, depending on the selected data export format (see Data Export Formats), the main vendor information may be repeated for each vendor contact.

Exporting vendors with contacts is available only for licensed users of version 3.0 and higher, and is not available in the Repair Lite and Repair Micro editions.

Exporting Warranty Cards