Exporting the Customer List.

One-Time Setup

First, you’ll need to define which columns to include in the export file.  The export uses the Customer data view, so you’ll have access to most of the customer account information as well as their balance.  You will only need to set up the fields to include one time in Configuration Management.

  1. Open Configuration Management from the main File menu.
    1. 5-20-2016 4-10-44 PM
  2. Choose Customer Export under the Customer folder.
    1. Cust export
  3. Click Edit on the toolbar then select the fields to be included in the export file.
    1.  Optionally, choose a default file/location for the export file.
      1. When choosing the default location, you will also need to enter a default name for the file as well.
    1. Optionally, choose to "Include column headers" to export the field name as well.

Export Customer List

  1. Once the Customer Export list is configured (see above), a new Export Customer List menu will appear under the main File menu.

    1. 5-20-2016 4-11-34 PM
  2. Select the file/folder location to save the export file by clicking the select file ... button.

    1. 5-20-2016 4-11-56 PM
    2. Select a folder/library from the list on the left and choose a file name.  You can select an existing file and it will overwrite that file.

  3. Click Export and you will receive the following confirmation message.

    1. 5-20-2016 4-13-28 PM

After receiving the confirmation, you're done! You can now open your customer list in Excel, or any program that supports CSV files.