Product Expiry Configurable

This module extends the standard expiration features so that the four expiry delays (Use Time, Removal Time, Alert Time and Expiration Time) and the 'Use Expiration Date' flag can be defined at product category level. When you set them on a category, they are copied to products in that category, and you can still override them per product.

On the product category form, a new 'Expiry Dates' group appears (visible to users with lot/serial number access) where you enter the delays in days and tick 'Use Expiration Date'. Values are inherited from the parent category when left empty.

On lots and serial numbers, three new filters are added to the search view: 'Use Date Reached', 'Removal Date Reached' and 'Expiration Date Reached', and the existing alert filter is renamed 'Alert Date Reached'. The Lots/Serial Numbers action is also redefined.

Three scheduled jobs (disabled by default) run daily: Product Removal Date Reached, Product Use Date Reached and Product Expiration Date Reached. Each looks for lots whose corresponding date has passed and that still have stock in internal locations, then creates an 'Expiry Date Reached' activity for the product's responsible person (or the administrator). A flag on the lot prevents the same activity from being created again for the same date.