ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> mass change of Work Centers
http://www.istechforum.com/YaBB.pl?num=1342100991

Message started by Laura Oliver on 07/12/12 at 06:49:51

Title: mass change of Work Centers
Post by Laura Oliver on 07/12/12 at 06:49:51

When we set DBA up 15 years ago we wrongly set up each machine as a work center. Now we realize that work centers are really areas. For example we have 40 lathes, but we really only need 1 work center called Lathes.

Can we mass change all our lathe workcenters to just one lathe workcenter?

Since these work centers are literally on thousands of work orders, I am not sure what all work centers are tied to and what would be involved to do it manually.

Thanks in advance
Laura

Title: Re: mass change of Work Centers
Post by Lynn_Pantic on 07/12/12 at 07:54:20

The short answer is yes, you can do a search and replace. The files involved are ROUTING, WOROUT and (if you use Routing Templates) ROUTTEMP. The long answer of how to do it depends on whether the existing lathe Work Center codes are all consecutive so you could replace with "LATHES" if WC Code >LAT1 and WC Code <LAT40 or if the existing codes are all over the place and they need to be replaced one at a time

Title: Re: mass change of Work Centers
Post by TwinOaks on 12/04/15 at 10:18:46

We are looking at doing the same thing in our system, renumbering all of our work centers. Your instructions make sense, so now the only question we have is how does this affect the currently printed off work orders? Is there a file to go into to change the work centers on the current work orders, or does the system automatically suck up the new centers?

Title: Re: mass change of Work Centers
Post by Kelloggs on 12/08/15 at 10:48:12

It is quite simple.

Update your Work Center Table.
You should not delete the "OLD" work centers, because you are not updating history.

Cann't be done while people is using the system.
You should not update work orders that are on the floor ("Released" status "R")
Backup, and backup your backup : ROUTING, ROUTTEMP, and WOROUT.
Test it on a play company !!!

Here is the sql statements:

UPDATE ROUTING SET MTRO_WC = 'NEW WC' WHERE MTRO_WC = 'OLD WC';
UPDATE ROUTTEMP SET MTRO_WC = 'NEW WC' WHERE MTRO_WC = 'OLD WC';

If you want to update all work orders regardless of Status ("Released") :
UPDATE WOROUT SET MTWORO_WC = 'NEW WC' WHERE MTWORO_WC = 'OLD WC';

Now if you don't want to update the ones on the "floor". It is a different statement :

UPDATE WOROUT SET MTWORO_WC = 'NEW WC'
FROM WORKORD
WHERE WORKORD.MTWO_WIP_WOSUF = WOROUT.MTWORO_WOSUF
AND WORKORD.MTWO_WIP_WOPRE = WOROUT.MTWORO_WOPRE
AND WORKORD.MTWO_WIP_STATUS <> 'R'
AND WOROUT.MTWORO_WC='OLD WC' ;

You need to run each sql statement for each "OLD Work Center", unless there is something common among them: check previous posting (Lynn)
Example:

UPDATE ROUTING SET MTRO_WC = 'LATHES' WHERE MTRO_WC LIKE 'LAT%';

Have fun,

;)

Kelloggs

Disclaimer: I accept no liability for the content of this post, or for the consequences.....

Please test it on a play company!!!!

:P