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 theItem 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 masschange and whether or not you want updating to occur. If Report Only is set toY, no updating occurs, only the report will be run. If set to N, then updatingwill 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 requiresome 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 ItemLocation 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 canbe - a range of values - greater than - less than - equal to The statements can also be used to find null values, which are zeros fornumeric 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.Thefield 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 bya 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 fieldis numeric and will change the value to spaces if the field is alpha. Use the Itemsrc tab to change Vendor and Purchase From Location informationor Replenish From information.

Updated Files
BUYER - No Description Available.
CKPOINT - No Description Available.
ICAUDIT - No Description Available.
ICCOMPANY - No Description Available.
ICITEMCODE - No Description Available.
ICLOCATION - No Description Available.
ITEMLOC - No Description Available.
ITEMMAST - No Description Available.
ITEMSRC - No Description Available.
ITSERIAL - No Description Available.
SOHDETAIL - No Description Available.
TXCODEMAST - No Description Available.
TXCOMPANY - No Description Available.
TXTAXCODE - No Description Available.
TXTAXTABLE - No Description Available.



Referenced Files
None.



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




File created: Thu Jun 09 11:18:11 2016

Nogalis, inc.
Contact Us

All trademarks and registered trademarks are the property of their respective owners.