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.
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
Feedback sent
We appreciate your effort and will try to fix the article