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