Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report details the order / delivery pipeline showing values in thousands, using the sales calendar for week numbers.
This report is not location restricted, therefore consideration should be given as to which operators will have access to this on their report menu. The report is designed to list all stock identified as to be collected by the customer.
Crystal report name Pipeline 4
Location Summary Format
See image above.
The report collates locations by checking the name of the location if it contains the work ‘pram’ the location is part of the ‘Prams & Nursery’ location group, if not it's part of the ‘furniture’ location group.
Values printed are in the thousands, i.e. 100,000 will be shown as 100.
The report is designed for output to Excel (or similar) however formatting will allow printing, although the data printed will be small due to the page width being set at 57 cm (22 inches)
|
OS Deliveries |
The value of goods not delivered to the customer |
|
Overdue |
The value of goods which were expected to be delivered before today. |
|
Deliveries Due |
This is the forecast delivery value looking forward and using the system date to place the expected delivery into a weekly timescale. The report uses the following logic Use the due date of the sale as the expected delivery date If the acknowledged date is set, replace the expected delivery date with the acknowledged date from the PO line. If the required date of the sales is later than the expected date, replace with the ‘do not deliver / required; date If the item has a scheduled delivery date, use this as the expected date. Convert the expected date into a week and band accordingly. |
The left-hand side (weekly analysis) of the report may vary as a sale is amended or cancelled.
The right-hand side (delivery forecasting) will change as orders are acknowledged and deliveries confirmed, therefore this report cannot be used for retrospective analysis.
Order Detail
Values printed for totals are shown in the 1000s however order line level data, Blue text relates to actual selling values, therefore if you summate the line totals there may be a rounding variance to the total due to presenting the total to the nearest 1000.
Selection Criteria
Run time choices, user selectable.
-
Financial Year
-
Week Number
These values are taken from the sales calendar - if not set, the report cannot produce data.
-
Sales Department Level 1 to 3
-
Include Orders on Hold
-
Yes / No
-
-
Group By
-
Location / Sales Dept 1 / Sales Dept 2 / Sales Dept 3
-
-
Format
-
Detail - Order Line Level / Summary - Group level
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Location Group (if Location Group Selected) / Sales Department, if not.
2 Location / Sales Department
3 Sales Order Number (Order Summary mode only)
4 SKU (Order Summary mode only)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Location
2 Report
Printed Fields
Fields printed on the report.
-
Location Group
-
Location Description (selling) or Sales Department 1,2 or 3.
-
Orders Placed - Selected Week
-
Orders placed for the selected week.
-
Orders placed in the same week last year.
-
Percentage variance
-
Monetary variance
-
-
Orders Placed - Year To Date
-
Orders placed - YTD (financial year up to and including the selected week)
-
Orders placed in the same time period last year.
-
Percentage variance
-
Monetary variance
-
-
Delivery Forecast - Delivery value
-
Overdue Deliveries (after the expected delivery date)
-
Order due for delivery this week
-
Orders due within 4 weeks
-
Orders due in 5 to 8 weeks
-
Orders due for delivery in 9 to 12 weeks
-
Orders due in 13 to 16 weeks
-
Orders due in 17 weeks or more
-
Order Detail (blue italic text)
-
Delivery Due Date in weeks
-
Sales Order Number
-
SKU
-
Product Description
Extra Columns (Primarily for Spreadsheet use)
-
Location
-
Sales Department 1
-
Sales Department 2
-
Sales Department 3
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