Re: part numbers

We did a part number conversion here. It took several months. The time 
consuming task was the need to remark items that were in inventory. We also 
needed to remark drawings for our manufactured items. I would recommend 
breaking up the job into groupings that make sense for your organization. Here 
we broke up the job by manufactured/purchased by product group minor. We 
completely fininshed one group before starting another.
 
In our case, we stored the old part number as an alternative reference (INP38) 
in case a customer called using the old version.
 
The approach we took was to write a generic SQL statement that referenced a 
file that contained the filename and field name that contained the part number. 
A second file contained the old part number and the new part number. 
 
The file containing the places in the JBA database that contain part number may 
not be complete for your situation. We do not use all of JBA's modules. In 
addition, the list also contains files and field names that were developed for 
custom applications. Contact me off list if you would like the file.
 
Greg

Mona Ferriols <mon.ferriols@xxxxxxxxxxxxxx> wrote:
Hi 

We have been directed by the lords above to convert to a new part numbering
system. Anyone out there who has experience in this? Any inputs (encouraging
and discouraging would be welcome). Also, any material re: this would be
heaven sent. Thanks.

Mon Ferriols 
Data Management and Control
Ionics EMS, Inc. Plant 7
Tel: (049) 545-9751
Email: mon.ferriols@xxxxxxxxxxxxxx
Web: www.ionicsgroup.com

"ERP is not just computers and software, but PEOPLE, PROCESSES and
FUNCTIONS."


###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.