Custom Report Included with Invoices in Batch Billing

In Batch Billing, you can now generate a custom report for each invoice that is processed in a billing batch. A Print Custom Report check box displays in the “Include with Invoice” section on the Invoice Creation tab in Batch Billing if you have a custom report saved in the Custom folder on the Vantagepoint application server. This is a custom report provided by Deltek Global Consulting Services. Select this check box to generate the corresponding custom report for each invoice in the billing batch. The report contains data that is specific for each invoice.

Ability to Stop Report Query from Running on a Database Server

Vantagepoint Reporting has been enhanced to reduce CPU spikes and limited bandwidth, and to address other performance issues when running reports. Previously, when you ran a report query and then closed it before the query was complete, the report continued to run on the SQL database server. Now, when you close a report query in the Vantagepoint Reporting application, the query is also cancelled on the database server.

To close a report query in Vantagepoint Reporting and stop the report from running on the report's database server, close the report's Preview window.

Vision-to-Vantagepoint Upgrades: Automated Removal of Negative Planned Values

You can run Vision-to-Vantagepoint upgrade scripts prior to upgrading to Vantagepoint, to detect structural and data conditions in Vision plans that can cause issues when a plan is upgraded to a Vantagepoint plan. In Version 3.5.10, those scripts have been enhanced to give you the option to upgrade plans that contain negative values in the time-phased data without first having to remove those negative values yourself.

For previous versions of Vantagepoint, if a Vision plan contained negative planned values for some dates and you wanted to upgrade that plan to Vantagepoint, you first had to remove those negative values. In 3.5.10, assuming that the plan meets all other upgrade requirements, you now have the option to proceed with the upgrade without first removing negative values, and the upgrade process will automatically set those negative values to zero. If that approach is not what you want, however, you still have the option to update the plan yourself to remove the negative values before you upgrade.

In a related change, the upgrade script also detects negative values in iAccess plans and gives you the same options for removing them: automatic removal during the upgrade or manual removal before the upgrade.

If you elect to have the upgrade process remove negative values, all total planned amounts that previously included those negative values will increase accordingly. 

For complete information about converting Vision and iAccess plans when you upgrade to Vantagepoint, go to the Vantagepoint Readiness Portal, navigate to Manage Your Upgrade > Upgrading to Vantagepoint, and review the following:

• Under Important Release Documentation: “Resource Planning – Considerations, Upgrade and Settings Guide.” 

• Under Vantagepoint Upgrade Checklists: “Resource Planning – Upgrading Vision Plans to Vantagepoint 3.x for Cloud Customers” or “Resource Planning – Upgrading Vision Plans to Vantagepoint 3.x for On Premise Customers.”

Defect 1453428: In Interactive Billing, when you clicked Other Actions » Bill Retainage, selected several invoices with retainage to bill on the Bill Retainage dialog box, and clicked Bill, the Bill dialog box displayed the incorrect amount of total retainage to bill if any of the invoices had a negative retainage amount. However, if you clicked Print on the Bill Retainage dialog box, it showed the correct amount of retainage.

Defect 1385183: On the Payment Review form, when you clicked a specific vendor name in the Payee field to print a remittance advice, the file included other vendor payments that were made in the same run.

Defect 1332876: This issue occurred when you created a vendor payment run and set the Payment Type option to Wire, then processed the run and posted the vendor payment. When you ran the Cash Journal report, the tax amount in the Amount field was doubled. 

Defect 1440977: On the Electronic Files page in Vendor Payments, when you selected a posted run, the EFT file was not processed. This occurred when the Status field in the Electronic Payment Method section of the Vendor tab in the Firms hub for a vendor remained as Add, when it should have automatically changed to Wait.

Defect 1463564: This issue applies for all hubs. It involves standard and user-defined drop-down type fields in grids, in which you can only make a selection from the drop-down list (you cannot enter text). When you selected a different item from the drop-down list in these fields, it appeared as if you had not selected the item. You clicked the item, nothing seemed to happen, and the old value remained in the field. The item that you selected was actually saved, but you could not see this until you refreshed the screen.

Defect 1446455: Not all activities displayed in the Activities grid of a contact record. This happened even if the activities occurred only once and were scheduled to happen more than 60 days after the current date.

Now, the Activities grid for a contact displays all non-recurring activities, the recurring activities for the next 60 days, and the recurring activities that occurred in the past. A new tooltip has been added to the Activities tab in all the hubs that says: “Recurring activities are filtered to occurrences in the next 60 days and the past. Recurring activity occurrences after 60 days from today are not shown in the grid but can be viewed in the calendar."

Defect 1442694: On the Experience tab of the Employees form, some projects were displayed twice in the Project grid. On the Team tab of the Projects form (Hubs » Projects » Project), the project associated with the team member was displayed twice.

