Customer Purchases Mail Shot (1214 onwards)

Created by Migration Bot, Modified on Fri, 23 Oct at 11:26 AM by Migration Bot

Originally written by John Hardwick, last updated Apr 29, 2026, on the Swan Retail knowledge base (FRS).

Part of: Sales Reports


The report is designed to produce a listing of customer’s names and addresses in a format able to be loaded into a mail merge type routine. Filters on the report allow the list to be limited to purchases from specific suppliers / ranges within a date range, and to filter by mail preference.

The output of this report is designed to feed into other systems and therefore may not display accurately within the browser

Crystal Report name Customer Purchases Mail Shot 17

Customer Only Format

See image above

Customer & Sales Format

This output may produce several lines for a single customer.

The report uses the ‘Tax Inclusive’ setting held against the selling location to show tax inclusive or exclusive selling prices.

Selection Criteria

Run time choices, user selectable.

  • Date Range

Enquiry Customer is the group assigned to all customers who have not purchased within FRS

These customers will not have order details in the data extract.

  • Supplier / Vendor

  • Range / Collection

Use the * character as a wildcard when selecting the range.  For example, A* reports on all ranges beginning with A.

Leave set to * to ignore this field

  • Include Customers with Mail Flag set

    • Yes / No

  • Include Customers with Email Flag set

    • Yes / No

  • Include Customers with Accept Phone Calls Flag set

    • Yes / No

  • Include Header Row

    • Yes / No

  • Restricted Location(s) - Sales Location

Print Sequence

As indicated by blue numbered squares in the report example.

1 Customer ID

2 Sales Order Number (Customer & Sales Format Only)

Report Totals

As indicated by yellow numbered squares in the report example.

  • There are none.

Printed Fields

Fields printed on the report.

  • Customer

    • Title

    • Initials

    • Surname

    • Address lines 1 to 5

    • Postcode (Zipcode / Eire Code)

    • Main Telephone

    • Mobile / Cell Phone

    • Daytime Phone Number

    • Email Address

    • Customer ID

  • Customer Types (1 to 6)

  • Sales Order Location

When processing in Sales & Orders format (and for none Enquiry Customers), additional column are

  • Sales Order Number

  • Quantity Purchased

  • SKU

  • Model Number

  • Product Description

  • Range / Collection (debranded, where applicable)

  • Supplier / Vendor (debranded, where applicable)

This Report will show the debranded catalogue supplier or the debranded supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)

  • Product Group

  • Sales Order Date

  • Source of Business

  • Sales Order Value

  • Primary Salesperson

  • Secondary Salesperson

  • Line Level Salesperson

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article