Deltek Costpoint 8.2.5 Release Notes (Build 8.2.5.5004)


Welcome to the Deltek Costpoint 8.2.5 Release Notes, which describe the new features, enhancements, and software corrections introduced in this release.


Important NotesRegulatory EnhancementsEnhancementsSoftware Issues ResolvedSecurity EnhancementsDatabase Changes


Important Notes


These release notes address all of the modules associated with Deltek Costpoint 8.2.5, some of which your firm may not use. Skip the sections that do not apply to your implementation of Deltek Costpoint.

Release notes are available from the landing page and the Costpoint Information Center.

We want the release notes to be as easy to use as possible. To this end, we will continue to analyze and improve upon the format. If you have feedback, please email DeltekDocumentationFeedback@deltek.com.

 

Print These Release Notes or Save as PDF

You can print these release notes or save this page as a PDF. Do one of the following actions:


Regulatory Enhancements


State


California Creditor Debt Garnishments Formula

Costpoint now supports the California garnishment calculation to allow Payroll users to comply with the state’s garnishment regulations. This release adds a new calculation method on the Manage Employee Garnishments application to allow Payroll users to set up the new CA garnishment calculation.

 

Manage Employee Garnishments (PRMEGARN)

The Manage Employee Garnishments screen features the following updates:

Field

Description

Limit 1 Percentage

Enter the percent for Limit 1. This will be used when the Limit 1 Calculation Method is set to (DI-(MxSMW))xP: Disposable Income - (Limit 1 Weekly Multiplier x State Minimum Wage) x Limit 1 Percentage.

 

Compute Payroll (PRPCPR)

The Compute Payroll application’s garnishment calculation was updated to calculate the correct amount when the new Limit 1 Calculation Method, (DI-(MxSMW))xP, is selected for the employee on the Manage Employee Garnishments screen.

 

View Garnishments (PRQEGARN)

The View Garnishments screen features the following updates:

Field

Description

Limit 1 Percentage

This field displays a value when the Limit 1 Calculation Method is set to (DI-(MxSMW))xP: Disposable Income - (Limit 1 Weekly Multiplier x State Minimum Wage) x Limit 1 Percentage.

 

Print Data Dictionary Report (SYRDD)

The report now provides information for the new Limit 1 Percentage (GRN_L1_PCT) column on the following tables:

Note: These enhancements require patch dbc_820_11223.


Colorado Q3 2023 SUTA Electronic Filing: Updated File Formats in the New System

The ICESA file format in the old MyUI Employer system has been updated in the new MyUI Employer+ system for Q3 2023 reporting.

The following are updates to the ICESA file format allowed by Colorado:

Location

Old

New

S 46

Blank

Adjustment Reason Code (0 or blank for original, 1-9 for adjustment)

Numeric - Reason code for adjustment (if any) to employee wages. 0 or a blank space means original filing. Valid adjustment reason codes are 0,1,2,3,4,5,6,7,8, and 9. The code descriptions are the following:

  • 0 or blank: Original submission

  • 1: Employment and Wages adjusted because of incorrectly reported wages

  • 2: Wages adjusted because worker(s) were mistakenly included/excluded

  • 3: Employment and Wages adjusted to correct computer system, data entry or accounting errors

  • 4: Employment and Wages adjusted because they were reported to the wrong state

  • 5: Employment and Wages adjusted because the workers performed services for a different business

  • 6: Employment details adjusted to reflect correct 12th of the month employment information

  • 7: Employment and Wages Adjusted as a result of an Audit

  • 8: SSN or name changed

  • 9: Other

S 210

Blank

Officer Code

Y or N or Blank. If blank, system will default to N.

S 212

Blank

Employment Data (Month 1)

1 if yes, 0 if no. If blank, system will default to 1 for yes.

S 213

Blank

Employment Data (Month 2)

1 if yes, 0 if no. If blank, system will default to 1 for yes.

S 214

Blank

Employment Data (Month 3)

1 if yes, 0 if no. If blank, system will default to 1 for yes.

 

Create Quarterly SUTA Tax File (PRPSMM)

The ICESA file format generated by the application reflects the following changes:

 

Manage SUTA Tax File Data (PRMSMM)

The following validations were removed from the application:

 

Manage SUTA Quarterly Reporting Data (PRMQRD)

The application now allows one-character adjustment reason codes.

The following Colorado adjustment reason codes were added to the S_SUTA_ADJ_RSN_CD table. You can now select these codes from the Adjustment Reason Code field lookup.

 

Manage Employee Taxes (PRMETAX)

The Owner field is now the Owner/Officer field. The field now is now applicable to Colorado (CO).

Note: This change is also reflected on:


Ohio 2023 Tax Table Updates

Ohio updated its withholding methods effective November 1, 2023. This release applies the following:

Attention: For more information, refer to: https://tax.ohio.gov/static/employer_withholding/wht_optionalcomputerformula_2023.pdf.

Note: These updates require patch dbc_820_11247.


Enhancements


Accounting

Direct EFT File Upload

Costpoint now provides you the option to directly upload EFT files to US bank websites or systems. This eliminates some steps in the previous process where you must store generated EFT files in a repository and require other authorized personnel to retrieve the EFT files and then access your bank’s system and upload the files.

Now, you only must do a one-time setup to integrate Costpoint with your bank’s system, and you can automatically transmit EFT files to your bank in real-time without the need for manual input.

The following enhancements have been applied to Costpoint to support this feature.

 

New Tab in the Product Configuration Utility

Use the new Bank FTP tab in the Product Configuration Utility to set up and store the bank FTP server connections needed to generate and directly upload EFT files to bank systems. You must provide information such as the Bank FTP ID, connection type, FTP host, port, user, password, and company ID to set up a connection. 

After you configure the connection information, you can view the details on the new Bank Integration subtask on the Manage System Integration Accounts screen.

 

Manage System Integration Accounts

The new Bank Integration subtask has been added to the Manage System Integration Accounts screen.