Defect 1371873: When you used task numbers in the advanced search, multiple search results with duplicate task numbers were displayed.

Defect 1411992: If you used a project template to add lower-level work breakdown structure (WBS) elements to a project, the following fields for the added lower-level WBS elements were not populated with values from the corresponding fields in the template: Principal, Supervisor, and Project Type.

Defect 1451136: When you changed the default label for the Estimated Start Date and Estimated Completion Date milestone fields in Settings » General » Lookup/Report Labels in the desktop application, the new label that you entered was not applied to the fields in project lookups and on the Select Columns dialog box in My Stuff » Dashboards.

Defect 1346338: In some cases, when you entered and saved AR comments for an invoice listed on the Invoices form, the comments appeared to be saved, but when you selected the invoice again and reopened the AR Comments dialog box, the comments were gone.

Defect 1445217: When you added another resource to a level on the Labor tab of the Plan form and then entered the ETC Hours for the new resource, the ETC Cost for the level on which you added the new resource displayed an incorrect value, such as -999,000. (To correct the displayed ETC cost value, you had to open another project plan and then return to the project plan with the issue.)

Defect 1450272: When you displayed the Schedule tab of the Plan form, the Schedule tab stopped responding. This occurred due to an issue in the database (the plan ID was not associated with the project record).

Defect 1428686: If you selected a different stage for a project while in List View, the stage displayed in the Stage field did not change. If you then displayed the drop-down list for the Stage field to try the selection again, the list did not contain the stage that you wanted to select. Instead, it contained two instances of the stage that you were trying to replace. Actually, your initial selection was saved successfully. If you logged out and logged back in and then returned to List View, both the Stage field and the drop-down list contained the correct values.

Defect 1430064: This issue occurred when you displayed projects in List View and then sorted the records by a column (for example, the Organization column). When you tried to export the projects, you received the following error message: "The multi-part identifier "Organization.Name" could not be bound."

Defect 1442276: On the Team tab of the Projects form, a team member was displayed twice with the same number of hours. When you checked the Employees hub, the project associated with the team member also displayed twice.

Defect 1442276: On the Team tab of the Projects form, a team member was displayed twice with the same number of hours. When you checked the Employees hub, the project associated with the team member also displayed twice.

Defect 1451875: This issue applies if you migrated from Vision to Vantagepoint. When you displayed the Dates & Costs Tab of the Projects form, you received the following error message: "Please enter the Project Key Dates i.e. Estimated Project Start Date, Estimated Project Completion Date in the Milestone grid below." This occurred even when the original project record that was migrated already included the information listed in the error message.

Defect 1447568: When you tried to delete an attachment in a user-defined hub, you received the following error message: "Column UDIC_UID not found in FW_ATTACHMENTS". This issue occurred when your role had record level view restrictions to the user-defined hub, even when your access rights were set to Full on the Record Access tab in Settings » Security » Roles.

Defect 1408490: In Settings, when you set the Display non-working days option to On, the non-working days were not displayed on the Timesheet Hours screen. However, when you set the Display non-working days option to Off, the non-working days were displayed in the Timesheet Hours screen. This issue occurred after subsequent logins.

Defect 1454412: When you entered hours in a timesheet in Mobile Time and Expense and saved the entry without a comment, you received a "Comments required" error message. This occurred even when the timesheet category in Vantagepoint (the browser application) did not require comments when entering work hours.

Defect 1458746: When you added an expense line on a new expense report and saved, the date that you specified in the expense line was decreased by one day. This issue was time zone-dependent and only occurred on iOS devices.

Defect 1448651: This issue occurred when an expense report was rejected by an approver and you then made changes on the Detail dialog box and saved the expense report. The Submit button did not appear in the header of the Expense Report form.

Defect 1460394: This defect applied if your organization uses the Multicurrency feature and the administrator set up more than 100 currency codes in Settings » Currency » Option. In an expense report, when you clicked the Currency Code field of an expense line and scrolled to the bottom of the results list, not all currencies were displayed. 

Defect 1337556: When you configured the Labor Resource Planned and Actuals report with a specific date in the Start Date field on the Options tab of the report options form, the displayed planned labor value in the generated report was sometimes greater than the correct value.

Defect 1396238: The Chart tab of the Time Analysis report did not display the Display Timeframe option, which you use to specify the time frame (Current, Month-to-Date, or Year-to-Date) for the displayed data.

Defect 1403835: When you ran multiple reports at the same time and then clicked the Search and Download option for each report, only the last report that you ran returned results in the Search Criteria grid.

Defect 1411768: For Employee reports, the Location criterion was missing in the selection lists on the Selected Grouping and Selected Columns dialog boxes. As a result, when you configured an employee report, you could not include either the Location sorting and grouping criterion or the Location column on an Employee report.

