Impact of delete a PartWip record?

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?

2 Likes

Only way to know is to delete them in Pilot, complete / receive / close the jobs, and then have finance check the Inventory WIP Rec reports to make sure they come out ok.

2 Likes

Oh, well, I don’t need to use SQL. Just discovered that the Adjust Material screen will clean up WIP. Knowing that, I don’t care about what costs will do.

1 Like