How to remove part with negative inventory and a blank UOM?

Epicor ERP 10
1

Hello,
I have a few parts with quantities with no UOM. How do I remove those parts?

Purchase Advisor:

Purchase Advisor
Purchase Advisor.JPG915×398 26.5 KB

Transaction History:

Transaction History
Transaction History.JPG989×415 53 KB

2

I think it would be easier to just add the UOM to the parts. I don’t think the BO will allow you to remove any part with a transaction, I hope not anyway :slight_smile:

The best you can do here is add the UOM to every part without a UOM. There are alternatives, but I’m not going to take you down those roads because they could adversely affect your DB.

3

How do you go about adding “the UOM to the parts”? I can’t do a quantity adjustment or use the DMT because both require a UOM.

4

There are a few ways to do this:

  1. In Part Maintenance you can change them one by one:
    image

  2. On your SQL database you can do an Update for every part without a UOM.

  3. You can use Access to connect to your database and Sort by parts without a UOM and add them.

If you’re not comfortable with choices 2 and 3 I’d just change them one by one in choice 1.

5

I do not see where I can change it because it is already EA for all of the UOMs.
I am familiar with the DMT tool but I am not sure which table to update to get rid of the line with a blank UOM.

Thanks for your help so far!
UOM

6

If you’re familiar enough with uBAQs, you can create one that has a selection criteria against PartTran where the UOM is an empty screen and simply update all records with EA. I was able to use this method to update a transaction that somehow had a blank part number.