# Changing part UOM Conversion Factor **URL:** \ **Category:** Epicor ERP 10\ **Tags:** e10, epicor\ **Created:** [June 24, 2020, 5:58pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420 "2020-06-24T17:58:40Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![jbowen07](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/76d3ee/32.png) [@jbowen07](https://www.epiusers.help/u/jbowen07)\ **Post date:** [June 24, 2020, 5:58pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/1 "2020-06-24T17:58:40Z")
This might be a stupid question but does anyone know of a way to change the part UOM Conversion Factor on a part that already has a part transaction in the system? When the part originally got put in the system it was put in with the wrong conversion factor and now I am trying to fix this issue so the jobs will reflect the correct amount but I haven’t found a way to change it yet. ---
**Author:** ![Evan\_Purdy](https://www.epiusers.help/user_avatar/www.epiusers.help/evan_purdy/32/69101_2.png) [@Evan\_Purdy](https://www.epiusers.help/u/Evan_Purdy)\ **Post date:** [June 24, 2020, 6:03pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/2 "2020-06-24T18:03:18Z")
Pretty sure you are screwed, unless you make a new part or something. Will be interested to hear if otherwise… ---
**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\ **Post date:** [June 24, 2020, 6:29pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/3 "2020-06-24T18:29:01Z")
> [@Evan\_Purdy](#): > > Pretty sure you are screwed Ditto. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [June 24, 2020, 6:46pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/4 "2020-06-24T18:46:27Z")
Might have to make a new UOM and mark the current one as inactive. On the plus side, UOM’s have both and ID and as “Symbol”. So your new UOM could have the same symbol printed on documents. Ex: Old UOM with: - ID `IN` - Symbol: `IN` - Of class Length - Factor of 13 IN = 1 FT (`FT` being your default UOM of class Length) New UOM: - ID `INCH` - Symbol: `IN` - Of class Length - Factor of 12 IN = 1 FT You’ll have to jump through hoops to get the old UOM to be disabled. ---
**Author:** ![jbowen07](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/76d3ee/32.png) [@jbowen07](https://www.epiusers.help/u/jbowen07)\ **Post date:** [June 25, 2020, 12:39pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/5 "2020-06-25T12:39:34Z")
@ckrusen I don’t think that will work because we have custom code in several reports that goes based off the UOM ID also this UOM is LB and it is part specific I don’t know if that would matter but I figured I should mention it just in case. Before I posted this topic I was thinking the only way to change it was to change the part number the reason I made the post to begin with is to make sure there wasn’t another way because we have used these part numbers for years and some how when we switched to Epicor the conversions(unit net weight in our old system) got changed during the switch. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [June 25, 2020, 12:46pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/6 "2020-06-25T12:46:19Z")
There are many issues with UOM’s in E10. Some bugs, most by design. The biggest one (which is by design), is that any references to the UOM have been made, changing it is nearly impossible. I think this is because the UOM conversions are expected to be fixed and never change. Transactions that used the non-default UOM for the Class, look up the conversion instead of storing it with the transaction. So if the conversion changes at some later date, all those old transactions now represent different qty’s. Kind of like how a packer only knows the CustNum, not the actual address. If you change the address of a customer and then re-print an old packer, you see the new address. Not what the address was when it was shipped. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [June 25, 2020, 12:51pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/7 "2020-06-25T12:51:41Z")
Can you detail exactly what you have, and what you would want it to be? Like… Part `XYZ-123` is UOM Class `WEIGHT`, IUM is in `LB`, and PUM is in `YD1`. Where 100,000 `YD1` = 1 `LB` And the conversion for `YD1` needs to be 110,000 `YD1` = `LB` ---
**Author:** ![jbowen07](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/76d3ee/32.png) [@jbowen07](https://www.epiusers.help/u/jbowen07)\ **Post date:** [June 25, 2020, 1:07pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/8 "2020-06-25T13:07:20Z")
@ckrusen yes I can do that but first let me point out that we might inventory a part in EA and then sale it in either EA or in LB. with that said, here is an example of one part: Part: XYZ-123 is UOM Class is Other, IUM is in EA, PUM(we manufacture the part) is in EA, and the SalesUM is in EA as well. Where 120 LB = 1 EA And the conversion for LB needs to be 435 LB = 1 EA The job will always be in EA because that is the way inventory is however if they sale it by LB and say the amount is 870 LB on the order the job will say it needs 8 EA when it should just be 2 EA. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [June 25, 2020, 1:10pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/9 "2020-06-25T13:10:02Z")
Did you say this is a Part Specific UOM conversion? Or does Class OTHER have a conversion from EA to LB ? ---
**Author:** ![jbowen07](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/76d3ee/32.png) [@jbowen07](https://www.epiusers.help/u/jbowen07)\ **Post date:** [June 25, 2020, 1:12pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/10 "2020-06-25T13:12:51Z")
@ckrusen it is a part specific UOM (each part has its own conversion from EA to LB). ---
**Author:** ![RBeaghan](https://www.epiusers.help/letter_avatar_proxy/v4/letter/r/3e96dc/32.png) [@RBeaghan](https://www.epiusers.help/u/RBeaghan)\ **Post date:** [June 25, 2020, 1:13pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/11 "2020-06-25T13:13:17Z")
We have the same problem and are in need of a solution. You used to be able to unhide some fields in Part Maintenance to override and save a new conversion but they’ve taken that away. I have noticed in a couple versions that several ‘Conv Factor’ fields showing up in tables around the database, so hopefully they are working on saving the factor with the transaction. This should allow UOM Conversions to be updated. ---
**Author:** ![Ernie](https://www.epiusers.help/user_avatar/www.epiusers.help/ernie/32/69401_2.png) [@Ernie](https://www.epiusers.help/u/Ernie)\ **Post date:** [June 25, 2020, 1:20pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/12 "2020-06-25T13:20:50Z")
Mostly the issue revolves around how you value the parts financially. You can’t say that on one week a part is 120 LB to the EA and then another week that same part is 435 LB to the EA… your finance people could end up going to jail (remember Enron?). If this is for multiple part numbers, then the Part Specific UOM designation will save you… but for a single part number you can’t do that. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [June 25, 2020, 1:53pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/13 "2020-06-25T13:53:51Z")
You are going to have to: 1. Make a new part specific UOM for Class OTHER, and add it to Part’s UOM list. 2. Set the Conversion OTHER.LB to inactive. 3. Update the Reports that use the UOM. Preferably change them to use the Symbol. ---
**Author:** ![Jonathan](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/aeb1de/32.png) [@Jonathan](https://www.epiusers.help/u/Jonathan)\ **Post date:** [June 25, 2020, 3:58pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/14 "2020-06-25T15:58:13Z")
What is the exact error message you get when trying to change the conversion factor? ---
**Author:** ![jbowen07](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/76d3ee/32.png) [@jbowen07](https://www.epiusers.help/u/jbowen07)\ **Post date:** [June 25, 2020, 6:39pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/15 "2020-06-25T18:39:57Z")
@Jonathan where you specify the UOM Conversion Factor is grayed out so i can’t change it. ---
**Author:** ![Jonathan](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/aeb1de/32.png) [@Jonathan](https://www.epiusers.help/u/Jonathan)\ **Post date:** [June 25, 2020, 7:22pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/16 "2020-06-25T19:22:40Z")
So you mean below fields are disabled? I enabled this by marking the Part Specific box on the UOM Class. I will check if there is any other validation to disable the ConvFactor besides this. ![image](https://www.epiusers.help/uploads/default/original/3X/a/8/a87d70dab09a55af7846158752fb185562b97795.png) ![image](https://www.epiusers.help/uploads/default/original/3X/6/a/6a9030b55a2973ea96b3228b36684d324b503165.png) ---
**Author:** ![jbowen07](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/76d3ee/32.png) [@jbowen07](https://www.epiusers.help/u/jbowen07)\ **Post date:** [June 25, 2020, 7:26pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/17 "2020-06-25T19:26:25Z")
@Jonathan this is what it looks like for me. ![image](https://www.epiusers.help/uploads/default/original/3X/f/d/fdc76075bf36e4d16a8b4475b6d283eb50a957ba.png) ---
**Author:** ![Jonathan](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/aeb1de/32.png) [@Jonathan](https://www.epiusers.help/u/Jonathan)\ **Post date:** [June 25, 2020, 7:47pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/18 "2020-06-25T19:47:35Z")
Found it, looks like these fields are disabled when PartUOM.HasBeenUsed is true. There is also a field UOMConv.HasBeenUsed but that is more general. You can update this to false at your own risk. As mentioned before the factor is pulled from the setup when a transaction needs it so there is a risk of data corruption. However there could be a case where there are no new transactions for this part and everything active has been closed so no conversion would be needed. Then it is possible the change would not have any unwanted side effects. Keep in mind I don’t work much with Parts or UOMs so this is only me guessing. ---
**Author:** ![jbowen07](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/76d3ee/32.png) [@jbowen07](https://www.epiusers.help/u/jbowen07)\ **Post date:** [June 25, 2020, 7:51pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/19 "2020-06-25T19:51:19Z")
@Jonathan thanks but with how many different parts that are messed up @ckrusen way seems like it will work but there will be alot of code changing to get it to work. it does however seem like the best solution. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [June 25, 2020, 7:54pm UTC](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420/20 "2020-06-25T19:54:23Z")
Before yopu dive into the really hard way, make sure there is zero QOH of the part before trying to change that Part Specific UOM conversion. A half-assed test I did showed that those are disabled when there QOH. And they re-enabled when the QOH went to zero. [Next page](https://www.epiusers.help/t/changing-part-uom-conversion-factor/68420.md?page=2)