Miscellaneous Utility Programs

You can renumber your entire customer database, changing all of your customer account numbers, using the ;SPCCUST program. You can also change individual account numbers.

Note: This is a dedicated function. Make sure that no one else uses the system until this procedure is complete.

Before you renumber your customer database, go to the (Z) System Utilities screen and select the [C3] Copy All Files function, and back up all of the files on your system. This ensures that you do not lose any information if an error occurs during the renumbering.

  1. Double-click graphics\KEYOPMENUICON16.gif.

  2. When the Keyop Menu opens, double-click graphics\SYSTEMUTILITIESICON16.gif. The (Z) screen opens.

  3. In the Enter Utility Type field, type B. In the Enter Subset Number field, type 4.

  4. At the Enter File Name field, type ;SPCCUST

  5. In the Enter Unit # field, type Ø4.

  6. The Customer Account Number Conversion Program screen appears. The cursor moves to the New Starting Customer Number field. At this point, you have the option of specifying the new starting customer account number or specifying a number which all be added to all account numbers. To specify the starting customer account number, go to Step 7.

    To specify a number to which all account numbers are added to consecutively, press Tab and go to Step 8.

  7. In the New Starting Customer Number field, enter the number for customer accounts to begin numbering with. For example, to begin renumbering account numbers with 100, enter 100. If you enter fewer than ten characters, press Tab. Go to Step 9.

  8. In the Add to Customer Number field, enter the number to add to existing account numbers. Suppose you have account numbers that are now numbered 1, 15, 300. If you specify 500 in this field, the system adds 500 to each account number (501, 515, and 800).

  9. In the Starting Number to Alter field, enter the account number from which renumbering begins. For example, to renumber beginning with account number 1000, enter 1000. If you enter fewer than ten characters, press Tab.

  10. The cursor moves to the Old Number field. The Old Number and New Number fields let you change up to eight individual account numbers. In the Old Number field, enter the account number to change. If you enter fewer than ten characters, press Tab. In the New Number field, enter the new account number. For example, to change account number 452 to 1000, you would enter 452 in the Old Number field and 1000 in the New Number field. When you finish changing account numbers, press Enter.

  11. The cursor moves to the Volume Serials From field. When you renumber account numbers, you must renumber your customer files. However, you have the option of specifying whether accounts receivable files, serial files, telemarketing files, sales journals, and renamed sales journals are renumbered.

    In the Volume Serials From field, enter the volume serial where customer files are located, or press Tab to accept the default, which is the volume serial specified in the (LØ) Global Master Parameters screen.

  12. The cursor moves to the Accounts Receivable field. Specify whether to renumber account numbers in these files. To renumber accounts receivable files, press Enter or type Y.

  13. In the corresponding Volume Serials From field, enter the volume serial where these files are located, or press Tab to accept the default, which is the volume serial specified in the (LØ) screen.

  14. In the Volume Serials To field, enter the volume serial to which to move the file, or press Tab to accept the default, which is the volume serial specified in the (LØ) screen.

  15. The cursor moves to the Serial Files field. Specify whether to renumber account numbers in the serialized inventory files. To renumber serial files, press Enter or type Y.

  16. In the corresponding Volume Serials From field, enter the volume serial where these files are located, or press Tab to accept the default, which is the volume serial specified in the (LØ) screen.

  17. In the Volume Serials To field, enter the volume serial to which to move the file, or press Tab to accept the default, which is the volume serial specified in the (LØ) screen.

  18. The cursor moves to the Telemarketing Files field. Specify whether to renumber account numbers in these files. To renumber telemarketing files, press Enter or type Y.

  19. In the corresponding Volume Serials From field, enter the volume serial where these files are located, or press Tab to accept the default, which is the volume serial specified in the (LØ) screen.

  20. In the Volume Serials To field, enter the volume serial for the file to be moved to, or press Tab to accept the default, which is the volume serial specified in the (LØ) screen.

  21. The cursor moves to the JOURNAL-S FILES field. Specify whether to renumber account numbers in your sales journals. If you specified N in the JOURNAL-S FILES field, go to Step 27.

    If you specified Y in the JOURNAL-S FILES field. Go to Step 22.

  22. The cursor moves to the File Name field. At this point, you can renumber customer account numbers in JOUR-S or renamed sales journals. In the File Name field, press Tab to accept the default, JOUR-S, or enter the renamed sales journal to renumber.

  23. In the corresponding Volume Serials From field, enter the volume serial where these files are located, or press Tab to accept the default, which is the volume serial specified in the (LØ) screen.

  24. In the Volume Serials To field, enter the volume serial for the file to be moved to, or press Tab to accept the default, which is the volume serial specified in the (LØ) screen.

  25. The Correct prompt appears. If the specified sales journals and volume serials are correct, press Enter or type Y. The cursor moves to the File Name field so you can enter the next sales journal.

Note: There is no limit to the number of sales journal files you can renumber.

  1. When you finish entering the names and volume serials of sales journals to renumber, press Tab when the cursor is in the File Name field.

  2. The system displays the Are You Sure prompt. Type Y. The system renumbers the specified files.

Note: If the files you are copying already exist on the specified volume serial, the system displays the Customer Files Already Exist On The To Vol Ser message. Press Enter. The You Must Correct This Problem Before Continuing message appears. Press Enter. The cursor returns to the Master Menu.