It is quite common users duplicate lot numbers. Despite adding custom constraints the duplications exists (as an example: for a product “P” the users create lot numbers “XY” and “L-XY”, that are the same).
Create a wizard similar to party duplication wizard that allows to join many lots in one.
The wizard will be launch for two or more lots, and user will mark which is the valid lot.
The wizard could have some comparison checks that will trigger a warning if lot fields does not match (in case lot model is extended).
Lots duplicated will be removed (there isn’t active field).
If lots are involved in period caches, the process will be canceled.
The reference fields to relink:
- Move: lot
- Inventory: lot