DE-K Global Field Change

Purpose of Program

This program can be very useful for entering or changing field values globally across many records.  For example, in your accounting system a purchased item might be coded with an inventory type P.  Here, the inventory type code for purchased items is an R.  Rather than have to individually change every inventory record, you can use the global field change program to change all records with a type P to a type R The program only changes critical fields listed on the error reports.

General Program Operation

First you are presented with a choice of four files with which the program can be used.  Highlight the file you want to work with and press <Enter>.

Next you are presented with a  window listing the critical fields within that file that can be globally changed.  Highlight the field you want to work with and press <Enter>.

If you want to superimpose a field value on all records in the file, answer Y to Replace all values? For example, you might want all items to have a selling unit of measure of EA.  The cursor then moves to the Value to replace with? field.  You would enter "EA" and press <Enter>.  The program will then superimpose the value "EA" in the selling unit of measure field for all records within the file.  

If you want to replace a particular value only within specific records, answer N.  You are then asked for the value to search for.  In our inventory Type example, you would enter a P. Enter the value to replace with, which in  our example would be an R.  The program will then automatically replace all P values in the inventory field with an R.