E9 Changing Inventory UoM

Is anyone actively doing this? I'd like to have a discussion on what it takes to do it as safely as possible.

We've got at least 200 parts that have the wrong UOM Class or Primary UOM. The option of making a new part number won't work for us, because we'd need to update drawings, and just about everything we've got is lot tracked.

--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> Yes. By doing it with 4gl you're basically bypassing all the epicor
> business logic.
>
> --Insert standard 'take a backup' and 'make sure you know what you're
> doing' spiels here--
>
> That said, as long as:
> -You have no on-hand inventory for the part
> -The part is not on any open Orders, Quotes, POs, Invoices, Shipments, etc.
> Essentially, you can't change any records once the UOM on them doesn't
> match the UOM currently on the part.
> You can safely change it. I've done this several times across almost every
> version north of 8 without issue.
>
> Note though, if the part is listed as a material on anything that will be
> produced in the future, you'll need to either update the UOM there as well
> or remove the part and add it back in after its UOM has been updated.
>
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Fri, Sep 14, 2012 at 2:25 PM, Anon
> <epicor-team@...>wrote:
>
> > **
> >
> >
> > On that note I can verify that Epicor does no validation for 'if has been
> > used'. I have been able to, accidentally, update the IUM using another
> > custom control and doing an on_change linked to the actual field. I have
> > only done it with part specific UOM's in particular however. I figured if I
> > allowed this it would freak the system out. Are you saying that if we have
> > a brand new part with a part specific UOM, they do a cost adjustment and
> > the UOM gets locked, we could still change that UOM without trouble? If so
> > that would be amazing, i'll go unfix my original bug immediately.
> >
> > --- In vantage@yahoogroups.com, John Driggers <waffqle@> wrote:
> > >
> > > You can change it, but not via any supported method.
> > >
> > > You need to make a little 4gl script to update the part record and set
> > the
> > > UOM to what you want. This will change the UOM regardless of any
> > inventory
> > > you have on hand. HOWEVER, you really should adjust the inventory out or
> > > otherwise bring it to 0 before you make the change or you'll get some
> > weird
> > > issues with costing due to changes in conversion factors and such.
> > >
> > > Once you have your script you can either compile it and run from the
> > Admin
> > > Tools or just use a bpm to attach it to a seldom used BO method for a
> > > moment and fire it that way.
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> >
> > >
> > > *
> > >
> > >
> > >
> > > On Fri, Sep 14, 2012 at 1:53 PM, Anon
> > > <epicor-team@>wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > Great question. you don't and it sucks. We have easily 70 or so parts
> > that
> > > > are dead in our system because they were entered with the wrong IUM and
> > > > could not be corrected. This is since january. even better we want to
> > > > change our engineering of some parts, which requires changing how we
> > have
> > > > the IUM set... that means it's going to be about 4000 more parts dead
> > and
> > > > inactive.
> > > >
> > > > You should be able to empty the system of inventory and change it or
> > > > something...
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > > > >
> > > > > What's up in E9 with the Inventory UoM being disabled on the Part
> > master?
> > > > > How would one go about changing a Part's Inventory UoM?
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > -----
> > > > > No virus found in this message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 2012.0.2221 / Virus Database: 2437/5268 - Release Date:
> > 09/14/12
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
What's up in E9 with the Inventory UoM being disabled on the Part master?
How would one go about changing a Part's Inventory UoM?






-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2437/5268 - Release Date: 09/14/12

[Non-text portions of this message have been removed]
Great question. you don't and it sucks. We have easily 70 or so parts that are dead in our system because they were entered with the wrong IUM and could not be corrected. This is since january. even better we want to change our engineering of some parts, which requires changing how we have the IUM set... that means it's going to be about 4000 more parts dead and inactive.

You should be able to empty the system of inventory and change it or something...

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> What's up in E9 with the Inventory UoM being disabled on the Part master?
> How would one go about changing a Part's Inventory UoM?
>
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2437/5268 - Release Date: 09/14/12
>
> [Non-text portions of this message have been removed]
>
You can change it, but not via any supported method.

You need to make a little 4gl script to update the part record and set the
UOM to what you want. This will change the UOM regardless of any inventory
you have on hand. HOWEVER, you really should adjust the inventory out or
otherwise bring it to 0 before you make the change or you'll get some weird
issues with costing due to changes in conversion factors and such.

Once you have your script you can either compile it and run from the Admin
Tools or just use a bpm to attach it to a seldom used BO method for a
moment and fire it that way.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Fri, Sep 14, 2012 at 1:53 PM, Anon
<epicor-team@...>wrote:

