Item Mass Changes

  1. To make mass changes, go to the (+E) Special Item screen and select the [J] Mass Change function.

  2. The cursor moves to the By Item field. Type Y (yes) or N (no) in the By Item field to open the (+EJ) screen.

  3. This screen is divided into two columns: the Select On From column and the Change To column. In the Select On From column, specify what to change. The fields in the Change To column let you specify the changes to make. Specify the current setting for the field in the Select On column. In the Change To column specify the new setting.

Note: If you only complete the field in the Select On From column, that field acts as a limit. Suppose you want to change all Sparco items from department A to department B. You would enter A in the first DeptT field and B in the second Dept field. Then you would specify Sparco’s vendor number in the wholesaler Vendor # field in the Select On From column. You leave the second Vendor # field blank. All Sparco item records with a department of A would new have a department of B. The Vendor # field in those records would not be changed.

  1. When using the Select On column to limit, you can set as many limits as needed. An item record must meet all of the limits you set to be changed.

  2. Tab to each field to complete and enter the appropriate setting.

Note: You cannot mass change the key fields Item # and Co. You can limit on these fields, but the system does not mass change these fields.

  1. The cursor moves to the Source Location field and the A Location Must Be Input message displays. If you are changing location-specific fields, enter the G/L location. Otherwise, enter the master location. If you enter fewer than two digits, press Tab.

  2. The Are You Sure prompt displays. Type Y. The system displays the following information for each record that meets the limits you set:

    Item number    
    Company    
    Description
    Buy unit

    If you type N in the By Item field, the system changes all the records that meet the limits you set, displaying each record in turn.

    If you type Y in the By Item field, the system displays information for each record that meets the limits you set, one at a time. For each record, the Process This Record prompt displays. To change the displayed record, press Enter or type Y.

    To not change the displayed record, type N.

  3. When all of the records have been displayed, the End of Records Any Key to Continue prompt displays. Press Enter.

Return to:

Additional (+E) Screens