SM-J-N  Change Vendor Codes

Purpose of Program

Use this program to change a vendor code across all files in the system that contain records for that vendor code.  The program can also be used to merge vendor history together if a vendor is set up with 2 codes or one vendor buys out another.

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

General Program Operation

Enter the existing vendor code or look one up via the F2 key (or click on the Lookup button) in the Old Vendor Code field.  Enter the new vendor code in the New Vendor Code 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 vendor code records get changed.

Automated Option

If you need to change or merge a number of Vendors, you can create a comma delimited file of Old Code, New Code  using Excel and then enter the file name on the top part of the screen.     The program will then step through the file unatttended processing each one.