RE: Changing of Item Numbers

[Rusty Jackson <rustyjackson@xxxxxxxxx>]

I agree that EXTREME CAUTION should be taken when doing this.  However, I have 
had a few clients that have a that have insisted that I write programs to 
allow them to accomplish the task (I am a third-party consultant/programmer 
that primarily works with MAPICS accounts).  I have done it successfully 
without a glitch changing the item numbers in all of the MAPICS files 
including orders & schedules for COM, PUR, and REP. Obviously, the MAPICS 
applications installed dictate what files are on your system and need to be 
changed.

Good luck and be careful!

Rusty Jackson
Rusty Jackson & Associates
Knoxville, TN


>===== Original Message From MAPICS-L@midrange.com =====
>There would be a lot of files that would be affected.  Think of all the
>records in history that will need to be changed.  I not sure this is such a
>wise move.
>
>-----Original Message-----
>From: Shurge, Stephen (MTL) [mailto:sshurge@recochem.com]
>Sent: Friday, July 13, 2001 1:09 PM
>To: 'MAPICS-L@midrange.com'
>Cc: Shurge, Stephen (MTL)
>Subject: Changing of Item Numbers
>
>
>
>I am looking to see if anyone has developed a way of changing one item
>number to another item number throughout the entire
>Mapics database.
>
>If anyone has a list of all the fields and files that need to be changed
>would be a good starting point.
>
>I have a cross referencing utility (Hawkeye) that I can use to help me but
>would sooner use a proven method if available.
>
>
>Steve Shurge
>Recochem Inc.
>850 Montee de Liese
>Montreal, Quebec
>H4T 1P4
>Phone # 514 341 3550 ext 2655
>Fax #     514 341 1292
>Email :  sshurge@recochem.com
>
>+---
>| This is the MAPICS Mailing List!
>| To submit a new message, send your mail to MAPICS-L@midrange.com.
>| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
>daveshaw@bellsouth.net
>+---
>+---
>| This is the MAPICS Mailing List!
>| To submit a new message, send your mail to MAPICS-L@midrange.com.
>| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: 
daveshaw@bellsouth.net
>+---

+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
|daveshaw@bellsouth.net
+---