i want to prevent receiving expired or near expired lots. my business requires to prevent purchase receiving if the expiration dates of items are expired or near expired (three months).
i can set the status of the expired lot as inactive material status, but that needs daily updating for the user, is it possible to update the lot status automatically?
Are you on 11i or R12.
Do you use Discrete Manufacturing or OPM ?
If you are using R12 OPM, then you can set the lot status after sampling and testing the lot.
Otherwise you can write a custom procedure to update lot status (using INV_LOT_API_PUB.update_inv_lot)
and base a concurrent program on it (And schedule it at appropriate frequency ..).