RE: Changing Product Numbers

Gary,

Yes it is possible.  It is relatively straight forward, although a pain.
Someone is going to have to go through and identify all of the database
files and fields that need to be changed.  Additionally, you will need to
remember keep in mind those files where the item number may exist in more
than one field (which I believe happens in Manufacturing, but I am not sure
where else).  You will also need to take into account any data that has been
extracted to other platforms for reporting purposes, especially if it is
being kept on those platforms for historical reasons.  The program itself
will not be complicated.

Good Luck.

John McPherson,
Fossil Partners, LP



-----Original Message-----
From: Gary.Brown@appliedchemicals.com
[mailto:Gary.Brown@appliedchemicals.com]
Sent: Wednesday, August 09, 2000 7:42 PM
To: JBAUSERS-L@midrange.com
Subject: Changing Product Numbers




We are in the unfortunate situation where we need to change the structure of
our
product numbers.

Quite simply our current structure is nnnn-nn where the first four digits
are
the product code and the last two digits are the pack size, e.g. 4500-25

The problem that we have is that we have run out of product codes and so we
wish
to change our structure to nnnnn-nn (adding an extra digit), to maintain
consistency across product numbers we want to change our existing product
numbers to have an extra zero at the end, so my example product above would
become 45000-25.

We of course want to retain our product history and so all history records
will
need to be changed to reflect the new code as well as changing the product
file.

Question: Is this possible, has someone written a bespoke program to do
this.

Thanks in advance.
Gary.


+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---