Cancelled Sales (1214 onwards)

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

Originally written by John Hardwick, last updated Mar 26, 2026, on the Swan Retail knowledge base (FRS).

Part of: Sales Reports


This report allows the viewer to establish why orders / order lines are being cancelled.

image-20250407-132414.png

Crystal report name Cancelled Sales 6

The report calculates the number of days from the point of raising the sales order to the cancellation occurring.  If the number of days exceeds the specified number, the routine highlights the Days field showing a red background.

If a line on the sales order is cancelled but not the entire sale, the audit shows ‘lines’ in the type column.  If the entire order was cancelled, the field reads ‘Order’.

The report shows a Q prefixing the sales order number if saved as a quotation.

Selection Criteria

Run time choices, user selectable.

  • Date Range - Cancellation Date

  • Group by

    • Primary Salesperson / Cancelled by Operator / Ordering Location / Cancellation Reason

  • Restricted Location(s) - Sales Location

  • Include

    • Cancelled Sales Only / Cancelled Sales Order Lines Only / Both

  • Highlight Cancellations processed X or more days after order placement

  • Include Tax in Selling Price

    • Yes / No

  • Include

    • Cancelled Sales Only / Cancelled Quotations Only / Both

  • Include Item Option Amendments

    • Yes / No

An Item Option Amendment occurs when a product group linked to a SKU has the ‘can assemble’ ticked. This enables the changing of an option at any time up to the point of item scheduling. If the options on a stock item change, this is deemed to be an item option amendment, which will effectively cancel the original item and create a new one. If set to Yes, this report will show these changes, if set to No, the report will omit them.

Print Sequence

As indicated by blue numbered squares in the report example.

1 Selected ‘Group by’

2 Sales Order Number

Report Totals

As indicated by yellow numbered squares in the report example.

1 Sales Order (where applicable)

2 Selected 'Group By'

3 Report Totals

Printed Fields

Fields printed on the report.

  • Primary Salesperson / Cancellation by / Ordering Location or Cancellation Reason

  • Quotation / Estimate Indicator

  • Sales Order Number

  • Sales Order Date

  • Stock Number

  • SKU

  • Quantity Cancelled

  • Price (Inc or Ex of tax)

  • Cancellation Date

  • Cancellation Reason

  • Days Elapsed between ordering and cancellation

  • Sales Order or Order Line Cancelled Indicator

  • Number of Sales Cancelled

  • Number of Orders Cancelled

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