So in Part maintenance, there’s a field for Shelf Life/days. Does anyone know if I received an item into inventory, if it tracks the expiration date based on the received date and shelf life/days?
Example, if I received an item on 5/4/2018, but my shelf life is 15 days, it would be 5/19/2018 before it expires. Is that date tracked anywhere or would I need to do a date calculation against that field?
If it is lot tracked you can track this but other than that you’d have to lookat PartTran
Thank you. It’s a combination of both lot tracked for most parts and not for others.
So if it’s lot track, which table would I need to look at? I can probably use a condition to look at one field and if not there then look at the other.
I think Jose’s answer is the key. (as I understand it)
if not lot tracked you would need to review the PARTTRAN records to see when a qty was received into a bin and then calculate the days.
The data on each individual Lot is kept in a table called PartLot.
It has been a really long time since I explored this… back in the olden days, I know I wrote a BPM to auto populate the PartLot table with a calculated Expiration date based on the part’s Shelf Life.
BUT, Now, (as of E9?) there is a complete tab to specify what data you REQUIRE to be captured when you create the lot… one of those is the Expire date.
There is also a Lot Number Entry program that allows maintenance of this data:
Thanks Tim. Will take a look at that.
