Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC330


IC330 - Item Mass Change

**Form Purpose
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 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 choose the field that needs to be changed.The
field type of the field chosen will determine which of the rest of the screen
fields may be used. If a Alphanumeric field is chosen, 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 Itemsrc tab to change Vendor and Purchase From Location information
or Replenish From information.




Updated Files

    CKPOINT    -

    ICAUDIT    -

    ICCOMPANY  -

    ICLOCATION -

    ITEMLOC    -

    ITEMMAST   -

    ITEMSRC    -

    ITSERIAL   -

    SOHDETAIL  -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    APACCRCODE -

    APCOMPANY  -

    APVENGROUP -

    BINSTORAGE -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCONV     -

    CURELAT    -

    GLCODES    -

    GLSYSTEM   -

    HAZARD     -

    ICBIN      -

    ICCATEGORY -

    ICDICT     -

    ICFGBYPROD -

    ICFORECAST -

    ICGENERIC  -

    ICITEMCODE -

    ICMANFCODE -

    ICRPTGRP   -

    INSTCMDTY  -

    ITEMGROUP  -

    KITITEM    -

    MAJORCL    -

    MINORCL    -

    POCOMPANY  -

    PROCUREGRP -

    RQLOC      -

    TXTAXRATE  -

    WHDEMAND   -


INVOKED Programs

    API3
    ACAC
    ACCL
    API4
    IFAC
    IFCU
    IFSG
    SLSE
    SLSU
    ICI1
    POIH