Originally written by John Hardwick, last updated Jan 14, 2025, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
Based on SwanFRS release version 1211
This report shows the average time it takes to complete a sales order. i.e. the average number of days from point of the customer raising the sales order with the retailer to the date the order is first fully delivered and paid for.
SwanFRS stamps the sales order with the date it first reaches the fully completed status (all goods delivered to customer and fully paid). Any activity occurring against the sales order after this status is reached is ignored by the report therefore any returns, services or additional items are not included.
The report does not consider part deliveries - The date of completion only occurs when all items are confirmed as delivered to customer.
The delivery method used in this report relates to the ‘overall’ order delivery method set. i.e. if the order delivery method is set the ‘retailer delivery’ this is the grouping used by the report irrespective of whether there are lines on the order where alternative delivery methods were used.
Crystal report name Delivery Timings 1
Sales Order line details are shown in a blue italic font for delivered items and a maroon colour if the item is yet to be delivered.
Only fully delivered / completed sales are included in the ageing and average breakdowns. Open orders indicate the value of the sale and the number of days since it was raised.
A sales order is either open or completed - part deliveries are deemed to be open orders.
Selection Criteria
Run time choices, user selectable.
-
Sales Order Creation Date Range
-
Filter Date
-
Sales Order Date / Keyed in Date
-
-
Restricted Location(s) - Selling Location
-
Report Format
-
Selling Location / Supplier / Product Class / Product Group / Sales Department 1, 2 or 3 / Sales Departments 1 & 2 / Sales Departments 1,2 & 3
-
-
Report Detail
-
Show Order Lines / Show Orders Summaries / Totals Only
-
-
Order Delivery Method
-
Include Allowance Lines
-
Yes / No
-
-
Days Banding
This report has 4 bands. The value specified created the bands for example 30 would create the following bands -
<= 30 days
31 to 60 days
61 to 90 days
>91 days
Print Sequence
As indicated by blue numbered squares in the report example.
1 Report Grouping - Selling Location / Supplier / Product Class / Product Group / Sales Department 1, 2 or 3 / Sales Departments 1 & 2 or Sales Departments 1,2 & 3
2 Sales Order Number (not displayed in totals mode).
3 Sales order line (not displayed in sales order total or totals only mode)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Sales Order Number (not displayed in totals mode).
2 Report Grouping - Selling Location / Supplier / Product Class / Product Group / Sales Department 1, 2 or 3 / Sales Departments 1 & 2 or Sales Departments 1,2 & 3 (not shown in totals only mode)
3 Report Totals
Printed Fields
Fields printed on the report.
Order Line mode (blue italic font)
-
SKU
-
Product Description
-
Quantity
-
Final line selling price
Order totals (not shown when showing totals only) (black font)
-
Sales Order Number
-
Manually Keyed Pad Reference
-
Sales Order Date
-
Keyed Order Date (the date the order was entered into SwanFRS)
-
Order Delivery Method
-
First Completed Date
-
Elapsed Days
-
Sales Order Value
-
Open order Elapsed Days (days open) (Maroon Font)
-
Open Sales Order Value (Maroon Font)
Group Total
-
Average number of days to complete orders raised within the report’s date range.
-
Average number of open dates for orders yet to complete. which were raised during the report’s date range.
-
Sum of open sales order values
-
number of open sales orders
-
Value of Orders completed in band band 1, 2, 3, 4 & cumulative for the report.
-
Number of Orders Completed within the date range for band 1, 2, 3, 4 & cumulative for the report.
-
Percentage of orders each band relates to in relation to report total.
Report Totals
-
Average number of days to complete orders raised within the report’s date range.
-
Average number of open dates for orders yet to complete. which were raised during the report’s date range.
-
Sum of open sales order values
-
number of open sales orders
-
Value of Orders completed in band band 1, 2, 3, 4 & cumulative for the report.
-
Number of Orders Completed within the date range for band 1, 2, 3, 4 & cumulative for the report.
-
Percentage of orders each band relates to in relation to report total.
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