Hi,

1. Expiration date is handled in inventory, so then an inventory purchase part can have the shelf life configured in corresponding inventory part.
2. Yes, it’s possible to setup the expiration date during purchase order arrival. System automatically calcultes it as per the shelf life configuration, but it can be manually modified. Is there any problem with this?

Regards,

Pilar

@Pilar Franco 

Really! That is wonderful!

Could you please give some  instruction for the first question?  What’s the function name? What is the tab name? Maybe more information,. Thanks! 

Hi,

You just need to configure the shelf life parameters in Inventory part/Acquisition tab:

And then, when receiving the purchase order, system retrieves automatically the Expiration date according the configured shelf life, but you can also modify it manually, before receiving, if needed:

I hope this helps.

Regards,

Pilar

@Pilar Franco 

We have some glue parts.  The shelf life is 18 months. The manufacture date is marked on box. 

I do test with one glue part.  I keyin the shelf life days 540. The system give expiredate automatically with systemdate + 540 days when Register Purchase Order Arrivals. But this is not we want. Warehouse staff will look the manufacture date on box and calculate then change expiredate manual. This will cause 2 question.

1. User may calculate incorrectly.
2. User may forget to change the expiredate.

Is it possible to implement followed requirements?

1. There is is a place to keyin manufacture date. System will calculate expiredate based on it and shelf life days.
2. If a part’s shelf life days  is not null, system will give warning when user forget keyin manufacture date.

Hi,

Once the shelf life is configured, system will always suggest the expiration date in receive dialog of register arrival. So then, it won’t be null. Also, there is no possibility to insert the manufacture date in receive dialog with configuration. This can be done only customizing the dialog window with a development. 

But I can think of the following:

1. You can insert the manufacture date in Actual Delivery Date field, so system will then calculate correct expiration date. If needed, you can create a custom event when receiving into stock to validate the expiration date against the Actual Delivery Date and confirm this expiration date was calculated properly
2. In case you use serial tracking parts, you can insert the Manufactured date in Part Serial and once this is done you coud trigger a custom event that modifies actual expiration date with the one calculated as per the shelf life in inventory part.

Regards,

Pilar

Sorry, I forgot to mention that you can also use a lot-tracking part and insert the Manufactured Date in Lot Batch master. Then, trigger the same automatic calculation for expiration date with a custom event upon updating the Lot Batch Master Manufactured Date.

hi

shelf life is working well acc to above settings. I like it but:

is there any possibilities that system will show expiration date but not block parts and do not run purchase requisition for expired parts? I would like to use it for a bit different puposes. 

Hi ​@JakubJ ,

Could you please elaborate a bit more your questions?. What’s your business case?

Regards,

Pilar 

HI, yes, 

when you set expiration date and date of expiration is ended then system block expiered handling units of parts and MRP generate purchase requisition.

I would like to not block that Handling Units and do not get purchase requisition.

In my case parts are not expired and I can still use them in production but I need to just check how looks e.g surface treatment of sheet metal. In 99% all fine and I can extend then only expiration date to next control 

Hi ​@JakubJ,

System is working as per design, i.e. once the expiration date is reached, system doesn’t take into account such stock.

Then, for your case, I can think of different possibilities:

1. Either extend configured shelf life to cover the expiration date controls you are referring, so then system can consider such parts even when real expiration date has arrived but you are still pending of doing such inspections to extend later manually the expiration date for valid parts. If you need additional control for such expired parts, then you can move them to another location ‘pending of revision after expiration’, so you can apply availability controls for such location, if needed, to control if parts can be reserved, issued, etc.
2. Use condition codes for the parts with stock expired by removing the expiration date and keep the condition code to identify such parts to be revised. The problem here is that you would lose the original expiration date.

Hope this helps!

Regards,

Pilar

HI

thank you so much for your suggestion.

the second option you mentioned is something I was thinking to use.

lets try it.

Appreciated your support.

Hi ​@JakubJ 

Please let us know if the option worked for you, so we could mark the correct answer for others,

Thank you.

HI

frankly speaking both answers are solving issue in some way.

I thought there is some settings which will treat expired stock as nettable for MRP but if its not, then I have to use solution written above.

thanks