Expose API Endpoints to Manage Company and Accounting Period Settings
 
General and Configuration API endpoints for managing company and accounting period settings are now available. These new API endpoints honor existing validations and restrictions as well as security requirements at the application level.

Expose the GET Roles API Endpoint and Update the GET Users API Endpoint

To further support email integration, the GET Roles API endpoint is now available. This endpoint retrieves a list of available roles for Vantagepoint users. This new API endpoint honors existing validations and restrictions as well as security requirements at the application level.

In addition, the GET Users API endpoint has been updated to expose the EmployeeEmail field.

Bank Feed in Vantagepoint On-Premises Product

If you are using the Vantagepoint on-premises product, you can now set up a bank feed in Settings » Cash Management » Banks to connect Vantagepoint to your bank and automatically import bank transactions in Bank Reconciliation. For information, see Bank Feed in the online Help.

Automatic Creation of Cash Receipts

To streamline reconciliation tasks, you can now automatically create cash receipts from Bank Reconciliation (Cash Management » Bank Reconciliation). On the Import tab of the Bank Reconciliation form, hover over an imported receipt in the Imported Records grid, click [NOTE ICON] or [OPTIONS ICON] » Create Cash Receipt to display the Invoice Lookup dialog box for Bank Reconciliation.

 

Create and Modify Cash Receipts

When you open the Invoice Lookup dialog box, Vantagepoint displays invoices that match the value of the Amount field on the imported receipt.

On the Invoice Lookup dialog box, select invoices until the amount in the Unapplied field is zero and then click the Create Receipt button to create the cash receipt. You can view the cash receipt in Transaction Center » Transaction Entry » Cash Receipts.

If you need to create a receipt for an amount other than the full amount of the entire invoice (for example, to add an interest payment made by your client), or you need to create a line for a transaction that does not yet have an invoice (such as a retainer receipt), click the Go To Receipt button on the Invoice Lookup dialog box. The cash receipt record opens and you can then add line items in the Project Information grid.

 

Assign a Reference Number to a Cash Receipt

A new Create Cash Receipt Entries dialog box is now available in Bank Reconciliation. If you have not set up Vantagepoint to automatically assign reference numbers to cash receipts, this dialog box displays automatically when you click the Create Receipt button on the Invoice Lookup dialog box.

In the Next Cash Receipt field on the Create Receipt Entries dialog box, enter the reference number for the cash receipt to be created. When Vantagepoint creates the cash receipt, the Reference Number field in the transaction record prefills with the value that you entered in this field.

The Next Cash Receipt field was also added to the Create Bank Transaction Entries dialog box.

For more information, see Work With Cash Receipts in the online Help.

Support for Email Templates in Interactive Billing and Draft Invoice Approvals

You can now reuse standard information, such as regular text or database fields, whenever you email invoices or credit memos in Billing » Interactive Billing and Hubs » Projects » Draft Invoice Approvals.

On the Invoice History tab in these applications, select an invoice or credit memo and then click the Email action to display the Email Invoice dialog box. Depending on your security role and save rights settings, you can use the Save Email Options button to create, modify, and save email templates for personal use, for the use of those who share your role, or for use by all roles. You can then use the Select Email Template option to select a previously saved email template. When you click the Insert Field option above the Subject and Message fields, the Insert Field dialog box now displays additional database fields that you can select to insert into your email message. The expanded list of database fields in Interactive Billing and Draft Invoice Approvals matches the existing list available in Billing » Batch Billing.

Email templates that are saved from Interactive Billing, Draft Invoice Approvals, and Batch Billing are available for selection across all three applications. For example, when you create and save an email template from the Email Invoice dialog box in Draft Invoice Approvals, you can use the same email template when you send invoices in Interactive Billing or Batch Billing. Fields that are particular to Batch Billing, such as File Type and Email Single File, only prefill with the saved selections when you use the email template in Batch Billing.

 

Inclusion of Email Templates in Batch Billing Saved Options

In Billing » Batch Billing, you can now include email templates whenever you specify a set of saved options for a Batch Billing run. On the Invoice Creation tab of the Batch Billing form, when you click the Email Invoice Setup option and select to use an email template, use the Saved Options field to group and save the email template with other processing options that you want to reuse in the future.

Set a Default Time Frame to Use for Each Interactive Billing Session

In Settings » Billing » Options, use the new company-specific Default Time Frames option to specify how you want Vantagepoint to prefill the time frame fields on the Billing Session Options dialog box (Period Start/End Date, Bill Through Period, and for overhead projects: Start Period for Transaction Detail and Number of Periods to Include) whenever you navigate to Interactive Billing for an invoice session.

If your firm is upgrading from Vision or a prior version of Vantagepoint, the Default Time Frames option is initially set to Previous Setting Entered by User. Vantagepoint remembers your previously selected time frame settings and prefills the Billing Session Options dialog box on your next Interactive Billing session.

When you set the Default Time Frames option to Active Period Selected, Vantagepoint applies the time frame settings based on the accounting period that you are working in. If you are a new user, Vantagepoint applies the time frame settings based on the active period that you are logged into.

Set the default time frame in a way that is appropriate for the frequency of billing cycles in your firm. For example, if your firm has multiple billing cycles within a month, it is beneficial to select the Previous Setting Entered by User option. If it is common for your firm to bill once a month based on the current fiscal period time frame, select the Active Period option. The default time frame setting that you specify does not affect draft invoices that are in the approvals process.

Supported Browsers

Deltek Vantagepoint 5.0 supports the latest versions of browsers such as Edge, Chrome, Firefox, and Safari. Internet Explorer is not supported.

Have Corpay Pay Your Vendors

You can now set up integration between Vantagepoint and Corpay, a third party, who pays your vendors when you process vendor payments in Cash Management » Vendor Payments.

 

Corpay Integration Utility

A new Corpay integration utility has been added in Utilities » Integrations. You set up this integration after you start working with Corpay to complete their onboarding process. For more information about the prerequisites and integration setup, see Corpay Integration Utility.

 

Vendor Payments

In Vendor Payments, when you process a vendor payment run for Corpay to pay: On the Printing and Numbering page, you click the Export to Text action. On the Download Payments to Text File dialog box, a new Corpay button has been added. Click this button to electronically send a .txt file with vendor payment information directly to Corpay, so they can pay the vendors in the file. For more information, see How to Process Vendor Payments for Corpay to Pay.

 

Corpay’s AP Gateway

Use Corpay’s AP Gateway to view payment detail and history for your vendors, including payment clearance information, approved payments, and vendor payment methods. You can also run vendor payment reports in Corpay.

Date Ranges for Calculated Fields in Dashparts

Date ranges are now applicable for calculated fields in dashparts. When you create an equation on the Calculated Fields dialog box, date range-applicable fields in the field list now have a calendar symbol. To make it possible to apply a date range to the calculated field, add at least one date range-applicable field to the equation.

When you add a calculated field that includes a date range-applicable field to the dashpart in Dashpart Designer, click the pen option under Date Ranges column to configure the date range settings for that calculated field.

Revenue Forecasts in Pipeline System Dashpart

In addition to displaying your fees and compensation spread evenly across the life of a project, you can use a new option to display the fees predicted revenue based on the allocation method defined on the project.

To specify the calculation method, use the new pipeline calculation option, which is located beside the currency option for the Pipeline system dashpart.

The label for this new option varies, depending on the pipeline calculation that you select:

• Spread Evenly Across Timescale: Select this option to display the total compensation and fees of a project across the start and end date of the project. (This was the only pipeline calculation method used in previous versions of Vantagepoint.)

• Use Allocation Method on Project: Select this option to display predicted revenue using the allocation method specified for each project in Hubs » Projects » Contract Management. Selecting this method will use Estimated Fee and Weighted Fee for pursuit projects, except for any pursuit projects that use Revenue Forecast as the allocation method.

The Pipeline system dashpart is available if you have Resource Planning and CRM enabled.

Percent Symbols in Dashparts

 

For table and chart dashparts you can now display the percent symbol for columns with the percentage data type. For applicable columns in a table dashpart, select the Display Percent Symbol option on the Properties dialog box that you display from the Dashpart Designer. For chart dashparts, select the Display Percent Symbol option on the Chart Options dialog box that you display from the Dashpart Designer.

New Columns for AR Detail

The following columns are now available for the AR Detail dashpart base:

• Invoice Billing Client Name

• Invoice Billing Client Number

