Pipeline

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

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

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