Using the Synchronize Next Keys Form

This topic describes the features on the Synchronize Next Keys form.

Contents

The grid on this form contains this information for each alphanumeric key that can have a prefix:

  • Description of the table and column where the key resides
  • Value of another primary key column (applies only to Bill of Lading and Project Bill of Lading)
  • Prefix used for the key
  • Last value used with that Prefix and Sub Key combination at the local site.

This information can help you determine if some values are not being used as planned. For example, if someone accidentally entered "PO40000" instead of "PO400" on a new purchase order, you would run out of available numbers with that prefix much sooner than planned. If you catch it before more orders are entered, you could delete the problem order and add it back with the correct number.

Comparing Before and After Values

Before you click Process to run the utility, we suggest you copy the grid to a spreadsheet. Then, after the utility completes, compare the values in the grid to the saved values in the spreadsheet to see what (if anything) changed.