This subtask displays the Bank FTP IDBank LoginPassword, and Confirm Password fields. It only allows you to update the Bank LoginPassword, and Confirm Password fields, but you cannot add, copy, or delete a record. 

The records on this subtask correspond to the bank integration information you set up on the Bank FTP tab of the Product Configuration Utility. 

If you did not set up bank integration information in the Product Configuration Utility, the Bank Integration subtask does not display.

 

Manage Company Bank Accounts (US Banks)

The new Bank Integration group box, which contains the Bank Integration ID field, has been added to this screen to allow you to link your company's bank accounts to credentials that are available on the Bank Integration subtask of the Manage System Integration Accounts screen.

The Bank Integration ID you assign to a bank account will be used to upload EFT files to your bank’s system when you select the EFT Direct Upload checkbox on the Create EFT File screen.

If you did not set up bank integration information in the Product Configuration Utility, the Bank Integration ID field is disabled.

 

Create EFT File

The new EFT Direct Upload checkbox has now been added to the Create EFT File screen. Select this checkbox to upload created EFT files directly to the website or system of the bank account you entered on the Bank Abbr field. This checkbox is displayed only if you selected ACH as the EFT Format Type and is enabled only if the Bank Abbr value you entered has a valid Bank Integration ID on the Manage Company Bank Accounts screen.

If the EFT file is generated and the upload is successful, the message “EFT File has been created and connection to the bank was successful” is displayed. However, if the connection to the bank system is unsuccessful, the message “The EFT file has been created, but connection to the bank has failed. Please upload the file directly to the bank.” is displayed, and you must manually upload the file.


EFT International Format

Costpoint is currently being enhanced to have the feature to create ACH files for outgoing International ACH Transactions (IAT) bound for your vendors’ banks or financial institutions outside the United States. This enhancement is limited only to the creation of ACH files for IAT. Other EFT files for Non-US banks must be created using third-party tools.

Two Accounting screens have been updated to partially support this enhancement. The full functionality of the feature will be available in a future release.

 

Manage Vendors (APMVEND)

The ACH Code drop-down list has been added to the EFT Info (Non-US) subtask of the Addresses subtask.

This refers to the transaction code to be entered in positions 02-03 of the Entry Detail Record in the ACH file. It identifies the transaction as a debit or credit, and the type of account the transaction is intended for.

The ACH Code drop-down list has the following options:

You must first select the Non-US EFT Active checkbox on the Addresses subtask for you to be able to save the ACH Code you selected. If you select an ACH Code but the Non-US EFT Active checkbox is cleared, the ACH Code defaults to None when you save the record.

The ACH Code also displays on the output when you print a Current Record Information report for the EFT Info (Non-US) subtask.

 

Import Vendors (AOPUTLVU)

This screen now has updated validation rules and messages when you import a vendor that has its Non-US EFT Active flag set to Y

Condition

Message Type

Message

The Non-US EFT Active flag is set to Y, but the Non-US Bank ID is blank.

Warning

Non-US Bank ID (NON_US_BANK_ID) is missing for this Non-US EFT record. Non-US Bank ID is required when creating outgoing IAT Files for EFT payments.

The Non-US EFT Active flag is set to Y, but the ACH Code is blank.

Warning

ACH Code (S_ACH_TRN_CD) is missing for this Non-US EFT record. ACH is required when creating outgoing IAT Files for EFT payments.

The Non-US EFT Active flag is set to Y, but the Bank ID (ABA No.) and Bank Account fields are not blank. 

Warning

Warning: Bank ABA Number and Bank Account must be null for a Non-US EFT record. The record will be imported with those values set to NULL.


General

The Do not capture application usage statistics checkbox in System Settings has been renamed to Allow Collection of Usage Statistics. As a result, you must select the checkbox to turn on data sharing and enable Costpoint's In-App Guidance that highlights new features and provides personalized tips and suggestions to improve your use of Costpoint.

If you clear the Allow Collection of Usage Statistics checkbox to stop sharing data, a message is displayed to inform you that In-App Guidance will also be disabled.


CRM & Contracts

Downloading and Importing Updated FAR/DFARS Clauses and Provisions

The latest lists of Federal Acquisition Regulation (FAR) and Defense Federal Acquisition Regulation Supplement (DFARS) clauses and provisions are now available for download on the Deltek Costpoint Document Resources page. These updated lists were released by Acquisition.GOV in September 2023. You can import these files into Costpoint to apply up-to-date clauses/provisions to your contracts and subcontracts.

 

Downloading FAR/DFARS Files

You can download the latest FAR/DFARS lists from Deltek Support Center. Click the following link to go directly to the Deltek Costpoint Document Resources page:

https://deltek.custhelp.com/app/CPDocRes

On this screen, click the DFARS Download or FAR Download button to download a comma-separated values (CSV) file containing the most recent list of FAR/DFARS clauses and provisions. The downloaded .csv file is already formatted as an input file that you can import into Costpoint using the Manage FAR Library and Manage Supplemental Regulations Library applications. 

Note: The input files are designed so that you can readily import them into Costpoint. You can, however, still rename the files or change the content if necessary. 

Below each button is a Last Updated On date indicating when the file was last updated (formatted as mm/dd/yyyy).

If you need assistance in uploading the documents, click the Importing Deltek Costpoint FAR/DFARS button. This brings up a page with information on importing FAR/DFARS clauses and provisions into Costpoint.

 

Importing FAR/DFARS Files into Costpoint

See the following topic for a step-by-step procedure on importing FAR/DFARS files into Costpoint:

Importing FAR/DFARS Files into Costpoint


View Subcontract Inquiry: New Fields

In the Subcontract Inquiry Details table window of the View Subcontract Inquiry screen, the following new fields are now available to provide you additional financial information for the subcontract record and to ensure subcontractor invoices do not exceed the total contract value:

If no project has been associated with the subcontract record, these fields are both blank. 


People

