Open Expiry v Expiry Assigned on Arrival

ERPNext Stock/Inventory
1

Hello,

Is there an existing way to assign a different/second expiry date for an item?

Scenario:
An item arrives with an expiry date from the manufacturer, i.e. October 2030. It is added in to ERPNext with this lot number.

However, once opened for use the item expires after 30 days.

Is there a way to set this up so that an item can be taken from a warehouse and assigned this new expiry (without overriding the manufacturers date) for allocation in Work Orders etc.

Any suggestions of how to do this?
Thanks,
Paul

2

This is do-able.
How do you record “opening for use” in ERPNext? Is there a custom doctype or something?

If yes, run a script to update the expiry date when you save/submit that doc.
If no, when you open the item for use, manually update the expiry date field.

3

Thanks. I’m still finding my feet with ERPNext and trying to find out what it can do and where I need to customise, so nothing setup yet.

I wonder if it might be easier to create a BOM and create a new item with the open expiry, using the original material as a part of that?

If not I can try and look further at your suggestions :slight_smile: