To reformat the length, delimiter, and/or delimiter position for your vendor record numbers, use the Key Format utility for vendor numbers.
Warning: If your company uses an on-premises deployment of
Vantagepoint, Deltek strongly recommends that you create a backup copy of your database before running the utility. There is no way to undo this process without a backup database.
If your company has an on-premises deployment of
Vantagepoint, your company manages your database backup. If your company has a cloud-based deployment of
Vantagepoint, coordinate with Deltek about your database backup.
To reformat vendor numbers:
-
In the Navigation pane, select
.
-
On the Vendor Number Format form, for the
Display Leading Zeros option, select
Yes to automatically add leading zeros to the vendor number when you enter an incomplete number in any
Vendor field.
-
In the
Field Length field, enter the vendor number length.
The
Add/Remove Length From option displays.
-
In the
Add/Remove Length From option, select
Left or
Right to identify where you want to add or remove characters from the vendor number.
-
In the
Field Delimiter field, enter the delimiter, such as a comma or period, for your vendor numbers.
-
If you specify a delimiter symbol, use the
Field Delimiter Position field to specify the symbol's position in the vendor number.
-
Review the value in the
Sample Value field to see the format as it will be after the key format utility is run.
-
Click
Run.