Item Mass Changes

  1. To access the specials screens, double-click graphics\KEYOPMENUICON16.gif and double-click graphics\SPECIALSICON16.gif. The (+) Special Programs screen opens.

  2. Type E, Modify Inventory Records. The (+E) Special Item screen displays.

  3. Type A, then type Y (yes) or N (no) in the By Item field to open the (+EA) screen. This screen lets you move the cost or price of an item from one area to another, and at the same time allows you to raise or lower that cost or price by a specified percentage. For information about using the (+EA) screen, see Using the (+EA) Screen.

Warning: Use extreme caution when using these functions. ECi recommends that you perform a backup before any mass changes or deletions are performed.

  1. The (SPE) Special Item Screen appears with the cursor in the Select Field to Update field. This screen lets you move the cost or price of an item from one area to another, and at the same time allows you to praise or lower that cost or price by a specified percentage. Enter the number of the field to update. For example, to update the Direct Buy Cost fields, type 1. For more information on the fields in this screen, go to In the (+EA) Screen.

  2. The Select Field to Base Update prompt displays. Enter the number of the field on which to base the update. Using our earlier example, to update the Direct Buy Cost fields based on the Wholesaler Cost fields, type 5. For more information on the fields in this screen, go to In the (+EA) Screen.

  3. The Select Percent to Increase or Decrease prompt displays along with the Multiplier prompt. The Select Percent to Increase or Decrease prompt allows you to enter a percent to increase or decrease the selected cost. For example, to decrease the percentage, you would type -34.5. To increase the percentage of the selected cost, you would type 34.5. The Multiplier prompt makes currency conversions easy. It multiplies a figure you enter by the value in a selected field. To multiply the value, type Y in the Multiplier field.

  4. The Create Records if None Exists prompt displays. At this prompt, you can specify to create a record if none exists. For example, if you specified to update the cost in the Primary Wholesaler Record and no Primary Wholesaler Record exists for the item, you can let the system create a Primary Wholesaler Record for the item. To create the specified record if one does not exist, type Y. To only update records that already exist, type N.

  5. The (+E) Special Item Selector screen displays. In this screen, you can limit the changes you are making to item records within a particular range. This screen is divided in half, with the From limits on the left side and the To limits on the right side.

Note: If you do not specify a limit range, the system changes costs and prices for all items.

     To not set limits, press Enter until the cursor moves to the Source Location field. Go to Step 9.

To set limits, tab to each field to limit by and enter the beginning of the range to include in the changes in the From column, and enter the end of the range to include in the changes in the corresponding To column.

Note: To limit the changes to one range, enter the same range in both the From and To fields. For example, to limit the changes to item records with stock class B, enter B in both the From Class field and the To Class field.

  1. After you set limits or move the cursor past the limit fields, the cursor moves to the Source Location field. The A Location Must Be Input message displays. Type 1 and press Enter.

  2. In the Destination Location field, press Enter.

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

    Item number
    Company
    Description
    Class
    Selling unit

    If you specified N in the By Item field, the system changes all the records that meet the limits you set, displaying each record in turn. Go to Step 15.

    If you specified 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 appears. To not change the costs or prices for the displayed record, type N. The system displays the next record that meets the limits you set and repeats the Process This One prompt. To change the costs or prices for the displayed record, type Y.

  4. After changing the displayed record, the system displays the next record that meets the limits you set and repeats the Process This One prompt. (The screen does not reflect the changes.)

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

Return to:

Using the (+E) Screen

In the (+E) Screen