Customer Master List

From FloristWiki

Jump to: navigation, search


If you are using Mercury Connect with FTD Mercury X3 Fall or later, reports are handled through Report Center.

The Customer Master List provides you with a list of all your customers, as well as their current balance information, and house account information such as their credit limit and discount amount. This report may take several minutes to print, depending on the size of your customer database.

Generating the Customer Master List

To generate the Customer Master List:

  1. On the FTD Mercury Main Menu, click Business Reports.
  2. Double-click on the Customer Master icon to open the template.
  3. If a window opens asking whether you wish to enable or disable macros, click Enable Macros.
  4. If you receive the message “This application is about to initialize ActiveX controls...” click OK.
  5. In the Store of Origin field, click the arrow and select the store’s data that you want to use for the report.
  6. In the Please select payment type section, click in the check boxes so check marks appear for any combination of payment types you wish to include in this report.
  7. If you want to print customers with particular marketing types, click Marketing Criteria Selection so that a check mark appears (otherwise leave this option unchecked). This allows you to filter customer information so that, for example, you can print only Business accounts in the report. (If this area is blank, it means that you have no marketing categories set up. See Marketing Screen|Marketing Screen for information on setting up these categories.)
    To select marketing categories to print, first click on a category so that a drop-down arrow displays. Click this arrow to display a drop-down list of marketing types. Then check which types you want to print.
    To print only customers with no marketing information specified in the Customer Detail Information window, first check the Marketing Criteria Selection option so that a check mark appears, then check Customers with No Marketing Criteria.
  8. In the Sort Option section, choose whether you wish to list customers according to Default Pay Method, Last Purchase Date, or Name. If you select to sort by last purchase date, specify the last purchase date by clicking the down arrow in the date field and selecting the date from the calendar.
  9. Click Finish. The report generates and opens in Excel.
  10. To print your report from Excel, on the File menu, click Print.
  11. If you want to save the report from Excel, on the File menu, click Save.

Customer Master List Window

The Customer Master List window enables you to configure settings for the Customer Master List report. When you have finished configuring the settings, click Finish to generate the report. It will open in Microsoft Excel.

The Customer Master List window contains the following settings:

Setting Description
Store of Origin From this list, select the store with which the customer is associated. If you have multiple stores, you can select All Stores.
Payment Types Select the payment type(s) you want to include in the report. You can select Cash, Check, Credit, Debit, House, or Gift Certificate.
Marketing Criteria Selection If you select this option, you can filter the report so it includes customers with specific marketing criteria or no marketing criteria. If you select Customers with Marketing Criteria, you can select the marketing categories to include.
Sort Option You can select to sort the report by the Default Pay Method, the Last Purchase Date (requires you specify the date), or by Name.

Back to Business Reports

Personal tools