ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> SM-J-L Change Part Numbers
http://www.istechforum.com/YaBB.pl?num=1206453482

Message started by gtladmin on 03/25/08 at 06:58:02

Title: SM-J-L Change Part Numbers
Post by gtladmin on 03/25/08 at 06:58:02

How exactly does SM-J-L Change Part Numbers work? Does it go through everything and make the changes? What about open orders, open work orders, purchase orders, BOMs that have the part # on it, etc.? If we change a part that is ABCDE to be ABCEDF, and it's a component of a couple dozen other parts, do all the corresponding parts' BOMs also get changed? In our case, part ABCDE shows up "where used" for at least a few dozen other parts in the system.

Is this a utility where we have to do it all at once, where we can't schedule the time to get a few parts at a time done? Since it has to be done with no one on the system, and it could potentially take a long time for each part, it seems a bit daunting to think we have to do it all at once, especially given the number of part numbers we need to update.

Please, I need some help/advice here before we think of proceeding.

Val

Title: Re: SM-J-L Change Part Numbers
Post by RPCAdmin on 03/25/08 at 07:19:33

I'm sure Allen could verify it for us, but I believe it effectively replaces the instance of the part with the new part number, so that any bills of materials are updated. So you should be able to change as you need to, although it is always best to fully update a BOM for a product completely.

One caution though (Again Allen can confirm), Any PO's that have been generated with the old part number will NOT be updated with the new part number (not sure if this works for Sales orders). I think the system takes a "snap shot" of the PO RTM in essence, at the time of the generation of the PO.

Title: Re: SM-J-L Change Part Numbers
Post by gtladmin on 03/25/08 at 10:39:41

Thanks for the reply, Mike. Allen or Lynn, can you confirm what Mike is saying? Can you give me any additional input? What is your recommendation as far as doing any preparations (besides the backup) prior to running this?

Thanks,

Val

Title: Re: SM-J-L Change Part Numbers
Post by Lynn_Pantic on 03/27/08 at 15:27:46

SM-J-L changes EVERYTHING - BOMs, historical orders, open orders, transaction history, you name it.

Title: Re: SM-J-L Change Part Numbers
Post by gtladmin on 03/28/08 at 06:28:40

Hi Lynn,

I ran it last night on two of our largest parts and just watched the process. It did indeed appear to check every table, including the history tables, and when it found a record to be changed in a table it displayed on screen the "Record Found!" message. So, I asked Walter this morning to just look at parts and associated things like Work Orders, Sales Orders, Purchase Orders, costs, run some reports, etc. to see the changes and see if there are any issues. Hopefully there will be none. We have about 200 parts that need to be updated, so we want to be sure the test was good.

Thanks much--it is a pretty handy utility!

Val

Title: Re: SM-J-L Change Part Numbers
Post by RPCAdmin on 03/28/08 at 06:55:01

:) I was working from an old musty memory. A colleague and I remember at one time (not sure how far back) that work order travelers had the problem that if you did a part number change, the bill on the reprinted traveler wasn't always correct. However, I just tested that and it seems to work fine, so it looks like SM-J-L works just the way it is supposed to. ;D ;D

Remember however, that if you have a traveler printed, and you change the number, that hard copy could still be floating around!

Title: Re: SM-J-L Change Part Numbers
Post by RPCAdmin on 03/28/08 at 07:01:17

Actually - I finally remembered the quirk (gad the memory goes fast)

You have a BOM in the system and you generate a WO for the assembly.
You discover that the BOM is incorrect and edit the BOM.
If you reprint the traveler, it will still show the uncorrected BOM.

Title: Re: SM-J-L Change Part Numbers
Post by gtladmin on 03/28/08 at 08:37:08

Thanks Mike, I just forwarded your comments onto Walter, who will check that aspect of the changes as well. I appreciate the input!

Val

Title: Re: SM-J-L Change Part Numbers
Post by Lynn_Pantic on 03/31/08 at 07:29:33

Mike is correct. If you simply edit a BOM or Routing (BM-A and RO-A) and work order(s) already exist for the parent item, those changes will not appear on the pre-existing work orders. Also, the BM-E and BM-F Component Replace and Delete utilities only work on the BOM Master and do not touch pre-existing Work Orders. But SM-J-L gets it all.

Title: Re: SM-J-L Change Part Numbers
Post by cmisouth on 06/30/08 at 09:33:09

Is there a list of the files affected by SM-J-L?
I'd be very interested in knowing all the files changed.

Title: Re: SM-J-L Change Part Numbers
Post by kkmfg on 06/30/08 at 10:32:37

cmisouth wrote:

Is there a list of the files affected by SM-J-L?
I'd be very interested in knowing all the files changed.

Well... Ok... You asked... There are probably repeats and this is grep'd from an older copy of the source code. I WOULD have used a newer copy but well... I can't...

open BKICMSTR lock R
open MTICMSTR lock R
open BKAPPOL lock N
open BKARINVL lock N
open BKARTXN lock N
open BKBMDIM lock N
open BKBMDIM lock N
open BKBMMSTR lock N
open BKBMMSTR lock N
open BKBMNOTE lock N
open BKBMREMK lock N
open BKBMREMK lock N
open BKICDIM lock N
open BKICDIM lock N
open BKICDIM lock N
open BKICLOC lock N
open BKICPMAT lock N
open BKICREF lock N
open BKARINVI lock N
open BKMATCST lock N
open BKMRPFC lock N
open BKMRPSW lock N
open BKMRPPO lock N
open BKRTCST lock N
open BKRTSPEC lock N
open BKSHORT lock N
open BKSHORT lock N
open ESTSUM lock N
open DBAFIFO lock R
open INVTXN lock N
open LOT lock N
open MTMRP lock N
open OUTPROC lock R
open ROUTING lock N
open SERIAL lock N
open WOBOM lock R
open WOBOMREM lock R
open WOEXCHG lock R
openv "WOLABOR" fnum wolabor_hndl lock R
open WOMAT lock R
open WORKORD lock R
open WORECV lock R
open WOROUT lock R
open BKAPHPOL lock N
open BKRFQ lock N
open BKAPQUOT lock N
open BKAPRFQL lock N
open BKARHIVL lock N
open BKARRIVL lock N
open BKARTXNS lock N
open BKESTQTL lock N
open BKQCMSTR lock R
open BKPIFROZ lock r
open BKPIPHYS lock r
openv 'BKPILOT' fnum bkpilot.hndl lock r
openv 'BKPISER' fnum bkpiser.hndl lock r
openv 'BKPILCNT' fnum bkpilcnt.hndl lock r
openv 'BKPISCNT' fnum bkpiscnt.hndl lock r
open BKICVAL lock R
open BKSBVEND lock R
open BKSBPART lock R
open BKSBMFG lock R
open BKEDIL lock R
open BKCMHCD2 lock R
open BKCMHCOD lock R
open BUCKETS lock R
open WOHEXCHG lock R
open WOBOMHRM lock R
open WOHBOM lock R
open OUTHPROC lock R
open WORKHORD lock R
open WOHRECV lock R
open WOHMAT lock R
openv "WOHLABOR" fnum wohlabor_hndl lock R
open WOHROUT lock R
openv "BKQCTRAN" fnum bkqctran_hndl lock R
openv "BKGLX" fnum bkglx_hndl lock R
openv "BKGLXH" fnum bkglxh_hndl lock R

Title: Re: SM-J-L Change Part Numbers
Post by cmisouth on 06/30/08 at 11:22:58

Thanks Collin,

That's good info to have. I'm trying to show our users how a small mistake can mushroom.