Originally written by John Hardwick, last updated Apr 09, 2026, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
The report is designed to produce an output file in a format Stainguard can load into their warranty systems. The data file produced may be used for other providers where appropriate
Crystal report name Delivered Warranty Orders 1
To be included orders must have been delivered within the specified date range and contain at least one order line with the text ‘Warr’ in either the product description (1, 2 or 3) or its associated product group description.
Selection Criteria
Run time choices, user selectable.
-
Sales Date Range
-
Supplier / Range / SKU selection - Offerings restricted to products or product groups with the text ‘Warr’ in their description.
Print Sequence
As indicated by blue numbered squares in the report example.
1 Sales Order Number
Report Totals
There are none.
Printed Fields
Fields printed on the report.
-
Sales Order Number
-
Customer Title
-
Customer Initials
-
Customer’s Surname (last name)
-
House Number
-
House Name
-
Flat Number
-
Address line 1 to 5
-
Postcode
-
Telephone Number
-
Daytime Telephone
-
Mobile
-
Sales Location
-
Sales Order Date
-
Confirmation (Delivery) Date
-
Invoice Number
-
Is Warranty (has Warr in description)
-
Supplier / Vendor
-
Range / Collection
-
SKU
-
Model Reference (Supplier’s Code)
-
Product Group Description
-
Product Description 1,2 & 3
-
Delivery Quantity
-
Cost Price
-
Final Discounted Selling Price
-
VAT
-
Width
-
Order Total (Sales Order Value)
-
Sales Order Pad Reference
-
Sales Department 1,2 & 3
-
Service Indication
-
Option Details
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