Modifying Inventory Files

The ;SPCCHG_IT Program

When you load an item file update from O/PUS or another item file service, some item numbers may change. The O/PUS update changes the old item numbers to the new item numbers in the item files. You must run the ;SPCCHG_IT program to change the old item numbers to the new item numbers in all additional files.

This program runs off of the NEW-C-ITEM file. This file is created when you load an item file update from O/PUS. You can also create the NEW-C-ITEM file when you run your (MA) (daily backup) procedure. If you create this file through the (MA), it records the item numbers you changed manually during the day.

The ;SPCCHG_IT program updates the following files:

•  I-MASTER (Item File)

•  I-MFG (Item Manufacturer File)

•  I-WHL (Item Wholesaler File)

•  I-PRICE (Item Price File)

•  I-COLUMNS (Item Column File)

•  I-AUX (Item Aux File)

•  I-HISTORY (Item History File)

•  I-ALIAS (Item Alias File)

•  CONTRACTS (Item Contracts)

•  PO-MASTER (P/O File)

•  PO-SPECIAL (P/O Special File)

•  P-MASTER (Pick File)

•  P-SPECIAL (Pick Special File)

•  LOST-SALES (Lost Sales File)

•  JOUR-S (Sales Journal File)

•  JOUR-U (Quarterly Usage Journal File)

•  JOUR-PO (P/O Journal File)

Classic Serial Files on New System

•  SER-MASTER (Item Serial File)

•  SER-AUX (Serial Aux File)

•  SER-CALLS (Serial Calls File)

•  SER-RSPNS (Serial Response File)

New Serial Files on New System

•  Z-MASTER (Serial Master File)

•  Z-DEFAULTS (Serial Item Defaults File)

•  Z-METER (Serial Meter Master File)

•  Z-C-METER (Serial Meter Defaults File)

•  Z-ITMINDEX (Serial Item Index File)

1. Double-click .

2. When the Keyop Menu opens, double-click . 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 ;SPCCHG_IT and press Tab.

5. In the Enter Unit # field, type 04.

6. In the Input Source Item File field, press Tab to accept the default file, NEW-C-ITEM, or enter the correct file name.

7. In the Volume field, enter the volume serial set for your work unit in the (LØ) Global Master Parameters screen, or press Tab to accept the default.

8. In the Convert Sales Journal Only field, specify whether to convert only sales journals, or to convert all files. To convert all files, go to Step 11.
   
   To convert only sales journals, type Y.

9. In the Enter Journal Name field, enter the name of the converted sales journal file.

10. In the Volume field, enter the volume serial where the file is located. Go to Step 13.

11. To convert all files, press Tab or type N.

12. The cursor moves to the Convert Item Aux field. Specify whether to transfer the item history from the old item number’s record. To transfer item history from the old item number’s record to the new item number’s record, type Y. To reference the old item number to the new item number without transferring the item history to the new item number’s record, type N.

13. The system displays Are You Sure prompt. Type Y. When the ;SPCCHG_IT program finishes, the Be Sure to Run Compression prompt appears. Press Enter.

14. You must reindex the files P-MASTER, JOUR-S, and JOUR-PO after the ;SPCBUTT and ;SPCCHG_IT programs finish.
    
    For instructions on reindexing P-MASTER or JOUR-S, go to Reindexing Order Entry.
    
    For instructions on reindexing JOUR-PO, go to Reindexing Archived Purchasing Information.

Return to:

The ;SPCBUTT Program