Use the Numbering tab to view the current formats for your firm's record identification numbers, and to set up auto numbering for records.
You can set up auto numbering for records in the hubs. You can also set up numbering formats for user-defined components. When you create a user-defined hub that includes a
Number field, a row is added to the Numbering tab, and you can define the numbering structure for the new hub.
To change the length and format of key fields, use the Key Formats utility.
Contents
Field | Description |
System Numbering Format Drop-down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
System Label
|
This column displays the system label.
|
Length
|
This column displays the length, in characters, of the system label.
|
Leading Zeros
|
This Yes/No field indicates whether or not the label includes leading zeros.
|
First Delimiter
|
This column displays the position of the first delimiter.
|
First Delimiter Position
|
This column displays the location of the first delimiter position.
|
Second Delimiter
|
This column displays the position of the second delimiter.
|
Second Delimiter Position
|
This column displays the location of the second delimiter position.
|
Auto Number Source
|
If you use automatic numbering, select one of the following options as the source for the auto numbering. These options let you create custom formats for your auto numbers.
-
Custom Method
-
Expression
-
Stored Procedure
-
Web Service
-
<None>: Select this option to disable auto numbering for the associated hub.
|
Auto Number Format
|
If you select an auto numbering source in the
Auto Number Source column, this column is enabled and required. Click in this column and then click the ellipsis icon to open the Expression Configuration dialog box. The contents of the dialog box reflect your selection in the
Auto Number Source column.
After you define a format,
<auto number defined> displays in this column.
|
Allow Override of Auto Number
|
Select the check box in this column to allow the user to enter a different number before the auto number is generated for a record.
When you enter a non-automatic number,
Deltek checks for duplicate records and, if it detects one, displays the Potential Duplicate Records Found dialog box. This dialog box identifies the name and number of the existing record that exactly matches the number that you are trying to add.
If an auto number has been generated, you must run a Key Conversion to change the number.
|