The Inventory Aging Analysis report provides a statistical inventory aging and stock holding analysis view within TUHUND.
The report is designed to help organisations evaluate inventory aging patterns, analyse stock holding duration and monitor inventory carrying costs such as finance cost and storage cost across products, brands and inventory categories. The report supports both current stock analysis and projected aging assumptions for unsold inventory.
The report can be accessed through:
Inventory → Reports → Aging Analysis
Purpose of the Report
The report is used to analyse inventory aging trends, identify slow-moving stock, evaluate inventory holding duration and monitor estimated inventory carrying costs.
It is commonly used by inventory teams, warehouse managers, finance teams and management personnel for stock aging analysis and inventory planning.
Report Interface
The report interface contains the following sections:
|
Section |
Description |
|
Entity Selection |
Filters report by organisation, company or branch |
|
Show Selector |
Defines aging calculation assumptions |
|
Record Type Selector |
Filters products and accessories |
|
Brand Selector |
Filters report by brand |
|
Sort By Selector |
Defines aging-based sorting |
|
A–Z / Z–A |
Controls sorting order |
|
Period Selector |
Defines reporting period |
|
Report Grid |
Displays inventory aging statistics |
|
Utility Buttons |
Opens related aging analysis reports |
|
Export Button |
Exports report data |
The ENTIRE ORGANIZATION selector functions similarly to other reports and allows users to generate inventory aging reports across accessible organisations, companies or branches.
Aging and Filtering Options
The Show selector supports multiple inventory aging assumptions including:
-
Exclude Unsold
-
Only Current Stock
-
Assume Unsold Products Are Sold Today
-
Assume Unsold Products Are Sold Tomorrow
-
….
-
Assume Unsold Products Are Sold In 2 Years
These options allow organisations to simulate inventory aging scenarios and evaluate potential future stock holding impact.
The record selector supports All Records, Only Products, Only Spares & Accessories
The report also supports brand-based filtering and product searching functionality.
Sorting Options
The Sort By selector supports multiple inventory aging and statistical analysis parameters including product details, minimum age, maximum age, mean age, median age, mode, standard deviation, amount, finance cost and storage cost.
These options allow users to analyse inventory aging behaviour using different operational and statistical perspectives.
Report Structure
The report is displayed as a structured inventory aging analysis grid where each row represents a product or inventory item.
Depending on the selected configuration, the report may display Product Information, Minimum Age, Median Age, Inventory Amount, Finance Cost, Storage Cost, etc
Finance Cost represents estimated inventory holding cost calculated using financial or interest-based assumptions, while Storage Cost represents estimated warehouse or inventory carrying expenses.
Statistical aging calculations are primarily quantity-based and help organisations analyse inventory holding behaviour across products and stock categories.
Utility Reports and Integrated Navigation
The report includes utility buttons which provide access to related inventory aging reports.
|
Utility |
Description |
|
Time Chart |
Opens the Inventory Aging Time Chart [E111] |
|
Export |
Exports report data |
The Inventory Aging Time Chart provides bucket-based inventory aging visibility across predefined aging ranges such as:
-
Less than 30 days
-
30–60 days
-
60–90 days
-
90–120 days
-
120–180 days
-
180–360 days
-
360–720 days
-
Greater than 720 days
The Time Chart primarily displays quantity-based inventory aging distribution for products across the selected aging periods.
Drilldown Behaviour
The main Inventory Aging Analysis report does not support direct drilldown functionality.
However, the Inventory Aging Time Chart supports product-level drilldown behaviour. Product names displayed within the chart are clickable and open the Stock Register report filtered specifically for the selected inventory item.
The detailed Stock Register view displays stock movement history, quantity balances, valuation information, costing data and inventory transaction records for the selected product.
Inventory Valuation and Costing Information
Inventory reports within the system may support multiple valuation and costing representations depending on the report type and configuration.
Value represents the exact inventory transaction value associated with the item movement.
Cost represents the inventory value along with additional operational expenses such as delivery charges, repair expenses, commissions or related operational costs.
Selling price represents the potential selling value calculated using configured costing structures and pricing sheets.
Export Functionality
The Export button exports the currently displayed inventory aging data in Microsoft Excel (.xlsx) format.
The exported report reflects the selected aging assumptions, inventory filters, sorting structure and reporting period.
Data Representation
The report supports inventory aging analysis, statistical stock holding evaluation, carrying cost estimation and quantity-based inventory aging visibility across products and brands.
Displayed information varies depending on the selected aging assumptions, inventory filters, sorting configuration and reporting period. Where no data exists, corresponding fields may remain empty or display zero values.
Summary
The Inventory Aging Analysis report provides a consolidated inventory aging and stock holding analysis view within TUHUND.
By combining statistical aging calculations, carrying cost estimation, configurable aging assumptions and bucket-based inventory aging visibility, the report enables organisations to analyse inventory holding behaviour, identify slow-moving stock and evaluate inventory aging trends across products, brands and operational inventory categories.
