Regarding Lot expiration date

Hello ,

I want to set up the Lot expiration date of the Finished Good item based on the earliest expiration date of the Raw Material used the respective BOM of the Finished Good .

Currently using the FIFO method for Lot usage , and the Lot number of FG is assigned as the Work Order number , the lot of Raw material is assigned by next number

Please advise.

Thanks