This issue occurred when you did the following:

1. In My Stuff » Reporting, you selected an Employee report.

2. In the Grouping and Sorting section of the Columns & Groups tab, you clicked either of the following:

• +Manage Grouping, to sort or group data on the report

• + Manage Columns, to include columns on report

3. On the Selected Groupings dialog box or the Selected Columns dialog box, you tried to find and select the Location criterion.

Defect 1421038: Compensation Fee, Direct Consultant Fee, Contingency amount, and other information was missing from the Project Planning Performance report. This issue occurred if you did not select the Subtotal option for all available groups in the Group By grid on the Columns & Grouping tab of the report options.

Defect 1423898: When you set the Time Analysis report to display Cost details, the generated report still displayed Hour details in the column headers.

Defect 1447863: When you tried to search for a user-defined account classification option to sort groupings for the Firm Employee Assignment and Activity Status report, the account classification option was not available.

Defect 1448765: When you ran a favorite report in a user-defined hub, the placeholders added in a user-defined section did not align correctly in columns on the generated report.

Defect 1448847: When you ran the Cash Receipts report (an Accounting report), cash receipt transactions were missing. This occurred for transaction entries for projects that did not have clients specified.

Defect 1451419: This issue occurred on the Income Statement and Consolidated Income Statement reports when a calculated field was added to the reports. You received a SQL Reporting error if you set up the field calculation to be performed on each row from the query.

Defect 1453361: This issue applies if you have one or more Custom Budget columns in the Columns section of the Columns & Groups tab on the report options form for the Profit Planning Monitor or Income Statement reports. When you selected a single-digit month as a period in the Period Start or Period End fields for the Custom Budget column, the fields displayed a different value instead of the value that you specified.

As a workaround, re-create the configuration for a new Profit Planning Monitor or Income Statement report. This time, configure the Period Start and Period End fields for the Custom Budget column before you select options in the Budget Options section in the Options tab.

Defect 1453448: When you cleared the Record Selected value from the Records field for a report on the Favorite Reports tab of the Reporting form, the generated report still included the record selection. (As a workaround, you had to remove the Record Selected value from the Records field.)

Defect 1455982: When Organizations were not in use, running the Income Statement and Profit Planning reports resulted in blank reports.

Defect 1459218: When you drilled down on a report, you received this error: "Query execution failed for Dataset ‘ReportDataset’." This error occurred on the following reports:

• Account Analysis

• Trial Balance

• Balance Sheet

• Consolidated Balance Sheet, if using the Multicompany feature

Defect 1460533: This issue occurred when you generated the Employee Labor Detail report with the Debit Account grouping specified in the Grouping and Sorting section of the Columns & Groups tab, on the report options form. The values for certain employee hours and cost amounts in the Debit Account groupings were sometimes incorrect.

Defect 1466617: This issue occurred when you added a project data type field, or an option that was an account, role, or unit lookup, on the Custom Options tab for a custom report in Settings » General » Custom Report Options. When you ran the custom report, you received this message: “An error has occurred."

Defect 1419212: When you edited your timesheet, some line items disappeared from the grid after you saved your changes.

Defect 1448477: This issue applies if your Timesheet Administration Level was set to Group on the Time & Expense tab in the Employees hub. When you transferred labor hours in Billing » Interactive Billing and then acknowledged the billing labor transfer in My Stuff » Timesheet, the Billing Transfer Audit dialog box displayed multiple rows for the same billing transfer.

Defect 1412215: When you processed a payroll run, the run status became stuck at Posting and you received the following error message: "Invalid Project: [/ /] Please check your Payroll liability distribution credit setup in Organization Configuration."

This occurred when the following options were set in the desktop application:

• In Settings » Organization » General, the Maintain separate balance sheets by Organization option was enabled.

• On the General tab of the Payroll Setup form in Settings » Payroll, the Payroll liability distribution option was not selected.

• On the FICA tab of the Payroll Setup form in Settings » Payroll, the Post FICA to AP Voucher option was enabled.

Defect 1434821: In the desktop application, the Distribution Overrides check box on the Cost Distribution tab of the Purchase Order Line Detail dialog box was enabled by default. This issue occurred when you created a new Purchase Order record from an approved Request for Price Quote record on which the Distribution Overrides check box was originally disabled.

Defect 1460470: Payment terms entered in the Pay Terms field on the Billing tab of the Purchase Orders form that were specific values, such as 30 or 60, were missing. Other, non-numeric payment terms, such as Date, Next, PWP, and Hold, were not affected. This issue occurred after you upgraded to Vantagepoint 3.5.8.

Defect 1453376: When you ran a new project search from Resource Management » Reporting, the search processed slowly.

