Hi @Jason Johnson ! With an escalation it can be done.
When you receive a ITEM tracking by lot, in the Receive application do you need to set:
MATRECTRANS.MANUFACTURER: Manufacturer ID, to can to track correctly
MATRECTRANS.TOLOT: Lot ID
MATRECTRANS.USEBY: Lot Expiration date (most important data)
When you save the currect "Receipt" Maximo saves Lot data in INVLOT TABLE.
So, you can create a new SCALATION on INVLOT Table, put your condition (
If you want to run for all lots, you could put a true condition like 1 = 1. Perhaps ideally you would do it for those unexpired lot, i.e. USEBY > sysdate (so that it is only executed for those unexpired lots)
Then, at your escalation point you can specify the number of days in advance you want to be notified. For example, if you want to be notified 3 days before of due date, set the unit to 'DAY' and the quantity to -3. This way, you'll receive the notification 3 days before.
Then, in your template, you can include informative data from the INVLOT table (Lot ID, Manufacturer, Manufacturer's Lot, Expiration Date, ITEMID, storeroom, and any other relevant information).
Regards!