Obsolete inventory refers to products or raw materials that remain in stock for a long time without being sold or used. Keeping such items is costly as they occupy valuable storage space that could be used for faster-moving products, and they may expire before being sold (causing losses). The Obsolete Inventory Report helps you identify these products and make better decisions to manage your stock efficiently.
Accessing the Report
Go to: Reports > Inventory > Obsolete Inventory Report.
Click on the report to view details.
Filtering Data
You can filter the report by:
Product name
Product code (SKU)
Location
Start date and end date
Maximum inventory turnover rate
Sorting Data
Click on the column header you want to sort by. Example:
Click the Quantity column to sort results from highest to lowest, or vice versa.
Report Data
Product Name | The product name as recorded in the system. |
Product Code (SKU) | The product’s SKU. |
Location | The branch where the product is stored. |
Last Purchase Date | The date of the last purchase of the product. |
Last Sale Date | The date of the last sale of the product. |
Available Quantity | Quantity available in the branch. |
Unit Cost | The cost per unit of the product. |
Inventory Value | Quantity × unit cost at the end of the period. |
Turnover Rate | (Total Cost of Goods Sold ÷ Average Inventory) for the selected period. |
Exporting the Report
Click the three dots on the right side of the page.
Select: xlsx.
The Excel file will be downloaded to your device.
FAQs
How can I identify products or raw materials that haven’t been sold for a long time?
The Obsolete Inventory Report shows all products with no recorded sales activity for an extended period.