Originally written by John Hardwick, last updated Jun 12, 2023, on the Swan Retail knowledge base (FRS).
Part of: Stock Reports
The report enables the generation of an aged stock list. For a specified location / product group combination, the report will show all stock held for more than the specified number of days.
Crystal report name Stock Aged List 5
In detailed mode, a notice box is displayed identifying if the stock item is
-
Not Free to sell (red background)
-
A display Item (yellow background)
-
Linked to a sales order (green background)
Selection Criteria
Run time choices, user selectable.
-
Restricted Stock Holding Location(s)
-
Product Group(s)
-
Minimum number of days In stock
-
Max number of days in stock
-
Format
-
Detail / Summary
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Stock Holding Location
2 Product Group
3 SKU in Summary mode / GRN in Detailed
Report Totals
As indicated by yellow numbered squares in the report example.
1 Supplier / Vendor
2 Location
3 Report
Printed Fields
Fields printed on the report.
-
Stocking location
-
Product Group
-
GRN Number (Detailed Only)
-
SKU (Summary Only)
-
Stock ID (Detailed Only)
-
Supplier / Vendor
-
Range / Collection
-
Product Description
-
Product Options (Detailed Only)
-
Date Received
-
Quantity (Length) in stock
-
Current Cost
-
Age in stock (in days)
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