Use these columns to display and track all billing clients that are associated with all posted invoices for a project. The client names and IDs are displayed as links in the dashpart. Click a link to display an info bubble with additional details on the client and then click More in the info bubble to display the full client record in the Firms hub on another browser tab.

 

Updating AR Comments via the AR Comment Column

From a dashboard, you can now click a comment displayed in the AR Comment column to display the AR Comments dialog box and then edit existing comments or add new comments for an AR record. When there is no comment for the AR record, an add icon is displayed instead. In this case, you can click the add icon to display the AR Comments dialog box and then add a comment for the AR record without going to Hubs » Firms » AR Review or to Hubs » Projects » Invoices.

Schedule Snapshots for Dashparts

You can now schedule when dashpart snapshots are processed for: 

• Dashparts with the Favorite Reports dashpart base

• Table dashparts

• Chart dashparts

When you create or modify a dashpart with the Favorite Report dashpart base in Dashpart Designer, select the new Schedule Dashpart option to display the Schedule dialog box and then specify when the dashpart snapshot is generated. (If you select the Always Rebuild Report option, the Schedule Dashpart option is disabled.)

The Schedule Dashpart option is also available on the Table Options and Chart Options dialog boxes. From the Dashpart Designer, click Table Options or Chart Options to display the appropriate dialog box.

You can track and review scheduled dashparts in Utilities » Process Server » Queue Manager. The process description includes the name of the dashpart.

My Upcoming Assignments System Dashpart

Use this new system dashpart to display your current and future assignments for projects on which you have complete hours and estimated hours remaining. You can customize the dashpart to show your upcoming assignments based on a forecast range that you specify. You can also specify that the capacity data be displayed based on planned hours, schedule percentage, or utilization percentage.

New Option for Assigning the Billing Client for Imported Project Invoices

Currently, when you import project invoices in Utilities » Desktop Imports in the desktop application, the billing client that is entered for a project on the Accounting tab in the Projects hub is automatically assigned to the project’s imported invoices.

Now you have another option for assigning billing clients to imported invoices. You can add the billing client for a project's invoice directly in the import file. To do this, you must select the Include check box for the new BillingClientID field that has been added to the “Select fields you want to import” grid on the Text File Fields Mapping tab of the Import Utility form. For more information, see Importing Project Invoice Records.

Vantagepoint Information Center

The Vantagepoint 5.0 online help menu now includes a link to the Vantagepoint Information Center, which provides direct access to:

• Technical Administrator Help

• PDF Guides

• What’s New/Release Notes

• Video Library

• Developer Resources (API)

• Data Dictionary

Saved Grid Views

Vantagepoint now includes the ability to create and save multiple views of a grid. You can do this for your own personal use or to share with team members, if you have the appropriate access rights. Using multiple grid views allows you to customize each grid’s columns and then easily switch between grids to see the information that you need.

Updates on Software Requirements

Updates to the software requirements and support of Vantagepoint 5.0 include the following:

• Vantagepoint 5.0 requires SQL Server 2019 CU Package 15 for the SQL Server component and .NET 4.8 for the .NET Framework component.

• Vantagepoint 5.0 supports the Windows Server 2022 Operating System.

• Vantagepoint no longer supports SQL Server 2016.

For more information on supported and compatible versions, refer to Deltek's Product Support Compatibility Matrix.

New Sub-switch Option for Loading Individual Languages for Reports

The loadReportLanguages sub-switch has been added to the following switches in Vantagepoint: 

• setup

• setupAndMigrate

• upgrade 

• LoadReports

When applied, this one-time-only sub-switch loads a comma-separated list of languages (for example, en-us, fr-ca, or others) that can be updated at any time as needed. All languages in the table will then load for all reports.

For more information, see the Vantagepoint 5.0 Installation Guide.

New Account Search List Sort Order Option in My Preferences

On the General tab of the My Preferences dialog box, use the new Account Search List Sort Order option to sort general ledger accounts by name or number in account search lists. This sort only applies to fields and options in the browser application that display accounts in drop-down selection lists or on the New Accounts Search dialog box. If you use multiple companies in Vantagepoint, your sort order preference is maintained when you change the active company.

Labor Planning Grid Updates

New Display Options for the Labor Planning Grid

To improve the display of values in the Labor Planning grid on the Labor tab in Hubs » Projects » Plan, we replaced the Show field with two new options that control the display of hours as well as cost and billing amounts (planned, actuals, and baseline).