> **
>
>
> Great question. you don't and it sucks. We have easily 70 or so parts that
> are dead in our system because they were entered with the wrong IUM and
> could not be corrected. This is since january. even better we want to
> change our engineering of some parts, which requires changing how we have
> the IUM set... that means it's going to be about 4000 more parts dead and
> inactive.
>
> You should be able to empty the system of inventory and change it or
> something...
>
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
> >
> > What's up in E9 with the Inventory UoM being disabled on the Part master?
> > How would one go about changing a Part's Inventory UoM?
> >
> >
> >
> >
> >
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.2221 / Virus Database: 2437/5268 - Release Date: 09/14/12
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
On that note I can verify that Epicor does no validation for 'if has been used'. I have been able to, accidentally, update the IUM using another custom control and doing an on_change linked to the actual field. I have only done it with part specific UOM's in particular however. I figured if I allowed this it would freak the system out. Are you saying that if we have a brand new part with a part specific UOM, they do a cost adjustment and the UOM gets locked, we could still change that UOM without trouble? If so that would be amazing, i'll go unfix my original bug immediately.

--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> You can change it, but not via any supported method.
>
> You need to make a little 4gl script to update the part record and set the
> UOM to what you want. This will change the UOM regardless of any inventory
> you have on hand. HOWEVER, you really should adjust the inventory out or
> otherwise bring it to 0 before you make the change or you'll get some weird
> issues with costing due to changes in conversion factors and such.
>
> Once you have your script you can either compile it and run from the Admin
> Tools or just use a bpm to attach it to a seldom used BO method for a
> moment and fire it that way.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Fri, Sep 14, 2012 at 1:53 PM, Anon
> <epicor-team@...>wrote:
>
> > **
> >
> >
> > Great question. you don't and it sucks. We have easily 70 or so parts that
> > are dead in our system because they were entered with the wrong IUM and
> > could not be corrected. This is since january. even better we want to
> > change our engineering of some parts, which requires changing how we have
> > the IUM set... that means it's going to be about 4000 more parts dead and
> > inactive.
> >
> > You should be able to empty the system of inventory and change it or
> > something...
> >
> >
> > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > >
> > > What's up in E9 with the Inventory UoM being disabled on the Part master?
> > > How would one go about changing a Part's Inventory UoM?
> > >
> > >
> > >
> > >
> > >
> > >
> > > -----
> > > No virus found in this message.
> > > Checked by AVG - www.avg.com
> > > Version: 2012.0.2221 / Virus Database: 2437/5268 - Release Date: 09/14/12
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Yes. By doing it with 4gl you're basically bypassing all the epicor
business logic.

--Insert standard 'take a backup' and 'make sure you know what you're
doing' spiels here--

That said, as long as:
-You have no on-hand inventory for the part
-The part is not on any open Orders, Quotes, POs, Invoices, Shipments, etc.
Essentially, you can't change any records once the UOM on them doesn't
match the UOM currently on the part.
You can safely change it. I've done this several times across almost every
version north of 8 without issue.

Note though, if the part is listed as a material on anything that will be
produced in the future, you'll need to either update the UOM there as well
or remove the part and add it back in after its UOM has been updated.


*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Fri, Sep 14, 2012 at 2:25 PM, Anon
<epicor-team@...>wrote:

> **
>
>
> On that note I can verify that Epicor does no validation for 'if has been
> used'. I have been able to, accidentally, update the IUM using another
> custom control and doing an on_change linked to the actual field. I have
> only done it with part specific UOM's in particular however. I figured if I
> allowed this it would freak the system out. Are you saying that if we have
> a brand new part with a part specific UOM, they do a cost adjustment and
> the UOM gets locked, we could still change that UOM without trouble? If so
> that would be amazing, i'll go unfix my original bug immediately.
>
> --- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
> >
> > You can change it, but not via any supported method.
> >
> > You need to make a little 4gl script to update the part record and set
> the
> > UOM to what you want. This will change the UOM regardless of any
> inventory
> > you have on hand. HOWEVER, you really should adjust the inventory out or
> > otherwise bring it to 0 before you make the change or you'll get some
> weird
> > issues with costing due to changes in conversion factors and such.
> >
> > Once you have your script you can either compile it and run from the
> Admin
> > Tools or just use a bpm to attach it to a seldom used BO method for a
> > moment and fire it that way.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
>
> >
> > *
> >
> >
> >
> > On Fri, Sep 14, 2012 at 1:53 PM, Anon
> > <epicor-team@...>wrote:
> >
> > > **
>
> > >
> > >
> > > Great question. you don't and it sucks. We have easily 70 or so parts
> that
> > > are dead in our system because they were entered with the wrong IUM and
> > > could not be corrected. This is since january. even better we want to
> > > change our engineering of some parts, which requires changing how we
> have
> > > the IUM set... that means it's going to be about 4000 more parts dead
> and
> > > inactive.
> > >
> > > You should be able to empty the system of inventory and change it or
> > > something...
> > >
> > >
> > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > > >
> > > > What's up in E9 with the Inventory UoM being disabled on the Part
> master?
> > > > How would one go about changing a Part's Inventory UoM?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > -----
> > > > No virus found in this message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 2012.0.2221 / Virus Database: 2437/5268 - Release Date:
> 09/14/12
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]