Item Expiration - Quantity (report)
The Item Expiration - Quantity report shows current inventory levels for items that you track expiration for.
Specify an ending date and period length formula. The report uses this information to calculate columns for three preceding periods of equal length. Inventory is then totaled for each period to show stock expiry, and inventory that expires either before or after the range.
Use cases
Quality control managers use the report to:
- Find expired on-hand stock, or stock that's about to expire.
- Take corrective actions, such as dispose of expired items or schedule a quality control check for items that are about to expire.
- Comply with regulatory requirements for tracking and disposing of expired inventory.
Warehouse managers use the report to:
- Find expired on-hand stock, or stock that's about to expire.
- Take corrective actions, such as dispose of expired items or schedule a quality control check for items that are about to expire.
- Adjust inventory levels based on expiration dates to ensure that the warehouse isn't storing unused or expired products.
Purchasing managers use the report to:
- Monitor the expiration date of inventory to ensure that the warehouse isn't storing unused or expired products.
- Negotiate better pricing with suppliers for items that are close to expiring.
- Plan purchasing activities based on the expiration date of inventory to optimize inventory levels and reduce waste.
Try the report
Try the report here: Item Expiration - Quantity
Tip
If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.
See also
Inventory and warehouse report overview
Ad hoc analysis of inventory data
Inventory analytics overview