Customer Deliveries Mail Shot

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, 2024, on the Swan Retail knowledge base (FRS).

Part of: Management Reports


This report is designed to be used in partnership with a spreadsheet or mail shot routine and provides a list of products delivered to a customer within a given timescale.

Crystal report name Customer Deliveries Mail Shot 4

Customer Deliveries Mail Shot All 4 is available without the location restriction.

This output is designed to be used as an import to a spreadsheet and as such may not be presented on screen as viewed in a spreadsheet.

Selection Criteria

Run time choices, user selectable.

  • Date Range

  • Supplier (Vendor) Name

  • Range (Collection) Name

  • Include Customers with Accept Mail Set

    • Yes / No

  • Include Customers with Accept Email Set

    • Yes / No

  • Include Customers with Accept Phone Set

    • Yes / No

  • Include a Header Row

    • Yes / No

  • Restricted Selling Location(s)

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 Title

  • Customer Initials

  • Customer Surname

  • Master Customer Address Line 1 to 5

  • Postcode / Zipcode / Eirecode

  • Telephone

  • Mobile / Cell

  • Daytime telephone

  • Email Address

  • Sales Order Number

  • Delivered Quantity

  • SKU

  • Model Number

  • Range / Collection

  • Supplier / Vendor

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

  • Delivery Date

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