Defect 1404783: When you selected a user-defined hub as a search criterion on the New Expense Report Search dialog box, the drop-down menu for the operator displayed the "No results were found" message instead of a list of available operators.

Defect 1444463: When an existing search contained grouped conditions that were entered using the advanced settings for the search criteria and you used the Save as New Search option to create another search with the same criteria, the results of the new search did not correctly match the results from the original search.

Defect 1448121: If you used the DEFAULT security role when running an Employees hub search for a CRM-only database, Vantagepoint displayed grid fields and hub fields that normally are not used in the Employees hub when associated with CRM-only databases.

As a result, these two issues occurred:

1. On the Employment Details and Accounting tabs of the Employees hub form, the following fields incorrectly displayed:

• Labor Category

• Utilization Ratio

• Hours per Day

• Employee Type

• Job Cost Type

• ADP – related fields

• Cost Rate

• Cost Method

2. In the Search Criteria section of the Search dialog box, when you clicked the down-arrow for the Select a Field option to include fields in the search, the following grid fields incorrectly displayed:

• Absence Approvals

• Assigned Assets

• Direct Deposit

• Employer Contribution

• Expense Group

• State / Local / Tax/ Jurisdictions

• Timesheet Group

• Withholding

Defect 1446090: When you created a user-defined revenue method that contained the multiplication sign operator and saved the method, "CustEstimatedNETTest" displayed instead of the multiplication sign in the Calculation column in the Revenue Methods grid on the Revenue Methods form.

Defect 1448832: When a project reached the accounts receivable criteria that you specified on the AR Aging dialog box, the process for generating an alert stopped. This issue occurred when you selected employees to receive the alert in the Show Alert To section in the AR Aging dialog box.

Defect 1453388: When you tried to edit the name (description) of a tax code in Settings » Cash Management » Tax Codes, you received an error message saying that the tax code was in use. This issue occurred when the tax code was associated with an unposted transaction file in the Transaction Center.

Defect 1448854: In the desktop application, item numbers of item records deleted from the Items Master still appeared on the Items lookup that is available on the Line Items tab of the Purchase Orders form in Purchasing » Purchase Orders. When you tried to add the items back in Items Master, you received the following error message: "Record already exists and cannot be added."

Defect 1431702: When a Billing rate table had a large number of rows in the grid and you used the scroll bar to scroll down the grid, the screen kept scrolling up and down on its own.

Defect 1338242: This issue applies when you use the Approvals Configuration form in the desktop application. When you set up an expense approval workflow with an email notification action for an approval step and you included the [:ModUserFullName] field in the body of the email notification on the Email Configuration dialog box, the actual email notification sent to the recipients did not display the value for the [:ModUserFullName] field.

Defect 1440852: When you used the Validate Error at Start action in the Absence Request approval workflow and subsequently added an absence request date without comments in My Stuff » Timesheets, you received an error message.

 

When you entered comments and clicked Submit again, you received a second error message: "Date cannot be duplicated." Despite this error, the status of the revised absence request was set to In Progress when you submitted it.

Defect 1454562: A scheduled workflow failed, and you received the following termination message: "Invalid column name 'ClientID'."

This error occurred when you scheduled a Firms workflow and did the following:

1. In the Scheduled Workflows grid, you added a scheduled workflow and in the Workflow Table field selected VEAccounting.

2. In the Actions grid, you added a Column (Field) Change action and then selected a user-defined field in the Column field on the Column Change Configuration dialog box.

Defect 1450980: Workflow validation messages for user-initiated workflows were incorrectly displayed in the language associated with the employee instead of the language associated with the user currently logged in.

Defect 1458977: When you tried to upload a new invoice in AP Invoice Approvals, nothing happened and the new record for the approval did not display on the AP Invoice Approvals screen.

Defect 1411247: When you posted an expense report, you received the following error message:
"Invalid system setup Employee expense credit project. Invalid system setup Employee advance credit project."

This issue occurred when you manually entered projects in the Project fields of Employee Expense Credit Posting and Employee Advance Credit Posting in Settings » Expense » Options.

Defect 1446100: When you copied a standard data export definition and added new calculations in the Calculation field of the copied version, the new calculations were also added in the original standard data export definition. (Standard data export definitions should not be editable.)

Defect 1453364: If Organizations were disabled and you attempted to run a LedgerDetail export in Utilities » Imports & Exports » Exports, a data access error occurred.

Defect 1427349: Vantagepoint invoices that were successfully added in QuickBooks were displayed with a Failed integration status on the Error Logs tab of the QuickBooks form.

Defect 1364518: Resource Utilization Alert jobs failed when the AssignmentID field contained values that had apostrophes.

Defect 1448138: When you sorted the Undo Posting grid by the Posting Date column, the postings did not sort chronologically by date.