The Aged Stock Report is designed to provide a Company level view of stock holdings and the current financial liability being incurred by the business.
The Aged Stock Report is global, meaning it reports on a sum total for all Outlets. To view details on stock for individual Outlets we recommend using the Stock Value vs Sales Report.
📋
Note: Package Items will not be displayed on this report
Using the Aged Stock Report
To use the Aged Stock Report:
- Navigate to Reports > Finance Reports > Aged Stock Report
- Use the Filters as required
- Click Search
- The Results will be displayed (see below for more detail on each of the columns)
The results will only include products with an Available quantity
- Click View Legend to see a detailed explanation of the data
- Click the column headings to sort the data
- Export the report to Excel by using the buttons in the top right-hand corner
Back to top
Understanding the Results
To assist with understanding the results, please find below details on each of the columns:
| Column | Details |
| Supplier | The default supplier for the product. Where the product has been ordered and received from multiple suppliers they will be grouped together in the report results under the default supplier. |
Time Periods
(<30, 30-60, 60-90 and 90+) |
The number of products matching that age according to the "Date Received" on a Purchase Order.
|
| Unknown COGS/Unknown Avail |
Any Available quantities entered using methods other than Purchase Orders (Stock Adjustment, Mass Upload etc) will be displayed as "Unknown"
|
| Avail |
The results will only include products with an Available quantity. Products with no Available quantity are automatically excluded and any Allocated quantities are also excluded.
|
| COGS |
The Cost of Goods Sold - the weighted average price
|