Due to the inane ability to return/un-issue a material off a job using a lot number that wasn’t issued to the job, I’ve got WIP records for a specific lot-controlled job material that are all screwed up.
I’m able to fix the quantity issued to the material, but end up with an additional quantity of 2 in WIP for the same job/asm/mtl. The JobMtl costs and summarized cost for these Part Transactions come out correct, but I’m concerned about extra costs will get purged from WIP when the job closes.
Through SQL I tested out deleting one of the PartWip records and that works. Are there any pitfalls of doing this? Is doing that even going to solve my issue of extra, not-real costs being added to the job at closing?