Best Before/Sell By Date Used in MRP


Well Known Member
Is there a way to have MRP use the Best Before or Sell By Dates in calculating supply versus Expiration Date?

We have scenarios where we have to pull product from the shelf three months before it expires. However, from an MRP/planning standpoint, the system will not prompt to plan for more inventory until the expiration date (if the item ever expires at all). Putting the lot on hold on the date it hits best before or sell by date won't help as our lead times are six months or longer.

I have searched everywhere I can think of, so any help would be appreciated.
I don't have the answer, but I'm curious if you ever figured out how to do this because I have the same problem. Ever get it to work?