Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC330


IC330 - Item Mass Change



    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 form
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

    BUYER      -

    CKPOINT    -

    ICAUDIT    -

    ICCOMPANY  -

    ICITEMCODE -

    ICLOCATION -

    ITEMLOC    -

    ITEMMAST   -

    ITEMSRC    -

    ITSERIAL   -

    SOHDETAIL  -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    APACCRCODE -

    APCOMPANY  -

    APVENGROUP -

    BINSTORAGE -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYVENPF   -

    COMPONENT  -

    CUCONV     -

    CURELAT    -

    GLCODES    -

    GLSYSTEM   -

    HAZARD     -

    ICBIN      -

    ICCATEGORY -

    ICDICT     -

    ICFGBYPROD -

    ICFORECAST -

    ICGENERIC  -

    ICMANFCODE -

    ICRPTGRP   -

    ICVALUOM   -

    INSTCMDTY  -

    ITEMGROUP  -

    KITITEM    -

    MAJORCL    -

    MINORCL    -

    MXCATDEF   -

    MXOBJCAT   -

    POCOMPANY  -

    POMXVAL    -

    PROCUREGRP -

    RQLOC      -

    TXTAXRATE  -

    WFSETUP    -

    WHDEMAND   -


INVOKED Programs

    API3
    ACAC
    ACTA
    API4
    IFAC
    IFCU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    IFUP
    ICI1
    POBL
    POIH