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