Print/Email W-2 and Support Prior Year W-2s in Employee Self Service (ESS)

Employers can now allow their employees to view and print their W-2s in the correct format from Employee Self Service. New print options are available for employees on the W-2s screen in ESS, which administrators can control through the Manage Taxable Entity Settings screen.

 

W-2s (ESMELECW2)

A new Download and Email button allows employees to download and/or email their copies of Form W-2 as a PDF file. This process is applicable only if the payroll year of the W-2 is 2023 or later. The button launches a parameter window with the following fields:

Field

Description

Payroll Year

From the drop-down list, select the tax year of the Form W-2. The printing of Form W-2 on actual forms is applicable beginning tax year 2023 only.

The values in this drop-down list include the system year and the last four years. The tax years will be further limited based on the Minimum W-2 Year and Maximum W-2 Year on the Manage Taxable Entity Settinga screen.

Examples:

  • If system year is 2023 and the range of W-2 years on the Manage Taxable Entity Settinga screen is 2019-2023, then the drop-down list will have 2023 only.

  • If system year is 2023 and the range of W-2 years on the Manage Taxable Entity Settings screen is 2023-2027, then the drop-down list will have 2023 only.

  • If system year is 2024 and the range of W-2 years on the Manage Taxable Entity Settings screen is 2023-2027, then the drop-down list will have: 2024, 2023.

  • If system year is 2028 and the range of W-2 years on the Manage Taxable Entity Settings screen is 2020-2029, then the drop-down list will have: 2028, 2027, 2026, 2025, 2024.

The default value is the year of the current selected record.

Download

Select this option to download the Form W-2 PDF file.

This is the default selection.

E-mail

Select this option to email the Form W-2 PDF file as an attachment.

Download and E-mail

Select this option to download and email the Form W-2 PDF file.

E-mail Address

This field displays the work email if specified on the Manage Employee Information screen as the default. Otherwise, it shall default from home email. You may also specify another email address.

Company Name

Enter, or click Lookup to select, the company name.

Submit

Select this button to perform the downloading and/or emailing of Form W-2.

Close

Select this button to close the parameter window.

 

Manage Taxable Entity Settings (AOMESSCS)

The Manage Taxable Entity Settings screen provides the following new fields and subtask:

Field

Description

Allow download and email of W-2s

Select this checkbox to allow employees to download or email their copies of Form W-2 (B, C, 2, Instructions).

Print only the last 4 numbers of SSN

When you select this checkbox, employees’ SSN will display only the last four numbers on the employees’ copies of the tax forms.

Tax Forms Subtask

Use this subtask to configure settings related to the electronic delivery of tax forms. This subtask contains the following fields:

  • Tax Form: From the drop-down list, select which employee tax form to set up. Valid options are 1095-C and W-2/W-2c.

  • From: Enter the email address that will be displayed when tax forms are sent to employees' email addresses.

  • Subject: Enter the email subject that will be displayed when tax forms are sent to employees' email addresses. If this field is blank, then the default email subject that will be used by ESS is: <Calendar Year>space<Tax Form>.

  • Body: Enter the email text that will be displayed when tax forms are sent to employees’ email addresses. If this is blank, then the default email text that will be used by ESS is: “The <Tax Form> is attached to this email.”

 

Print Data Dictionary Report (SYRDD)

The Print Data Dictionary Report now provides information about the following, which were added for this feature.


Print Form W-2c and W-3c with Data on Blank Stock

Prior to this release, you can print Form W-2c only on pre-printed forms from recommended vendors. To avoid alignment problems in using pre-printed forms, Costpoint adds the ability to print Form W-2c on plain paper on the Print W-2s screen.

 

Print W-2s (PRRW2)

A new W-2c (Form with Data) group box provides the following options for printing W-2c copies to plain paper.

Field

Description

Substitute Copy A (SSA-Approved)

Select this option if you want to print a black and white Copy A. A separate PDF file for the W-3c will be created and saved in the same location as the Form W-2c Copy A.

  • The Copy A PDF file should be printed on 8.5 x 11-inch single-sheet paper only, not on continuous pin-fed paper.

  • The option to print only the last 4 numbers of SSN will be cleared and disabled for Copy A.

Copy 1

Select this option if you want to print W-2c Copy 1 - For State, City, or Local tax Department.

Copy D

Select this option if you want to print W-2c Copy D - For Employer.

Employee's W-2c Set (B, C, 2, Instructions)

Select this option if you want to print a set of W-2cs per employee with only one W-2c form per page. This set includes Copy B, Copy C, Copy 2, and a copy of filing instructions per employee. If you want a separate PDF file for each set of W-2cs per employee, then you must select the One PDF File per Employee checkbox.

Note: The printing of Form W-2c on plain paper is applicable beginning Tax Year 2023 only. As of this release, Deltek is still awaiting Form W-2c/Form W-3c for 2023 to be approved by the SSA. An error will be displayed if you select the Substitute Copy A (SSA-Approved) option.

 

Manage W-2Cs (PRMW2C)

The existing (b) Employer’s Federal EIN field is now the (b) Employer identification number (EIN) field.


Employer and Employee Information from Generated or Manually Entered W-2s Are Now Stored by Costpoint

When you generate W-2s/W-2Cs from the Create W-2 Table screen or enter the W-2s/W-2Cs on the Manage W-2s and Manage W-2Cs screens, Costpoint now stores the following information:

This enhancement will allow Payroll managers to reprint the employee and taxable entity information for a W-2/W-2C that displays all the W-2 data as it was at the time of the original printing and not use current data for Employer Tax ID, Employer Address, Employer Name, Employee SSN, Employee Name, and Employee Address.

 

Create W-2 Table (PRPCW2)

The application features the following updates:

 

Manage W-2s (PRMW2)

The application now displays the employee’s name and address at the time of the W-2 creation using the new fields in the FED_W2_FILE table.

 

Manage W-2Cs (PRMW2C)

The application now populates the previously reported SSN and employee name from the new fields in the FED_W2_FILE table. The fields will remain enabled.

 

Print W-2s (PRRW2)

The application now populates the employer and employee name and address information from new fields in the FED_W2_FILE table. This will show the employee and employer information at the time the W-2 was created.

 

W-2s (ESMELECW2)

The application now displays the Employer Tax ID, Employer Address, Employer Name, Employee SSN, Employee Name, and Employee Address from the W-2 table (FED_W2_FILE) instead of from the associated table (TXBLE_ENTITY, EMPL). This allows employees to view the original addresses.

 

Print Data Dictionary Report (SYRDD)

The Print Data Dictionary Report now includes information about the new columns in the FED_W2_FILE and FED_W2C_FILE tables.


Roth-Only Catch-up Contributions For High Earners and the Option for Roth Employer Match and Non-Elective Contributions

The United States Congress passed the Secure Act 2.0 which requires employees who made above a certain amount in the prior year to make catch-up contributions to a post-tax Roth individual retirement account (IRA) instead of a pre-tax 401k. The act was originally set to go into effect in 2024 but was later delayed until 2026.

To address the requirements of the new legislation, Costpoint added a new report to display employees who qualify for catch-up contributions, their deductions, age, and income. On the Manage Federal Taxes screen, a new field was also added to hold the prior year’s income requirement threshold for Roth IRA’s.

In addition, the Secure Act 2.0 section 127 permits employers to offer short-term emergency savings accounts (ESAs) to non-Highly Compensated Employees. A new deduction was added for Emergency Savings Accounts.

 

Print Employees Eligible for Retirement Catch-Up (PRPCATCHUP)

Use this screen to print information relating to employees over 50 with catch-up retirement contributions. Print this report any time to see if employees have reached their catch-up limit or to determine which employees meet the high-income threshold for the previous year.

You can print the report for:

The application will use the new Roth Catch-Up Wage Threshold field on the Manage Federal Taxes screen to determine the threshold for high earners. The report displays the employee’s prior year earnings, age, earning type, deduction code, deduction type, YTD deduction amount, contribution code, contribution type, YTD contribution amount, and the total YTD deduction/contribution amount. When the first sort is by employee, the report has a subtotal for each employee for YTD deduction/contribution amounts and the total of deduction/contribution amount.

 

Manage Federal Taxes (PRMFTI)

The Manage Federal Taxes screen adds the following field:

Field

Description

Roth Catch-Up Wage Threshold

Enter the prior year wage threshold amount that was defined by the U.S. government at which retirement contribution catch-ups will be required to be in a post-tax Roth IRA.

This amount will be used by the Print Employees Eligible for Retirement Catch-Up screen to determine which employees must make retirement catch-up contributions to a post-tax Roth IRA.

 

Manage Deductions (PRMDED)

A new Emergency Savings Accounts (ESA) deduction type, which can be used by employers who offer short-term ESAs to non-Highly Compensated Employees, was added to the Manage Deductions screen.


W-2 2023 Copy A Substitute Form Fillable PDF Update and Approval

The Internal Revenue Service (IRS) requires that the Substitute Black-and-White Forms W-3 and W-2 (Copy A) for Tax Year 2023 must comply with the IRS Publication 1141. Forms W-3 and W-2 (Copy A) must be approved by Social Security Administration (SSA).

The Print W-2s application was updated to reflect the updated forms. The changes to the forms are as follows:

2023 Form W-3

2023 Form W-2

The IRS provides the following reminders to employers:

Attention: For more information, refer to:


Planning

Added Profit and Loss by Program Report

The new Profit and Loss by Program application (Organization Budgeting » Profit and Loss Reports) displays the labor and non-labor resources assigned to programs as well as the org budget program trends for the selected fiscal period.

[image]

On the Details subtask, the row directly beneath each revenue and expense line item displays the org budget program name, assigned orgs, and related accounts.

For orgs that are not assigned to any program, the program row displays Unassigned.

[image]

Refer to the online Help for more information.


Cost Type Descriptions Now Customizable within Costpoint

The Customize Standard Labels screen (Admin » System Administration » Workspace Customization) in Costpoint was updated to include the Budget Sheet labels, enabling you to customize these labels wherever they display within Planning.

Note: To learn about modifying the labels, refer to the online Help for Customize Standard Labels.

From the Customize Standard Labels screen, you can customize the following labels:

The modified versions of the labels are applied wherever they display in Costpoint Planning. To illustrate the difference between un-customized and customized labels, several images follow below.

The following is an example of the standard (un-customized) Staff Hours budget sheet label:

[image]

In Project Budgets/EACs, for example, the standard (un-customized) label still displays:

[image]

The following is an example of the same label customized:

[image]

In Project Budgets/EACs, for example, the custom label also displays:

[image]

Other labels customized on the Customize Standard Labels screen may also be applied to the Planning interface. For example:

[image]I

The text shown above, for example, displays on the Planning menu as follows:

[image]


Create Top Level Budget/Outlook Updated for Web Services

To improve compatibility with Web Services and enhance usability, the Create Top Level Budget/Outlook screen (Organization Budgeting » Budget/Outlook Processing) was converted from a maintenance application to a process application.

Instead, after you select screen settings, click the Process icon ([image]) to run the utility.

These fields enable you to save your selections for reuse, either by using Query to find the ID or by using the ID for a scheduled job.

Note: Also due to the conversion, the underlying application ID was changed from bnp_oapaom5 to bnp oapbotl.


Enhancement to Advanced Search Criteria

The Resource Search Criteria section of the Advanced Search screen includes two new search fields:

Previously, details for trainings and courses were aggregated under Skills.

This enhancement applies to Advanced Search in the following applications:

[image]

Select your desired value for each field, and then click Find Resources to display the employees that possess the specified skills, trainings, and courses.

If you want to configure the drop-down selection criteria, use the following applications to add, delete, or modify items:


Project Budget/EAC Mass Utilities Updated for Web Services

