Lot numbered item expiration date Search
I am trying to create a search that will email me whenever an item is 30,60, & 90 days away from expiring. I tried to do this as an item search, but I was having no luck. I tried to create a bin search too, but nothing. I am looking to have the following results:
- Inventory location
- Lot number
- Expiry Date (only within the 30/60/90)
- Quantity (of specific lot # expiring)
- Bin number
Is this possible to do as a saved search? Will you please point me in the right direction?