Duplicate Customer Addresses

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

Part of: Management Reports

This audit helps identify customers with duplicate data.

Selection Criteria

Run time choices, user selectable.

• Compare Method

  • House Number & Postcode / First Line of The Address / Surname, House Number and Postcode / Email Address / Mobile Number / Main Telephone / Daytime Telephone

• Include Blank Addresses

  • Yes / No

• Exclude Customer with Email Unticked

  • Yes / No

• Exclude Customers with Post Unticked

  • Yes / No

• Exclude Customers with Tel Unticked

  • Yes / No

• Customer Types 1 to 6

Print Sequence

As indicated by blue numbered squares in the report example.

1 Location (Where selected)

2 Delivery Date

Report Totals

As indicated by yellow numbered squares in the report example.

1 Delivery Date

2 Location (Where selected)

3 Report

Printed Fields

Fields printed on the report.

• Location

• Slot Sequence / Time

• Vehicle / Truck

• Start Time

• Route

• Delivery Postcode

• Run Number

• Number of Sales Orders

• Number of Unavailable Slots

• Number of Unallocated Slots

• Percentage Unavailable

• Percentage Free

• Percentage Utilised

• Barchart

Attachments (1)

image-20230323-093531.png
146 KB