To improve compatibility with Web Services and enhance usability, the action buttons (for example, Create EAC) on the Project Budget/EAC Mass Utilities screen (Project Budgeting » Controls and Utilities) were converted to drop-down list items in a new Process field. For example:

[image]

Note: The Process drop-down list is dynamically updated based on the option selected from Status under Budget. In earlier versions, the action button was either enabled or disabled based on the status. Now, the Process drop-down list displays only actions that are valid for the currently selected budget or EAC.

The area of the screen where projects were selected for processing is now replaced by a Selection Ranges section, which includes a Projects drop-down list that provides options for processing all, one, or a range of projects. For example:

[image]

If you select Range from Projects, the Start and End fields are enabled, where you can click to select the starting and ending project IDs, respectively, for processing. For example:

[image]

Conversely, if you select One, only Start is enabled, and neither field is enabled if you select All.

Since the utility is now a processing application, click the Process icon ([image]) after you set all parameters.

Note: Due to the conversion, the underlying application ID was changed from bnp_bgmbpmu to bnp_bgpbpmu.


Revenue Amounts Added to New Business Budgets by Period

In New Business Budgets (Planning » New Business Budgets), the Analysis by Period subtask (formerly named Burdened Cost) now includes revenue amounts in addition to the cost amounts. This update enables Planning to calculate and display the profit amount and the profit percentages on both cost and revenue.

The inclusion of revenue along with raw and burdened cost amounts, and the subsequent profit calculations, provides a more complete analysis of budget performance per period.

Revenue is totaled at the top of the report and expense is totaled at the bottom, directly above profit.

[image]

Revenue can be expanded to display the revenue totals per budget category.

[image]

As part of this update, the Audit Budget Group Details application (Organization Budgeting » Budget/Outlook Processing) now includes the added revenue amounts and the profit calculations. To display these details, select Project and then from the Format drop-down list, select Analysis by Period.


Updated Budget/Outlook Resource Schedule Report

The Budget/Outlook Resource Schedule screen (Organization Budgeting » Labor Analysis Reports) now includes budget program details.

When you run the report with Combined selected, the Details subtask contains a new Program Desc column. For example:

[image]

The value that displays in Program Desc populates from the Program ID column, which is located on the Labor Utilization and Non-Labor Dollar subtasks of the Organization Budgets/Outlooks screen.

The Program Desc column is blank if:


Projects

Project Workforce Start and End Dates for Employee/Vendor/Vendor Employee

In preparation for an enhancement that will allow you to add start and end dates to each employee, vendor, and vendor employee in a project workforce in Costpoint, updates have been made to several applications.

This future enhancement will allow you to limit an employee’s or vendor employee’s work time within the project. In addition, you will not need to remove employees from the workforce, and you will be able to perform a historical review of project workforce records.

 

Updated “Workforce” Label  

The “Work Force” label on field names in the following applications has been changed to “Workforce”: 

 

New Columns on Tables 

Start Date and End Date columns have been added to the following database tables: 

These tables are used by the following applications: 

 

Start and End Dates Included in Import

The Import Project Master Data application has been updated to include the new Start Date and End Date fields in the input file when importing project workforce records. Affected input file layouts include the following: 


Reports & Analytics

Business Intelligence

Updated Data Dictionary Report

The Data Dictionary report now includes the Time & Expense (T&E) data dictionary table. In addition, the underlying Admin model now exposes data from Costpoint, Planning, and T&E for the data dictionary. 

IWA Journal Entries Now Available in the General Ledger Package

In the General Ledger package, you can now pull journal entries for Intracompany Work Assignments to add to your reports or dashboards. 

Print PO Header NAICS Code Business Size and Size Standards on Purchase Order

You can now save the NAICS Size Standards in the PO Header and include the following on the printed PO regardless of business size:

To support this enhancement, the following updates were made to the Procurement Data module:

Updates to Home Dashboard

The My Timesheets section of the Home Dashboard now also displays and links to timesheets that have a status of Missing. The list includes missing timesheets for the previous 10 timesheet periods.

In addtion, to improve the efficiency of querying timesheet data from the Home Dashboard or other areas of Costpoint, such as Business Intelligence, the underlying timesheet summarization tables within Time & Expense are now immediately updated when timesheets are saved, including any automatically calculated overtime.


Time & Expense

Resource Work Schedule Updates

To improve general usability for the Resource Schedules/Leave screen, the following updates were applied:

Note: This button disables when a query is pending.


Timesheet Enhancements

The following enhancements were made to both Timesheet functionality and display to promote ease of use.

 

Reposition Work Schedule in Split Screen View

After you select Work Schedule from the More menu, you can drag it to the right side of the Timesheet application screen in Split Screen view. This layout can be saved.

 

Timesheet Correction Reverses Status When No Changes Made

As a convenience for users, the timesheet correction process was amended so that, if no changes are implemented after the user clicks Correct, a notice displays reading, "No changes were made to this Timesheet." When the user clicks OK to dismiss the warning, this has the effect of performing an Undo Correct action, and the timesheet returns to its original state.


Software Issues Resolved


Accounting


Accounts Payable >> Manage Purchase Order Vouchers


Defect 2002074: The Exchange Rates subtask was not editable for vouchers of subcontractor invoices that have not yet been approved. As a workaround, delete the invoice and recreate it on the Manage Subcontractor Invoices screen.


Accounts Payable >> Manage Vendors


Defect 2008752: You encountered a system error when you entered more than 20 records on the Addresses subtask.


General Ledger >> Manage Financial Statements


Defect 2007785: You encountered an error when you clicked New on the Cash Flow Report Details table window.


CRM & Contracts


Contract Management Controls >> Manage FAR Library


Defect 1991532: "Rescission" was misspelled as "Recession" in the title of FAR clause 52.203-8.

As a workaround, select the Editable checkbox for this clause on the Manage FAR Library screen so you can change the title in contract/subcontract records where the clause is used.


Contracts >> Manage Subcontracts


