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
Feedback sent
We appreciate your effort and will try to fix the article