Lapsed Customer Report

Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).

Part of: Management Reports

This report is designed to show customers who have not purchased for a specified number of months and is designed to provide an output suitable to be sent to a third party mail merge or spreadsheet.

If a customer has purchased more than once, the last ordering location will be displayed on the audit.

Selection Criteria

Run time choices, user selectable.

• Number of Months Lapsed

• Include Customer who have never ordered

  • Hide / Show

• Restricted Selling Location(s)

• Include Over Values exceeding

Print Sequence

As indicated by blue numbered squares in the report example.

1 Location

2 Last Order Date

Report Totals

As indicated by yellow numbered squares in the report example.

• There are none.

Printed Fields

Fields printed on the report.

• Customer’s Full Name

• Customer’s Master Address

• Postcode / Zipcode / Eirecode

• Order Total

• Order Location

Attachments (1)

image-20230323-102951.png
25.4 KB