Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report produces a customer export data file (similar to Customer Export) with the addition of saved customer interactions.
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 Interactions Export 1
The example has the header row included.
Selection Criteria
Run time choices, user selectable.
-
Customer Interaction(s)
-
Show Separate Title, Initials and Surname
-
Yes / No
-
-
Restricted Location(s)
-
Include Header Row
-
Yes / No
-
-
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
-
-
Consolidate Customers
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Sales Order Date
2 Sales Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
-
There are none.
Printed Fields
Fields printed on the report.
-
Customer
-
ID
-
Title
-
Initials
-
Surname (or Title, Initials and Surname printed as a single field if selected)
-
Address lines 1 to 5
-
Postcode (zip code / Eircode)
-
Last Location to take an Order
-
Main Telephone
-
Mobile / Cell Phone
-
Daytime Phone Number
-
Email Address
-
Email Preference Indicator
-
Post Preference Indicator
-
Phone Call Preference Indicator
-
-
Interactions Description
The output may replicate customers showing the customer repeated for each purchase location, or when consolidated the customer is listed once irrespective of how many locations they may have purchased from historically (the most recent purchase location is used in this mode).
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article