E 10.1.500.10 We have loaded a part with the wrong UOM. It is currently EACH (UOMClass = Counted) and should be FEET (UOMClass = Length). There is only part tran record is ADJ-CST and it is this transaction that is preventing me from deleting the item and re-adding with the correct UOM.
Based on information in other threads, I have (1) Ensured there is no quantity on hand and (2) Created an Other type UOMClass that has both EACH and FEET, with a 1:1 conversion factor between them.
I then tried the use the Part UOM Conversion Maintenance tool and got this message: Missing Conversion to UOM Code BX0200.
Screenshot below is from TEST where I am trying to re-create the error and then fix it before messing around in PROD.
If it just the one adjust cost parttran then you can make an updateable baq to change the parttran partnum temporarily and make the changes then put it back.
If it still won’t then you need two updatable baqs to update the UOMClass and then one to remove and extra PartUOM records if they exist.
Only you know your data, but if it is this clean then it should not be a problem.
I made an updatable baq to set initial costs, so the initial cost does not create a parttran record to allow us to deal with these issues cleaner.
Just an update to this. If you are importing PartUOM and want to update the part specific UOM. Then just run the DMT as an Update, no add option. It won’t update if there are PO or SO lines against the partuom,
Just to clarify I am talking initial loads. I can see that I have transactions in the PartTran after importing costs and balances, and I can still update the part specific UOM for those parts. I think the HasbeenUsed flag is the thing that prevents the PartUOM DMT from working.
