Completion existing lot number does not update lot expiration date (P31114)

Hi,

we manually enter the lot number for work orders in the system and we allow duplicate lot numbers. Sometimes lot numbers are duplicated and this is not problem for us. The problem is , if we do completion for an existing lot number that is expired before, system let us to do completion but our production is expired because of that existing lot number. Do you have a solution to update the expiration date based on the last production in P31114 quickly?

thanks