Wrong lot on-hand date due to WO completion

User wrongly performed the WO completion using a forward date. This resulted in the lot number created in F4108 having a future-date for the field "on-hand date", which resulted in system showing qty on-hand but no qty available. User reversed the WO completion and redo the completion, but looks like the lot number created (first round of completion) is still using the original date which was wrong. The on-hand date is disabled hence not available to edit. Does anyone encounter this issue before and how to resolve? I suspect SQL-fix may be the only solution.

Thanks in advance.