Click the Grid Settings icon on the grid toolbar and select an option:

• Click the Column Settings option to display the Column Settings dialog box, on which you select the summary columns that display in the middle section of the grid, sort the resource rows, and display WBS element numbers along with their names in the grid.

• Click the Sub-Row Settings option to display the Sub-Row Settings dialog box, on which you select sub-rows for Billing and/or Cost plan amounts and change the order of the sub-rows list in the grid.

 

Improved Horizontal View Paging in the Labor Planning Grid

The horizontal view paging of the Labor Planning grid now displays 30 calendar periods (columns) instead of 50. Since you can now add sub-rows to the right section of the grid, this change makes it easier to navigate from right to left.

 

View Actual and Baseline Data Outside of the Planned Date Range in the Labor Planning Grid

If you own the Resource Planning module, you can now display actual and baseline data entered for work breakdown structure (WBS) elements, labor codes, or resource assignments in dates before or after the planned date range in the Labor Planning grid. On the grid toolbar, click the Grid Settings icon and then select Sub-Row Settings to include actual and baseline labor sub-rows in the right section of the grid. If the planned date range includes more than 30 calendar periods (columns) based on your scale selection, a date range selector displays on the upper-right corner of the grid. Click this date range selector to view actual and baseline data in periods outside of the planned start and end dates.

Ability to Add Assignments Under Inactive WBS Levels

In Hubs » Projects » Plan, Resource Management » Resource View, and Resource Management » Project View, you can now add new planning assignments under inactive WBS level elements on your projects. This eliminates the need to activate the WBS element, add the assignments, and then deactivate the element again. (You still cannot add new planning assignments under dormant WBS elements.)

In the Resource View and Project View grids, you can display a Status column to see the status of the WBS elements. In addition, the Status column in all planning grids now displays the status for the resource assignment rows.

Billing Contacts for Previous Billing Clients Are Now Available for AR Reports

This enhancement applies when a project has more than one billing client over the life of the project.

A new Billing Contact field has been added to the Firms grid on the Team tab in the Projects hub. With this new field, the billing contact for a previous billing client is saved in this grid. This means that you can now display the billing contact for a previous billing client on AR reports when the reports include invoices that are posted to the previous billing client. You can also email these AR reports to the billing contact for a previous billing client.

When you add or replace a billing client in the Billing Client field on the Accounting tab in the Projects hub (or in the Billing Client field in the summary pane in Billing Terms for the project), the billing client and its information, including its billing contact, are automatically added to the Firms grid on the Team tab of the Projects hub.

For more information about the new Billing Contact field, see its description in Team Tab of the Projects Form.

 

AR Aged, AR Ledger, and Invoice Register Reports

For the AR Aged, AR Ledger, and Invoice Register reports, the billing contact for a previous billing client (entered in the Firms grid of the Teams tab in the Projects hub) now displays on these reports for invoices that were posted with the project’s previous billing client when either of the following apply for the reports:

• You entered Contact and Telephone or Full Address in the Client Detail to Display field in the Display Options section on the report’s Options tab.

• You grouped the contents of these reports by selecting Billing Client Name, Billing Client Number, or Billing Client Type in the Grouping and Sorting section of a report’s Columns & Groups tab.

 

AR Statement Report

The billing contact for a previous billing client (entered in the Firms grid of the Teams tab in the Projects hub) now displays on the AR Statement for invoices that were posted with the project’s previous billing client when you select both of the following options on the report’s Options tab:

• In the Detail Options section, select Project or Client in the Statement Type field.

• In the Display Options section, select one of the following in the Statement Addressee field: Name of Billing Contact, Name of Billing Contact/Client, or Name of Billing Client/Contact.

 

Emailing an AR Report to the Billing Contact of a Previous Billing Client

For all the reports listed above, you can now send an email message with the report to the billing contact for a previous billing client when the report contains invoices posted to a previous billing client. To do this, the following apply:

• For all the reports: The billing contact for a previous billing client must be entered for the previous billing client in the Billing Contact field in the Firms grid on the Team tab in the Projects hub.

• For the AR Aged, AR Ledger, Invoice Register, and Invoice Transaction Detail reports: You must sort these reports by billing client criteria or make a billing client selection for the report.

