Mass updating items

Making mass changes to items is possible by running a batch program, Item Mass Change (IC330), regardless of whether you set up items via the Item Master or Item Location. Changes are made at the item group or company level, and the location or report group level. Leaving these fields blank means that all are reported on.

You enter up to three statements, indicating the group of item records that require change. You select:

  • a range of fields

  • greater than

  • less than

  • equal to

Making mass changes for the same item across locations saves time and reduces the possibility for error. The changes have no effective date, they are processed immediately. Each mass change affects one field only. IC330 is also used for making mass changes to vendor and replenish from locations and alternate units of measure.

Be aware that running IC330 does not update items at a par location. For more information, see Mass updating cart/par locations.

Note: Lawson recommends that you run IC330 in Report Only mode first, review the results, then run it in Report and Update mode.

To make mass changes to items

  1. Access Item Mass Change (IC330).
  2. On the Select Statement(s) tab, select the group of item records to be changed.

    Use the following guidelines to enter field values:

    Select Field

    Select an Item Master or Item Location field. The applicable table, field type and size, and number of decimals display.

    Note: You can use Item Master fields to define a change for an Item Location field, but not vice versa.
    Range Value 1

    Type the beginning range value.

    Operator

    Select an arithmetic operator for the range (equal to, greater than, greater than or equal to, less than, less than or equal to, not equal, and so on).

    Range Value 2

    Type the ending range value.

  3. On the Change Field tab, select the Item Master or Item Location field whose value you want to change for the item.

    Use the following guidelines to enter field values:

    Change Field

    Select the Item Master or Item Location field to be changed for the item.

    New Alpha Value

    If the value being changed is alphanumeric, type the new value for the field.

    New Amount Value

    If the value being changed is an amount, type the new amount for the field.

    Change Percentage

    If the value being changed is a percentage, type the new percentage for the field.

    Increase or Decrease

    Select whether to increase or decrease by percentage.

    Change Value

    Type the value to be changed.

    Increase or Decrease

    Select whether to increase or decrease by value.

    Change Field to a Null Value

    Select Yes to change the field to spaces (if the field is numeric) or zeroes (if the field is alpha).

  4. On the Main tab, select the item and whether the report is in Report and Update or Report Only mode.

    Use the following guidelines to enter field values:

    Item Group or Company Group or Company

    Select the item group, company group or company to be affected by the mass item change. You define item groups using Corporate Item Group (IC00.1), company groups using Company Group (GL11.1) and companies using Company (IC01.1).

    Location or Report Group

    Select the item location or report group to be affected by the mass item change. You define locations using Item Location (IC12.1) and report groups using Report Group (IC03.1).

    Item

    Select the item to be changed.

    Report Only

    Select whether to report and update the item records, or report only.

  5. Optional. On the Item Source tab, change the vendor and purchase-from location, or the replenishment information (replenish from company, location, or bin).
  6. Optional. On the UOM tab, change an item's alternate unit of measure.
    From Alternative UOM

    Select the alternate unit of measure to be changed for the item.

    To Alternative UOM

    Select the new alternate unit of measure to be used for the item.