Free Stock List (1214 onwards)

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

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.

image-20250808-082228.png

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

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