Changing a parts UOM and BOM usage UOM

[sdrzewiczewski]

We have added a new unit of measure (UOM). It is desired to update all parts that use the OOTB 'each' UOM to use this new UOM. Also any BOM usages that use the OOTB 'each' we want to update those to the new UOM.

What would be the best way to do this?

thx

[AL_ANDERSON]

In the UOM resource bundle, add you new UOM, and make the original each as
not selectable.

Use SQL to update all of the values in the the appropriate tables to be
the new value whereever it used to be the old value. I think the tales
are likely the DEFAULTUNIT column in WTPartMaster, and the UNITA7 column
in WTPartUsageLink, but you would have to do some investigation and
testing to be sure. I think this is a pretty straightforward value that
does not require a bunch of other tables to be modifed, or any table joins
to update the right information.

This will update all your current values to the new value, and make the
old value not selectable (or you can remove it, or whatever you want to
do).

Be warned, however, that bill of material Occurence functionality is built
to work with EACH only, not with whatever you come up with. This is
important, especially, for some CAD/visualization integrations. There are
other built-in features of the application that work with EACH differently
than other UOMs, and if you make this change, then odd things might happen
whenever you encounter those features.

Al Anderson






Stephen Drzewiczewski <->
01/05/2011 11:06 AM
Please respond to
Stephen Drzewiczewski <->


To
-
cc

Subject
[solutions] - Changing a parts UOM and BOM usage UOM




Caterpillar: Confidential Green Retain Until: 02/04/2011



We have added a new unit of measure (UOM). It is desired to update all
parts that use the OOTB 'each' UOM to use this new UOM. Also any BOM
usages that use the OOTB 'each' we want to update those to the new UOM.
What would be the best way to do this?
thx

Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription
Use of this email content is governed by the terms of service at:

[sdrzewiczewski]

I had actually done what you suggested on a dev server, and it did work.
I'm glad to hear that I wasn't wrong in my thinking.



But Jeff Z. just told me the same thing about the default unit Each and
that was something we weren't expecting, so back to the drawing board...
L

[RussPratt]

While I've never attempted this kind of change with UOM, I would think you could simply modify the UOM Resource Bundle leaving "ea" but changing the display name from "Each" to whatever your new value is. My suspicion is that this would handle the "change" while not actually being a change. Certainly an option to consider if you truly want to leave "Each" behind in the dust.

Russ