The Obsolete Inventory Report identifies products that remain in stock for extended periods without being sold or used. These stagnant items can result from overstocking low-demand products, weak marketing, inefficient inventory management, or other factors. Stagnant inventory negatively impacts your business by occupying valuable storage space, increasing costs, and potentially leading to reduced quality and value. Rewaa provides the Obsolete Inventory Report to help you identify stagnant products, enabling effective decision-making and better inventory management.
Accessing the Report
Navigate to:
Reports > Inventory > Obsolete Inventory.
Use the search fields to filter products by:
Product name
Product code (SKU)
Time period
Location
Turnover rate.
Report Details
The report provides the following information:
Product Name: Name of the product.
Product Code (SKU): The product's unique identifier.
Location: Branch where the product is stored.
Last Purchase: Date of the last purchase transaction.
Last Sale: Date of the last sale transaction.
Quantity: Available stock at the specified location.
Cost: Cost of one unit of the product in inventory.
Inventory Value: Calculated as the cost per unit multiplied by the remaining quantity.
Turnover Rate: Total cost of goods sold during the specified period divided by the average inventory value.
Exporting the Report
To export the report:
Click on the three dots in the top-right corner.
Select xlsx.
The file will download to your device for further analysis.
FAQs
1. Can user access to the Obsolete Inventory Report be restricted?
Yes, follow these steps:
Go to Settings > Users > ⚙️ > Edit User.
Navigate to User Permissions > Reports > Report List and enable Read.
Expand Inventory Reports and locate Obsolete Inventory.
Enable the necessary permissions.
Click Save Custom User to apply the changes.