Stock Aged List

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

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

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