Defect 2022141: The Notes field on the Notes tab was missing in Form view.

As a workaround, access this field in Table view.


Opportunities >> Import GovWin IQ Data


Defect 1990001: This application now updates the Manage NAICS Codes screen and the OPP_NAICS_CODES table when importing opportunity records with NAICS information from GovWin IQ into Costpoint. 

Note, however, that since GovWin IQ does not store effective dates, for NAICS records added through Import GovWin IQ Data, Costpoint sets the Effective Date field in Manage NAICS Codes to the import date and populates the NAICS Notes field with the following statement: “NAICS imported from GovWin IQ on <Date Imported>.” 


Defect 2016242: The application was not working as expected when you ran it with Option set to Range in the Opportunities to Update group box.


Opportunities >> Manage Opportunities


Defect 1973092: You received a 403 error or a critical system error when you tried to access the Projects Linked subtask.


Defect 2012379: When you click the Refresh from IQ button on the GovWin IQ subtask, the process now also populates the NAICS (primary) field on the Status tab with the opportunity's NAICS code from GovWin IQ. This field will be updated only if it is empty or blank.


Framework


Framework


Defect 1994485: A system error occurred and incorrect data displayed when you overwrote pasted data from Excel and used the same copy/paste method to paste additional rows from Excel.


Defect 1999631: Costpoint allowed workflow delegation to a deactivated user ID while the Employee ID was active.


Defect 2009380: Costpoint allowed workflow escalation to inactive employees and deactivated users.


Defect 2010903: The following error occurred when you browsed for files to attach from SharePoint using Content Management Integration: "java.lang.NumberFormatException: empty String".


Defect 2016131: After attaching multiple documents in Costpoint, the data within SharePoint did not update.


Defect 2019181: The Query button was visible in Offline Mode.


Defect 2022659: Setting the Suppression Type to Labor had no effect on the extensibility field. The extensibility field did not behave as standard UI Labor suppressed fields.


Defect 2026211: A null pointer exception occurred when you were creating a new content type.


Defect 2026626: There were issues with extensions after the MR 8.2.4 upgrade. Modules with extensions gave a NullPointerException error.


Runtime


Defect 1981266: After you updated a timesheet class to require revision explanations, a timesheet that was re-opened and modified immediately following the update briefly displayed, and then the Revision Explanation dialog box closed before you could enter an explanation.


Defect 1996739: You could not continue the workflow approval process via email when you used a specific workflow model.


Defect 2028779: When a workflow that was linked to a screen added by an extension was present, the Approval Workflow Models screen queried records and updated information very slowly. Also, the screen that was added by the extension performed slowly while processing.


Materials


Bills of Material >> Print Indented Bills of Material Report


Defect 1960742: When you ran the Print Indented Bills of Material Report with the Include Scarp/Yield Quantities and Multiply Out Subassembly Quantities checkboxes selected, the quantity per assembly was calculated incorrectly compared to the MRP calculation.


Inventory >> Create Physical Count Adjustments


Defect 1993448: When you moved quantity from one location to another using physical count adjustment, Costpoint used the absolute value to get the total adjustment amount instead of a zero value.


Inventory >> Enter Issues to Project/Account/Org or PO


Defect 2006428: When you created issue to project transactions, costs were posted to the general ledger (GL) when the From and To inventory abbreviations were used. Labor and subcontract costs were posted to the Materials account, forcing journal entries to correct the issue. 


Material Requirements Planning >> Firm Material Requirements Planning Planned Orders


Defect 1997723: The application did not include a Transfer MRP message in the process when the transfer message was for a low-level requirement.


Procurement Planning >> Create Purchase Orders


Defect 2002072: When you tried to add funds to a blanket purchase order (PO), the additional fund was not added to the balance, and the blanket total amount did not reflect the amount from the additional requisition PO line.


Defect 2002073: When you verified the sales tax/VAT amount and sales tax VAT rate on the purchase order (PO), the amount and rate were not taken from the requisition for the PO.


Procurement Planning >> Manage Simple Purchase Requisitions


Defect 2008384: You were unable to edit the description of the Requisition Type even when Allow Modifications to Description was selected.


Procurement Planning >> Print Purchase Requisition Approval Status Report


Defect 2013433: When you tried to print the report by Approver Employee ID, Costpoint did not print the result. As a workaround, print the report by Approval User ID.


Production Control >> Enter Manufacturing Order Issues


Defect 1998395: When you copied/pasted Excel information to a manufacturing order (MO) issue line and pressed TAB, Costpoint changed the issue quantity.


Purchasing >> Manage Purchase Orders


Defect 2006421: When you performed an update to the PO_HDR, multiple rows were created for the UPD ACTION instead of a single UPD row for the header and a single row for each line. 


Receiving >> Manage Purchase Order Receipts


Defect 2016635: When you tried to open a purchase order receipt and clicked the Fixed Assets subtask, you encountered an error. This happened regardless of the purchase order (PO) type.


Defect 2017097: When you saved receipt lines with zero (0) quantity but with a non-zero amount, the value of the received amount reverted to zero and the Save Receive line with Zero Receive Qty/Amt checkbox was cleared after you saved it.


Receiving >> Manage Quality Control Inspections


Defect 1997726: When you reversed the order for the lot entry and saved it, the first lot was duplicated on the Serial/Lot Info subtask on quality control inspection. 


People


Employee >> Import Employee Data


Defect 1970715: The report cover page did not reflect the new and updated field names on the screen.


Defect 1995903: The report displayed error messages when:


Defect 2014313: When the standard hours were 0.00 in record 2, the Estimated Annual Hours on the Manage Employee Salary Information screen were not updated.


Defect 2025889: The application entered a NULL value (blank) in the HUA_ACTV_MAP_FL column on the Employee (EMPL) table, which caused an onscreen error even though the field is not visible to users. The following error displayed as a result of this issue: “The following field is required: Active HUA ID Mapping.”


Employee Self Service >> Address/Phone


