corporate products customer support partners contact us

Record Key Changes Program

Built into our software is the ability to re-assign and/or merge records within the system.  This can be done on any data file being used.  For example, in situations where duplicate record are set up in a file (for example 2 records for same customer, or product), those records can be merged together, and all tables and history referring to the original record will be changed to the new one specified.

Moving  Invoice History between Accounts

Invoices may have been produced for customers under a Miscellaneous or Cash Sales account previous to an account being established.  It may be desirable to move those invoices to the new account after the fact.  To do this , run the key change procedure against the customer file, using the "In Conjunction With" option, specifying the value INVOICE #.  This will move only selected invoices from the original account, to the new one.

Quick File Maintenance Program

Quick file maintenance is a tool that can be used to rapidly change a single or multiple fields within all or selected records in a file.  It can also be used to build a quick on screen inquiry.

A common use may be to change a field for all records that meet a certain condition to a new value.  For example, say you want to change a supplier code within your inventory.

You simply enter the program from inventory file maintenance, select change mode, and use the message rule
[VENDOR NO]="OLDONE" (padding the old code to full six characters withing the quotes). When the first record is found, change the Vendor to the new value.  Now use [F8] to change all subsequent records to the new value.