MULTIPLE ADDRESS EXPORT FOR VENDORS

MULTIPLE ADDRESS EXPORT FOR VENDORS

To use this feature you need to create a schema for exporting vendors and all of the addresses for each. 

First go to Admin Switchboard >> Excel Import/Export tab >> Click Export Vendors

Next, Vendors Export screen will show.

Select Create Schema

Note: COMPANY_NAME is already checked

To enable box for Multiple Adress you can click on all options EXCEPT the following:

ACCOUNT_NO

FEDERAL_TAX_ID

CUSTOMER_FIELD_1

CUSTOMER_FIELD_2

CUSTOMER_FIELD_3

Next, create Name for schema

Select File Extension

Type should be Vendors

Check the box for Multi-Address

Click on Save

 Now that you have created a schema, you are now ready to export.

To export, on Ready To Export tab:

Note: Make sure that Export Type is VENDORS

Select File Folder location

Create File Name

Select Schema created to export customers that would include all addresses for each

You may also select Search Filter according to what order the list  will be placed

If everything is set, click on Export

SAMPLE RESULT:

Attachments (MULTIPLE ADDRESS EXPORT FOR VENDORS.pdf)