Defect 1992564: The field labels, screen layout, and application logic were updated.


Employee Self Service >> Designate Beneficiaries


Defect 2025553: An error message should display if you change a beneficiary, who has existing current beneficiary records, to a dependent. The application should display all records in the HB_EMPL_LIFE_BNFIC table for the employee.


Employee Self Service >> Life Events/New Hires


Defect 2009215: When you saved a record for the first time without making changes on the AD&D tab, the following information message did not include AD&D: "The following tabs have not been modified so their status will be set to 'No change'." When you saved the record again for a benefit type that was still not AD&D, the same message was displayed for AD&D alone.


Labor >> Create Retroactive Timesheet Adjustments


Defect 2005537: Fatal error messages were displayed if you retroactively adjusted timesheets that had different exchange rates for the same employee.


Labor >> Export Project Manufacturing Data


Defect 2010213: MO issue quantities were doubled when exported to Manufacturing Execution (MES) if you used the following setup:


Leave >> Create Quarterly Family and Medical Leave File


Defect 2016844: The report displayed incorrect paid family and medical leave pay type earnings calculation. The application should check if:


Leave >> View Leave History


Defect 2010894: Even when the Suppress Labor function was enabled for a user, the user was still able to view the amounts for employee leave on the View Leave History screen.


Payroll >> Compute Payroll


Defect 1996141: The application did not compute negative earnings for worker’s compensation when you processed a reversing timesheet from prior payroll period to make corrections.


Payroll >> Manage Local Taxes


Defect 1997826: The Supplemental Tax Rate field should be set to 0.00 and disabled if you selected the YTD Tax option in the Tax Based On field.


Payroll >> Print W-2s


Defect 2021621: You encountered a system error when the application processed a non-contiguous range of home organizations.


Planning


Administration >> Delete Historic Project EACs


Defect 2016103: You encountered a system error when you selected the option One for the Project field and Lookup did not display the project list.


Administration >> Maintain Project Budget Security


Defect 2018961: When you tried to select a project ID, you encountered a system error and Lookup did not display the project list.


Administration >> Report Table Update Process


Defect 2016859: You encountered a refresh process error when the revenue algorithm did not include PROJ_SUM period changes.


Administration >> User Maintenance


Defect 2013510: The Security Org ID Lookup has been updated to display the Organization ID and Organization Name in separate columns.


New Business Budgets


Defect 2005655: The Funding and Revenue Analysis screens did not display the correct amounts for Funded and Estimated Value, respectively.


Project Budgeting >> All Cost Breakdown


Defect 2005647: The sort order has been changed so that the raw cost lines are placed above the burden cost lines. This change applies when you select Cost as report type.


Project Budgeting >> Budget/EAC Status


Defect 2018962: The following sections have been added with options to display top-level projects:


Defect 2018964: The application has been updated to enable budget/EAC calculations for any remaining top-level and lower-level projects that have start and end dates.


Defect 2018969: The option to include Inactive Tasks has been removed from this report to make it consistent with other reports.


Project Budgeting >> Import Budget/EACs from Excel


Defect 2012142: You encountered a validation routine error when you tried to import budgets or EACs from Excel. The routine looked at accounting periods instead of budget periods.


Project Budgeting >> Pending Charges


Defect 2014124: Project ID Lookup includes a new Organization column that displays the ID of the organization that owns the project.


Defect 2014131: When you queried a project for the first time, you had to click Execute twice to populate the Pending Charges Detail subtask.


Project Budgets / EACs


Defect 2005564: The application erroneously allowed the deletion of rows that contain Actuals from closed periods instead of displaying the error message "Cannot delete row, as it contains actuals in closed periods." This error impacted costs and revenues.


Defect 2016100: The application now allows you to delete older versions of budgets or EACs.


Defect 2016747: You encountered duplication issues when you tried to create, commit, and approve budgets and EACs.


Defect 2021186: The application has been updated to enable the addition of employees with Family Medical Leave (FML) status into working budgets or EACs through the Hours subtask. The employee lookup displays the employees with FML status.


Projects


Billing


Defect 2033219: You encountered a performance issue when you updated the BILLING_DETL_HIST, BILLING_SUM, and BILL_EDIT_DETL_CUM tables.


Billing >> Post Standard Bills


Defect 1986495: You received the following error message when you clicked the Print icon on the Post Standard Bills screen: “The posting you are attempting is not in balance. This program does not allow unbalanced postings. Printing and/or Posting will not be executed.”

As a workaround, click the Default Action (gear) icon and select Print/Post Standard Bills to print and post without errors.


Budgeting and ETC >> Import Project Budgets


Defect 1991424: When you ran this application, Costpoint automatically imported project budgets to the Manage Project Budgets By Period (PJMBDPER) application. This issue affects MSS database users.


Cost and Revenue Processing >> Compute Revenue


Defect 1990231: You encountered a performance issue when running the Compute Revenue screen.


Defect 2005806: When you ran this application, Costpoint backed out previous over ceiling amounts, which caused an incorrect Other Fee value.


Defect 2028875: Performance tuning has been conducted for this application to improve performance.


Project Inquiry and Reporting >> Print Revenue Summary Report


Defect 1982612: In the Project Revenue Summary Report, the Contract to Date Value (w/o Future Mods) for the prior year was incorrect.


Project Inquiry and Reporting >> View Project Ledger Activity


Defect 1991857: You encountered a system error when you ran this application.

As a workaround, click Execute without entering values in the fields under View Project Ledger Activity and then use Query to filter the results in Project Ledger Inquiry.


Project Setup >> Manage Project User Flow


Defect 1962848: When you clicked Copy » Copy Data to Paste into New Record(s) on a project and then clicked Copy » Paste Data on another project, the following error message displayed even though the record did not yet exist on the latter project: “This record already exists. This combination of columns must be unique.”

This issue existed on the following subtasks of Manage Project User Flow:

The issue also occurred on the Award Fee subtask of the Manage Modifications application. 

