<< Click to Display Table of Contents >>

SM-J-L Change Part Numbers

Purpose of Program

Use this program to change a item number across all files in the system that contain records for that item number.  Generally this is used during system start-up when item numbers are subject to revision or as part of an overall renumbering of item numbers.  It can also be used to merge together history of exiting numbers if multiple items were set up that really are the same thing.

CAUTION: Be aware that this program changes history files as well as master files.

Manual Program Operation

Enter the existing item number or look one up via the F2 key (or click on the Lookup button) in the Old Part No field.  Enter the new item number in the New Part No field.  You are then given a warning that this program could take possibly hours to run, depending on the size of your data files.  If you elect to proceed you will see each file name display in sequence as the item number records get changed.

Automated Option

If you need to change or merge a number of items, you can create a comma delimited file of Old Part, New Part  using Excel and then enter the file name on the top part of the screen.  The program will then ask which information to keep in the event that both parts already exist (a merge).    The program will then step through the file unatttended processing each one.