Stock Ageing Report

The Stock Ageing Report shows how long stock items have been in the system.

It highlights the age of your oldest stock units, helping you manage slow-moving items, reduce risk of obsolescence, and plan promotions or clearance actions.

---

🔎 Running the Report

To generate the Stock Ageing Report, the user must select:

• Warehouse – required, choose “All Warehouses” (default) or select a specific warehouse.

• Location – optional, filter by a specific location within the selected warehouse.

• SKU – optional, filter by a specific product.

---

📋 Report Columns Explained

🏭 Warehouse

• The warehouse where the stock is stored.

---

📍 Location

• The specific warehouse location where the stock is held.

---

🏷️ SKU

• The unique identifier of the stock item.

---

📝 Description

• The readable name or description of the stock item.

---

📅 Last Inserted Date

• The date when stock for this SKU was last received or added into the system.

---

⏱️ Age (Days)

• The number of days since the oldest stock unit of this SKU was added.

• This indicates how long the stock has been sitting in the warehouse without being fully cleared.

---

✅ How to Use the Stock Ageing Report

• Identify Slow Movers: Spot products that are aging in stock and may need promotional activity.

• Reduce Waste: Prioritize older stock for picking to prevent expiry or obsolescence.

• Cash Flow Optimization: Free up capital tied to aged stock by planning clearance or markdown strategies.

• Warehouse Efficiency: Monitor which warehouses or locations hold the most aged stock to improve turnover.