Business owners need to track how long products remain in storage from the moment they’re received. This is essential for gaining a clear overview of stock status—and that’s where the Stock Aging Report comes in.
Displaying the Stock Aging Report
This report displays all item quantities across all warehouses, including pending quantities. To access it, make sure you have permission to view the Stock Aging page, then follow these steps:
Go to the Warehouse module.
Open the “Stock Aging” Report.
Set the number of aging periods and days per period (maximum: 5 periods of 180 days each).
Choose a product classification from the "Stock Item Classification" dropdown (default is "All").
Click on “Generate”.
Important Notes:
This report uses the FIFO principle (assumes the oldest stock is sold first) to track inventory age.
The report groups the stock into aging buckets according to the user selections in aging periods (e.g., 0-30 days).
Calculates stock age based on:
Stock item Global balance.
RS remaining quantity (RS quantity - returned quantity).
RS documents dates.
Example:
If the global on-hand balance for an item is 13:
The latest recieve supplies (RS1) included 10 units, 8 of which were returned → only 2 are counted.
The second latest (RS2) had 12 units, none returned → 11 are counted.
Therefore, the total stock is (2 from RS1 + 11 from RS2) = 13.
If more quantity is needed, the system pulls from older receiving documents accordingly.
Note: You can view Stock Aging by Supplier (per stock item) by selecting the item and clicking the details icon "".
Note: To export the report to Excel, click on “Export”.
If you encounter any challenges or have any questions during these processes, you can contact our technical support team, which is ready to assist you.