Originally written by John Hardwick, last updated Apr 30, 2026, on the Swan Retail knowledge base (FRS).
Part of: Stock Reports
A report showing ‘free to sell’ goods at the specified location(s), grouped by supplier within product group.
Crystal report name Free Stock List 6
Summary version omits the Stock ID number and date received and stock item option specifics.
When showing Stock IDs if the item has been in stock for more than the specified number of ‘highlight’ days, the row is shown with a yellow background.
Selection Criteria
Run time choices, user selectable.
-
Restricted Stock Holding Location(s)
-
Supplier(s)
-
Format
-
Summary (SKU totals) / Stock IDs with options / Stock IDs without option
-
-
Group By
-
Supplier - Range / Product Group - Supplier - Range
-
-
Highlight stock held for more than X Days
-
Include Costs
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Stock Holding Location
2 Product Group (where selected)
3 Supplier / Vendor
4 Range / Collection
5 SKU
6 Stock ID (Detailed format only)
Report Totals
As indicated by yellow numbered squares in the report example.
1SKU
2 Supplier / Vendor / Range / Collection
3 Product Group (where selected)
4 Location
5 Report
Printed Fields
Fields printed on the report.
-
Stocking location
-
Product Group
-
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
-
Stock / Inventory ID (where selected)
-
Bay location (when showing Stock IDs)
-
Receipt date (when showing Stock IDs)
-
Options (where selected)
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