As a workaround, you can use Copy Data to Paste into New Record(s) and Paste Data in the corresponding stand-alone applications of the subtasks, or manually enter the new record(s) in Manage Project User Flow.


Project Setup >> Manage Revenue Information


Defect 1965785: When you selected the ITDCPFC - Other Fee on Revenue Level checkbox and edited the Fiscal Year field in offline mode and then switched to online mode, the Fiscal Year was blank even though it had already been modified in offline mode and the ITDCPFC - Other Fee on Revenue Level checkbox was unselected. This issue occurred when the ITDCPFC - Other Fee on Revenue Level checkbox was not selected in Configure Project Settings » Revenue.

As a workaround, click Fiscal Year and select Offline value: <value>, manually select the ITDCPFC - Other Fee on Revenue Level checkbox, and then click Save.


Defect 1972612: When you updated multiple revenue formulas using the Find, Replace, or Paste Data from Excel functions and then saved the record, there was no prompt message for the Fiscal Year field.

As a workaround, update the revenue formulas individually.


Defect 1982614: Fiscal Year was disabled when you changed the ITDCPFC - Other Fee on Revenue Level checkbox selection in Table View using the Replace function for a single record.  

As a workaround, select or clear the checkbox in Form View.


Subcontractor Management >> Manage Subcontractor Invoices


Defect 2002068: The Exchange Rates subtask was not editable for invoices that had not yet been approved.

As a workaround, delete the invoice and then recreate it.


Subcontractor Management >> Manage Work Assignments


Defect 1988535: You encountered a performance issue when adding, deleting, editing, sorting, or closing charge lines for work assignments with more than 500 lines on the Manage Work Assignments screen.


Reports & Analytics


Business Intelligence


Defect 1997301: The following columns of the Corpay Portal Vendor Listing report did not display values that were associated with the selected fiscal year and period on the prompt page: 


Defect 2001321: Blank pages were generated in the Purchase Order report.


Defect 2014524: An error occurred when you generated the Employee Earnings report in Team Content » Payroll. This defect affects you if you run Costpoint Business Intelligence with an Oracle database. 


Defect 2020684: The generated Data Dictionary report in Team Content » Costpoint Administration did not display the correct prompt page selections on the Selection Criteria tab.


Time & Expense


Configuration >> Resource Information


Defect 2000985: Timesheet Print report performance has been improved.


Expense >> Expense Report


Defect 2007984: Location was not validating all fields before allowing you to save the line to expense reports and user favorites.


Defect 2021285: When a proxy user cloned an expense report and assigned it to a different user, a system error was received instead of an error message stating the assigned user could not use the ER type.


Defect 2026700: Backup approvers were unable to approve a task unless they were manually assigned to approve it.


Expense >> Manage/Approve Expense Reports


Defect 2002929: When a workflow contained multiple tasks of a different type, the expense report closed after you approved the first task.


Expense >> Per Diem Schedules


Defect 2006978: When you manually entered a per diem schedule row, you should have received an error message indicating that the Description field was blank.


Expense >> Print Expense Authorizations


Defect 1980574: You received a system error when you previewed an expense authorization with a Report Type that has an apostrophe.


Defect 2016801: When you printed an expense authorization, it included project IDs instead of the abbreviation.


Expense >> Print Expense Report


Defect 1980576: You received a system error when you previewed an expense report with a Report Type that has an apostrophe.


Time >> Manage/Approve Timesheets


Defect 2007827: After you used the Reset line function for a line where you updated the hours and charge code, the totals in the lower portion of the timesheet displayed incorrectly, and you received an error indicating that the MasterServlet had failed.


Defect 2017863: After the PreApprove Stored Procedure returned a warning message and you declined to approve a record, the status changed to Approved after you approved the next record.


Defect 2025808: When you approved a timesheet, you received the following error message: "TSApproveRSLineValidation.validateRow-----java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000".


Time >> Resource Activity


Defect 2027129: When you printed a resource activity report, it still included hours that were deleted on the timesheet.


Time >> Resource Schedules/Leave


Defect 2021107: When the default start and stop time for any work section fields was 12:00 AM, you received an error message indicating that the leave start time must be before the leave end time. This issue also affected other applications.

Affected Application

Defect No.

Work Scheddule

2021322


Time >> Time Settings


Defect 1952255: You received an error message stating that Allow Unauthorized Charges is not allowed if you are using Group Cache Charge Lookup.


Time >> Timesheet


Defect 1988945: You received a system error when you added a new timesheet line and UDT charge and then selected Refresh Subtask while the timesheet was still unsaved.


Defect 2003893: Replacement Signature and Replacement Approve tasks did not display if the timesheet was processed.


Defect 2008019: When you copied data from one project to paste into another, you received an error message indicating that the record already exists, even though it does not. This issue also affected other applications.

Affected Application

Defect No.

Manage/Approve Timesheets

2008845


Defect 2009735: The Explanation text "Timesheet created" was updated to "Timesheet Created" in Revision Audit.


Defect 2012244: When you corrected and then uncorrected a timesheet, the original transaction was removed and the leave balance was incorrect.


Defect 2027748: When you deleted a start/stop line, the timesheet hours did not update correctly after saving.


Defect 2027757: Though the Timesheet class was set to Line Reverse on Correct, hours entered on a deleted line were not included on the exported timesheet. This issue also affected other applications.

Affected Application

Defect No.

Export Timesheets

2027758


Time >> Work Schedule


Defect 2006949: On months that start on Friday and Saturday, the calendar view was not displaying all rows, and there was no scrollbar.


Security Enhancements

There are no security enhancements or security issues addressed in this release.


Database Changes

Database Change documents detail data dictionary changes from one release to the next. To see the Database Change document for this MR, refer to 8.2.x Data Dictionary Updates.


Other Links

Online Help

Costpoint Information Center (CIC)

Costpoint Cloud Information Center (CCIC)


© 2023 Deltek

Return to Top