Dead Stock

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

Originally written by John Hardwick, last updated Jan 14, 2025, on the Swan Retail knowledge base (FRS).

Part of: Stock Reports


Based on SwanFRS release version 1211

This report is designed to list stock on hand which haven’t been sold for a specified number of days.

image-20241219-100842.png

Crystal report name Dead Stock Report 2

The number of days since last sales / stock held is shown with a red background if the days exceed the highlight days specified in the report.

Clicking on the row presents the following detailed page

Each line shows days since this SKU was last sold, stock detail number, quantity (in red), current unit cost value, total cost value, date received, age in days since booking in, date of last sale (1-Jan-1900 indicates never sold)

Selection Criteria

Run time choices, user selectable.

  • Restricted Stock Holding Location(s)

  • Group By Location

    • Yes / No

  • Stock Categories

  • Group By Category

    • Yes / No

  • Supplier / Vendor

  • Range / Collection

  • Number of Days Since Last Sale

  • Highlight if Stock Held for X Days or higher

  • Show

    • SKU / Model Number

Print Sequence

As indicated by blue numbered squares in the report example.

1 Stock Holding Location (if selected)

2 Product Category (if selected)

3 Supplier / Vendor

4 Range / Collection

5 Model or SKU

Report Totals

As indicated by yellow numbered squares in the report example.

1 Model or SKU

2 Range / Collection

3 Supplier / Vendor (if selected)

4 Product Category (if selected)

5 Report

Printed Fields

Fields printed on the report.

  • Stock Holding Location

  • Product Category

  • 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

  • Model Number / SKU

  • Quantity in stock

  • Average Cost

  • Total Cost

  • Receipt Date

  • Number of Days in Stock

  • Last Sold Date

  • Number of Days since Last Sale

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