ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Updating Item Class
http://www.istechforum.com/YaBB.pl?num=1301954849

Message started by PaulG on 04/04/11 at 15:07:29

Title: Updating Item Class
Post by PaulG on 04/04/11 at 15:07:29

Is there a utility to change all item classes (or batch)? I tried DE-K but that utility does nothing.

Evo-ERP Update 1/18/11

Title: Re: Updating Item Class
Post by Lynn_Pantic on 04/04/11 at 15:45:28

What exactly are you trying to do? Change all parts belonging to class ABC to class 123?

Title: Re: Updating Item Class
Post by PaulG on 04/05/11 at 11:14:26

Yes that would work. Or just change all parts to class 123.

Title: Re: Updating Item Class
Post by Kelloggs on 04/05/11 at 13:59:50

Before doing anything backup your BKICMSTR table

Then you can run this script
It will change all parts that start with the word ORANGES (Item Number) to class 123

UPDATE BKICMSTR SET BKIC_PROD_CLASS = '123' WHERE BKIC_PROD_CODE LIKE 'ORANGES%'

or

UPDATE BKICMSTR SET BKIC_PROD_CLASS = '123' WHERE BKIC_PROD_CLASS = 'OLD'

it will change parts with OLD class to 123

:P

Kelloggs

Title: Re: Updating Item Class
Post by Lynn_Pantic on 04/05/11 at 19:17:00

You need to update both the BKICMSTR and MICMSTR tables if you want to change the class.

Title: Re: Updating Item Class
Post by Kelloggs on 04/07/11 at 06:47:24

For the MTICMSTR

UPDATE MTICMSTR SET MTIC_PROD_CLASS = '123' WHERE MTIC_PROD_CODE LIKE 'ORANGES%'
UPDATE MTICMSTR SET MTIC_PROD_CLASS = '123' WHERE MTIC_PROD_CLASS = 'OLD'

and dont forget to backcup!!!

:P

Title: Re: Updating Item Class
Post by dameng on 05/19/11 at 09:22:28

Quote:

and dont forget to backcup!!!

what's a backcup? is the like a frontcup but only backwards? :P