Orphan Lots
At this client, users are testing batch mfg. and sometimes when transacting the final product on the batch, they enter incorrect lot number. This results in creating the incorrect lot number tied to the FG item. Then they go back and correct the lot number on the batch. Say from Lot-A to Lot-B. Now the original lot and new lot both are there. The original lot i.e. Lot-A has 0 balance. You can see the lot genealogy showing + and - qty as well due to WIP completion and WIP Completion Return.
How can we get rid such orphan lot nos. such that they don't appear in standard reports? We don't have lot status enabled yet. There is only one lot status i.e. 'Active'. We didn't introduce lot status as the client is not ready to absorb new concepts as of now. I will like to know what are other clients doing to tackle this issue.