Lot expiration and moving expired lots n number of days before actual expiration

Summary:

Lot expiration and moving expired lots n number of days before actual expiration

Content (required):

Hi,

We have a requirement to automatically move lots to a different sub-inventory 'n' number of days before product actually expires, so that they cannot be transacted. We will then scarp the lots from there.

If automatically moving of lots to a different sub-inventory is not possible, then at least can we change the Lot status automatically for the On hand stock when lot reaches say 180 days before actual expiration.

I was exploring Expiration Action Interval and Expiration Action functionalities but it does not look like this can handle this requirement. Expiration action interval seems to be more after actual product expiration. And I did not find a way to use expiration action to move lots to a different sub-inventory or to a different status. Looks like It is just a list of values.