• For the AR Statement report: On the report’s Options tab, you can select either Project or Client statement types. You can also select any option in the Statement Addressee field in the Display Options section of the report’s Options tab, even the options that do not include the billing contact on the report. You can email the AR Statement to a billing contact without displaying the billing contact on the statement.

To email a report to the previous billing contact for a billing client, click Other Actions » Email on the report form and select the email recipient (billing contact for a previous billing client) based on the Billing Contact project role.

 

Contact Field for the Primary Client and the Billing Client

In the Projects hub, you can now select only active contacts and qualified contacts if you use the Lead Qualification feature for the Contact field for the:

• Primary Client field on the Overview tab

• Billing Client field on the Accounting tab

 

Upgrade Information if You Are Upgrading from Vantagepoint 4.5 or Vision 7.6 to 5.0

The billing contact entered for the current billing client on the Accounting tab of the Projects hub will automatically prefill in the new Billing Contact field in the Firms grid on the Team tab of the Projects hub for the current billing client of the project.

If you started using a different billing client for a project in Vantagepoint 4.5, you can manually add the billing contact for a previous billing client in the Billing Contact field in the Firms grid on the Team tab in the Projects hub.

Multi-Page Hub Records in Proposals

In creating a proposal, you can now include hub records that span multiple pages. This is useful when a proposal includes resumes or project experience that will not fit on a single page.

If you include hub records with multiple pages, you can use the Show record header option to display the name of the hub record at the top of each page. To help you keep track of your place in the record, the header shows both the total number of pages in the record and which page you are currently on.

To hide the record header for single-page records, select the Show record header for multiple pages only option.

Report In option now available for the Firms List and Firm Summary reports

Vantagepoint now includes the Report In option on the Options tab for the Firms List and Firm Summary reports. (Previously, if you had multiple currencies enabled, you were unable to access this option to specify the currency and exchange rate for these reports.)

For more information about using the Report In option for these reports, see Firms List Options Tab and Firm Summary Options Tab in the online Help.

Search by Additional Fields

You can now specify additional resource search fields in the Find Resources pane in Resource Management » Resource View and on the Custom Search dialog box in Resource Management » Reporting. You can search by additional employee standard fields and also by user-defined lookup and drop-down fields. To make these fields available, you specify them in the new Available Search Fields grid in Settings » Resource Planning » Resource Settings. For more information, see Specify the Available Fields for Resource View and Resource Management Reporting in the online Help.

Filter Results Based on Project Criteria

In Resource View, you can click a resource row to display project assignments in the Resource View grid. Use the new Projects Filter control to filter these projects by status, charge type, organization, project manager, stage, stage step, and probability percentages. Using filters to view only those projects that meet your criteria allows you to focus on relevant resource capacity and, if necessary, reschedule or reassign assignments. For more information, see Filter Projects Dialog Box in the online Help.

Reduced Frequency for Warning Messages

To improve Revenue Forecast usability, you no longer receive warning messages if there are not enough established fiscal periods to support the project's revenue forecast date range.

Indicators for Unsaved Changes

The following applications have been updated to display indicators for unsaved changes. These applications no longer save automatically after each change that you make:

• Billing » Billing Groups

• Settings » Accounting » Accrual Schedules

• Settings » Accounting » Unit Settings

• Settings » Accounting » Revenue Groups

• Settings » Resource Planning » Generic Resources

• Settings » Cash Management » Tax Codes

Search Navigation Improvements

Search navigation has been redesigned to provide enhanced functionality and additional search components. These changes streamline how you view and edit saved searches and evaluate returned search records throughout Vantagepoint. Use the Search Navigations Control feature, located at the top of most hub and application forms, to:

• Find and page through all active, inactive, and dormant hub or application records from both Detail View and (if available) List View.

• Locate saved searches.

• Filter and evaluate returned search records.

• Build new and ad hoc Selection searches.

The Search Navigation Controls are comprised of the following components.

Find <record>

This lookup field has been enhanced to return all active, inactive, and dormant records for the active hub or application form, based on the alphanumeric text that you enter.

 

Saved Search Control

The Saved Search Control is displayed to the right of the Find <record> lookup field. Click the drop-down arrow to display:

