Product Lead Time Analysis (1200 onwards)

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

Originally written by John Hardwick, last updated Feb 02, 2026, on the Swan Retail knowledge base (FRS).

Part of: Purchasing Reports


This audit is designed to compare actual supplier lead times against the default, allowing the viewer to differentiate between PO issue to GRN and demand to PO issue. 

Crystal report name Product Lead Time Analysis 1

  • The report shows a green background if the elapsed period is before the SKU default lead time, yellow if over the lead time but under 1¼ times the lead time, and red if over.

  • The audit only shows goods which have been purchase ordered and received into stock.

  • The graph is based on Stock IDs which are allocated sequentially, therefore providing a timeline by stock creation date. (The stock ID is allocated at time of raising the demand) 

  • The report will not show a chart for the SKU if the sample size is less than 2 stock items.

Selection Criteria

Run time choices, user selectable.

  • Supplier(s)

  • Range(s)

  • Stock Created After Date

  • Format

    • Stock Details & Actual Days / SKU Details & Days / SKU & Rounded Weeks

  • Show Chart

    • Yes / No

Print Sequence

As indicated by blue numbered squares in the report example.

1 Supplier / Vendor

2 Range / Collection

3 SKU

Report Totals

As indicated by yellow numbered squares in the report example.

1 SKU

  • A graph showing lead times is produced per SKU

Printed Fields

Fields printed on the report.

  • Supplier / Vendor

This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)

  • Range / Collection

  • SKU

  • Product Description

  • Lead time (in weeks)

  • Number if item in the analytical period.

  • Weeks to Raise PO

  • Weeks to GRN

  • Weeks from Order to GRN

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