Update Conversion factor

Hi Guys,

Our purchasing team entered the incorrect conversion factor on a part UOM, this part ID has multiple UOM’s. I tried updating the conversion factor using DMT for the specific UOM on the part with no luck. I’ve cleared all inventory, cleared all demand with no luck…

Any ideas? Do I need a data fix from epicor?

Ugh.

There is a Part UOM Conversion program… but it is rarely successful in my experience. Open the program and devour the help… give it a try.

1 Like

There was a hidden has been used checkbox in classic you could expose and reset the has been used field and change the uom conversion. I do not know if that went the way of the dodo bird in Kinetic.

I’ve tried that, not successful. Perhaps a part revision might work. I’ll look into that.

Can’t see in in kinetic, even reverting to classic in developer mode I can’t change it.

You would have to do a personalization to show it in the list grid of the uoms.

1 Like

Do you recall what the check box wasDo you recall what I need to do here? Been a minute since I used classic.
image
called?

It is part entry which is just part. go to the uom tab then list. click on the grid then open collection you will see the has been used is checked as hidden. Uncheck that click ok then save the layout.

Weel In my version is is now read only

We’ve had a few instances where we needed to change the conversion factor, because it was wiped out by a loophole through custom code, and then we weren’t able to reset since the HasBeenUsed was flagged.

We had to submit a case and ask for a datafix.

This is the info they requested:
Company:
PartNum:
UOMCode:
New Has Been Used: FALSE

The field is actually in the PartUOM table, called PartUOM.HasBeenUsed. it is a binary field type.

2 Likes

Ben,

Unfortunately, once the unit of measure conversion has been used on the part, the conversion factor is locked in. That said, you can override it by using a price list. Setup a price list for the Supplier(s) from whom you purchase the part and there is an Override Conversion checkbox. This resets the conversion factor for that part when purchased from that supplier. I only have access to a 10.2 form right now, but here is what that looks like.

Likewise, the conversion factor can be overridden on the PO Line…

…but the user has to remember to make the change. The conversion change on the price list will default on the PO Line when the part is purchased from the Supplier.

Hope that helps.

Michael Thompson

1 Like