• Saved Searches pane: In this pane, you can select a saved search from the Saved Searches list, build a new search, or build an ad hoc search. The ad hoc Selection search is based on a saved search that you select, which allows you to filter and select a subset of records to meet your business needs. Only one ad hoc Selection search is available at one time; this search remains unchanged until you update it or create a new ad hoc search.

• Records Selection pane: In this pane, you can filter and evaluate the records returned by a search.

 

x of x Fields

Use these arrow icons to scroll through the records in the search results and display a different record to display on the form. The numbers indicate which record you are viewing out of the total number of records in the search results.

 

Detail View and List View

The Search Navigation Controls are displayed for forms in Detail View or List View. If the active module has List View as an option, you can now use search navigation controls to find hub or application records, page through and evaluate lists of records, access saved searches, or build new and ad hoc Selection searches. 

For more information, see the following Help topics: Search Quick Reference, Search Navigation Controls, and Search Hub Records.

New Options to Sort Non-Special Category Entries and Search Results in Timesheets

You can use new options in My Stuff » Timesheet to sort timesheet details by client name, project name, or project number and to navigate through timesheets and search result lists by employee last name.

To sort non-special category entries on the Timesheets form, use the Sort By option on the Left Grid Settings dialog box. You can sort entries by Client Name, Project Name, or Project Number. When you set a sort preference, Vantagepoint arranges your entries in ascending order and displays a Sorted By field on the Timesheets form, which you click to refresh and re-sort timesheet details. Special category entries such as vacation or holidays are not sorted and remain in the top rows of the grid.

If you have Group, Company, or System access rights to the Timesheet application, you can now sort timesheet records that display in search result lists by the last name of the employees. From the drop-down arrow of the search field, click Sorting Options and then set the Results List Sort Order option to Employee Last, First Name. This sort order is available in addition to the existing Period Ending Date and Employee Name options.

When you set the sort order to Employee Last, First Name or Employee Name, Vantagepoint applies your sort preference to the following Timesheet areas:

• In the results that display from the search field

• On the Timesheets form, when you click the left and right arrows to display prior or subsequent records

• On the Custom Search dialog box, when you display the drop-down list in the Employee field

• On the Add Timesheet dialog box, when you display the drop-down list in the Employee field

If you perform floor checks, you can use the new Employee Last, First Name column to sort records on the Floor Check dialog box.

Webhook Action

The User Initiated and Scheduled Workflow options now include a Webhook Action, which allows you to call third-party REST endpoints for user-initiated and scheduled workflows. The webhook contains the URL to call, the data information to send, and the timeout and retry settings for the call. These calls can authenticate to the endpoint via a username and password or public and secret key.

You access this option in: Settings » Workflow » User Initiated Workflows or in Settings » Workflow » Scheduled Workflows.

Defect 1352181: This issue occurred when you tried to send invoices with email messages from Interactive Billing. On the Email Invoice dialog box, when you selected user-defined contact or employee project role fields as recipients, the email message was not sent successfully.

Defect 1530554: In Interactive Billing, you received a "ParameterizedQueryBuilder parameter count mismatch" error message. This issue occurred if entries in Notes and Description fields in Billing Terms for the project, or on the Units and Expenses tabs in Interactive Billing, contained a bracket such as { or other special characters.

Defect 1568321: This issue occurred on the Interactive Billing form when you tried to add a billing unit for a project. When you selected a unit on the Billing Unit Insert dialog box, the Unit Table field did not display the correct unit table that was associated with your selection.

Defect 1516980: In Interactive Billing, when the grid on the Expenses tab had a large number of expense transactions, you were not always able to scroll down the grid to see all the transactions. You could see only the transaction on the grid’s first page. This issue occurred when you did not select the Show Non-Billables on Detail Tabs check box on the Billing Session Options dialog box.

 

 

Defect 1584834: On the Invoice History tab in Interactive Billing, when you tried to send an invoice to multiple email addresses for a contact, the email message was sent to only the first email address listed for the contact.

Defect 1552430: The billing client entered in the Billing Client field on the Accounting tab of the Projects hub was removed when you changed the billing contact for that billing client in the Contact field on the same tab.

Defect 1520178: When you ran the Employee Labor Detail report with the Activity Code: Sort By option set to Activity Code on the Options tab, you received an error message.

Defect 1520196: When you created a new project record with auto numbering configured in Settings » Workflow » Numbering, triggering a Validation Error Workflow resulted in the auto numbering not following a sequential order.