Shelf Life/Expiry Date check at goods issue of a process Order

[cloud_delict]

I have 1 Raw Material, let's call it "RM1" which is used in 2 finished material lets say "FG1" and "FG2".

"FG1" has an SLED period of 36 month maintained in the material master.

"FG 2" has an SLED period of 24 months maintained in the material master.

I have the below batches of "RM1" in stock.

Batch 0012345 - Expiry Date 04/2026 (25 months from today)

Batch 0012346 - Expiry Date 04/2027 (37 months from today)

Batch 0012347 - Expiry Date 07/2027 (40 months from today)

I want batch determination to follow FEFO strategy for process order but also not pick a raw material that has SLED period lesser than the SLED period of the header FG material.

So in the above example, FG1 which has an SLED period of 36 months, should only pick batches 0012346 and 0012347. FG2 can pick 0012345, 0012346 and 0012347.