Item Mass Change (IC330)

Run Item Mass Change (IC330) to change information in the:

  • Item Master file
  • Item Location file

It can also be used to mass change Vendor or Replenish From Locations in the Item Source file.

More Information

This is a two step process:

  1. Define the group of records that need to be changed.

  2. Enter the field that will be changed and what it will be changed to.

Use the Main tab to establish the location or report group for the mass change and whether or not you want updating to occur. If Report Only is set to Y, no updating occurs, only the report will be run. If set to N, then updating will occur and the report is run. The report will list Group, Company, Location, Item, Description, Old Value, and New Value.

Use the Select Statement(s) tab to define a group of records that require some information to be changed. The fields selected for inclusion can come from the Item Master file and the Item Location file.

Note: Only Select Field 1 can be used with the DESCRIPTION3 item master field.
Note: Item Master fields alone can be used to define the change for an Item Location field, but Item Location fields cannot be used to define a group for Item Master field changes.

Enter up to three statements to define a group of items. The statements can be

  • a range of values
  • greater than
  • less than
  • equal to

The statements can also be used to find null values, which are zeros for numeric fields and spaces for alpha fields. You can string the statements together with the "and/or" connector

Use the Change Field tab to select the field that needs to be changed. The field type of the field selected will determine which of the rest of the form fields may be used. If an Alphanumeric field is selected, it cannot be changed by a percent. The changes allowed are:

  • new value
  • new amount
  • change percent
  • change value
  • change field to a null value

The change to null option will change the field value to zeros if the field is numeric and will change the value to spaces if the field is alpha.

Use the Item Source tab to change Vendor and Purchase From Location information or Replenish From information.

Related topics