Exclude on-hand quantities for lots expiring in the next X days from the MinMax Planning calculation

We need to configure the Min-Max Planning process to exclude on-hand quantities associated with lots that are set to expire within the next X days (e.g., 30 days). This will ensure that materials nearing expiration are not considered as available supply in the replenishment calculation.

Business requirement - Since the lead time for purchased items is 45 days, we need to configure Min-Max Planning to exclude on-hand stock that will expire within the next 30 days from the planning calculation. This will allow the system to generate Purchase Requisitions (PR) and subsequent Purchase Orders (PO) in a timely manner so that fresh supply can be received and made available before the current stock reaches expiry, ensuring uninterrupted material availability.