We have created the new company, after that we have uploaded the Parts through DMT tool. While doing the Quantity Adjustment through DMT tool system throws an exception " InventoryQtyAdj Msg: Part was not found ". We have identified that Parts numbers and descriptions are mismatched with the uploaded parts.
Could you please suggest how to delete uploaded Parts, Quantity Adjustments and Cost Adjustments from the system?
Note: There is no transaction occurred related to part in the system till date. Once it is delete from system we will upload from scratch.
Since this is a new company, is deleting the company and starting again from scratch an option. I believe Epicor provides an option to delete the company. But then you’d have to reload everything.
Oh! That’s good advice and I will take it myself as I’m starting to load information into our Production DB… I discovered when uploading parts into Pilot via DMT that the .csv file had dropped all the trailing zero’s in my part numbers; I was able to delete them because I hadn’t loaded cost or inventory to them yet but I only focused on deleting a few that I was going to work with in Pilot. I’ll be much more careful when uploading parts to Production DB. I’m actually planning to load them in segments rather than a massive upload of the 5k plus part numbers in our system.
I learned the hardway. Uploaded parts we didn’t need, figuring we’d just delete them later. But after doing Cost AdJ (even with 0 QOH - as we hadn’t done Qty Adj’s yet) those parts (about 6,000 of them) are forever stuck in E10
Ouch! We have that situation in the system we’re moving out of – so I’m trying to be very cautious about what’s moving over and what will just stay in the old system and SQL DB to be dealt with if needed later. Not to mention the various MPN’s or Qualified Mfg p/n’s associated with a lot of those parts… fun times!
Only Cost Adjustment with std/avg/last cost writes only into PartTran table which is the most common issue I have encountered as well. If Epicor have provided archive option for ParTran with Part range, it is not hard to delete a part.
Let’s avoid someone stumbling across this post, not reading the entire thing, because TLDR, and thinking messing with SQL is a solution to getting rid of parts. We all deal with unwanted part records.
If you mark parts as inactive, they do not appear by default in the search screen without changing the search criteria. No one can use an inactive part. To fully prevent this, you could add field security the Part.Inactive field.
Any queries using the part table could be easy filtered to include only active parts.
