Numeric Table Maintenance

Use Numeric Table Maintenance to maintain the table that sets up the user-definable numeric fields, which are an optional part of the G/L Account Master information.  During Numeric Table Maintenance you can assign the field label (field name) and special properties for the field to have.  While there are sixty separate numeric fields available, you only define as many fields as you need.

Notes:

• In addition, there are user-definable alpha fields that are an optional part of each master maintenance.  For more information, see Alpha Table Maintenance.

• For additional information about working with data in fields, see Data Entry Guidelines.

Directions:

To see directions for...

• Opening Numeric Table Maintenance, click More.

   

  1.  Click File Maintenance from the Menu Bar.

  2.  Click G/L Extended Labels Table.

  3.  Click Numeric Table.
  
  Or, use the keyboard shortcut:  [ALT] [m] [t] [n].

   

  Numeric Table Maintenance Window Example:

  

   

• Creating the new Numeric Table, click More.

   

  IMPORTANT:  You can not create a new Numeric Table.  The necessary table is created during the software installation and updates.  To maintain the Numeric Table, see the instructions for editing later in this topic.

   

• Editing the Numeric Table, click More.

   

  CAUTION:  To avoid losing data, you must save the changed record.

  1.  To display the record to be changed, simply open Numeric Table Maintenance.  The record automatically displays.

  2.  To position the mouse to the field to be edited, press [TAB] or click the field using the mouse.

  3.  Enter the data changes.

  4.  To complete the edit process, click Save or press [ENTER].
  Keyboard shortcut:  [ALT + s]

  Numeric Table Maintenance Prompts Tip:  To see more information about a field, click the hyperlink for the field name.
  	To update the new or changed information, click Save or press [ENTER]. Keyboard shortcut:  [ALT + s]
  	CAUTION To avoid losing data, you must save new or changed records.
  	Search is not active for this program.
  	Retrieve is not active for this program.
  Note:  There are three options for each field:  Numeric Field Label, Special Formatting, and Special Conditions.  Each column (one column for each of the three options) is described below along with the general instructions.
  Numeric Description 1 - 60	Displays the number of the field being maintained.
  Numeric Field Label	Enter the label or the title of the field. (up to 30 characters)
  Numeric Special Field Format	To specify the type of formatting for the field, click a choice in the drop-down list. Special Format Options: Number 1.0 - Format the field as a 1-digit number with no decimal places. Example:  1 Number 2.0 - Format the field as a 2-digit number with no decimal places. Example:  10 Number 12.2 - Format the field as a 12-digit number with 2 decimal places. Example:  100,000,000,000.00 Currency 12.2 - Format the field for currency as a 12-digit number with 2 decimal places. Example:  $100,000,000,000,00 Date (MM/DD/YYYY) - Format the field as a date. Example:  10/23/2006
  Numeric Field Special Conditions	To specify the special field conditions, click a choice in the drop-down list. Special Field Conditions: None - No special condition available for numeric fields.

• Deleting existing Numeric Table fields, click More.

  Important:  To maintain data integrity, you can not delete the Customer Labels Numeric Table.  However, you can delete a field label within the table.

  To delete a field within the Numeric Table:

  1.  To position the pointer to the field that you want to delete, press [TAB] or click the field using the mouse.

  2.  Press [DELETE] or [BACKSPACE] to remove the entire field label.

  3.  To complete the field delete, click Save or press [ENTER].