Customer Purchases

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

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

Part of: Sales Reports


The report produces a listing of all goods sold for the selected supplier(s)/range(s) for a given date range, showing the items sold and where selected associated goods on the sales order.  It was designed to inform a ‘fitter’ of other goods and services sold on the sale in addition to the item being fitted, but may be used for other purposes.

Crystal Report name Customer Purchases 13

The example shown above includes additional order lines on each sales order within the information box.  When instructed to omit associated order lines, this box is not displayed.

Selection Criteria

Run time choices, user selectable.

  • Date Range

  • Show Order Lines

    • Yes / No

  • Supplier / Vendor

  • Range / Collection

  • Restricted Location(s) - Selling Location

  • Exclude Customers with purchases in the last X Days

  • Include

    • All Order Lines / Undelivered Lines Only / Delivered Lines Only

  • Customer Filter

Print Sequence

As indicated by blue numbered squares in the report example.

1 Supplier / Vendor

2 Range / Collection

3 Sales Order Date

4 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.

  • 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)

  • Range / Collection

  • Sales Order Date

  • Delivery Indicator

  • Sales Order Number

  • Full Customer Name

  • Customer’s Address

  • Customer’s postcode (Zipcode / Eirecode)

  • Customer’s Telephone Number

  • Quantity Ordered

  • SKU

  • Model Number

  • Product Description

  • Other Products (Associated products)

    • SKU

    • Model Number

    • Quantity

    • Range / Collection

    • Description

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