Deltek Costpoint 8.1.7 Release Notes (Build 8.1.7.5005)
Welcome to the Deltek Costpoint 8.1.7 Release Notes, which describe the new features, enhancements, and software corrections introduced in this release.
These release notes address all of the modules associated with Deltek Costpoint 8.1.7, 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 will make a PDF available for a while, as we transition to the new format.
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.
Kentucky Revised 2022 SUTA Wage Base
Kentucky suspended the taxable wage increase for 2022. The state’s unemployment-taxable wage base for 2022 decreases from $11,100 to $10,800. This update is effective January 1, 2022, retroactively.
Attention: For more information, refer to: https://kewes.ky.gov/Contact/contacts.aspx?strid=2.
Note: This enhancement requires patch dbc_810_10865.
W-2c Electronic Filing Support
The Taxpayer First Act, which became Public Law 116-25 on July 2019, requires more employers to file W-2s or W-2Cs electronically. Although the IRS has not yet issued formal regulation on the implementation, here is the tentative schedule:
By midnight on January 31, 2022, employers who file 100 or more W-2s or W-2Cs will have to send W-2s or W-2Cs to SSA electronically.
By midnight on January 31, 2023, employers who file 10 or more W-2s or W-2Cs will have to send W-2s or W-2Cs to SSA electronically.
When the IRS issues formal guidance on implementing this new law, the above date may change. The IRS has the authority to penalize any employer who does not file electronically if they meet the threshold.
Costpoint has existing capability to generate EFW2. However, to support IRS requirements, Costpoint adds the ability to generate EFW2C to the Create Federal W-2 File screen. W-2 corrections beginning tax year 2021 will also be supported.
Attention: For more information, refer to:
Taxpayer First Act: https://www.ssa.gov/employer/taxpayer.html
Filing Forms W-2c Electronically (EFW2C) for Tax Year 2021: https://www.ssa.gov/employer/EFW2&EFW2C.htm
Create W-2 Table (PRPCW2)
You can now generate W-2c records on the Create W-2 Table screen. The screen provides the following new options:
Field
Description
Record Type
Select which type of records you are processing. Valid options are:
W-2: Select this option if you are processing Form W-2 records.
W-2c: Select this option if you are processing Form W-2c records. A W-2c can only be created if a W-2 record exists for the Payroll Year/Taxable Entity/Employee/Tax Service Group ID. W-2c records can be viewed and edited on the Manage W-2Cs screen. If you select this option, the application will generate the new Create W-2c Table Report.
Note: Deltek recommends the use of Arial Narrow font for the Create W-2c Table Report.
Recreate W-2s/W-2Cs
Select this check box to recreate the W-2 or W-2c table. When you select this check box, Costpoint implements the following:
If you select W-2 as the Record Type, then any edits entered on the Manage W-2s screen are lost when you recreate the W-2 table.
If you select W-2c as the Record Type, then any edits entered on the Manage W-2Cs screen are lost for the record with the highest sequence number when you recreate the W-2c table.
The application will insert W-2c data into the following new W-2c tables:
FED_W2C_FILE
BOX_12_W2C_FILE
STATE_W2C_FILE
LOCAL_W2C_FILE
Manage W-2Cs (PRMW2C)
The new Manage W-2Cs screen provides you with the ability to add, retrieve, view, or edit W-2c records. This includes the following actions:
View or edit W-2c data created by the Create W-2 Table screen.
Change amounts of an existing W-2c.
Enter new records.
Manually add a W-2c record to correct a previously reported W-2 or W-2c.
The information on this screen will be used to create the electronic federal W-2c (EFW2C) on the Create Federal W-2 File screen. You can edit this screen after creating the W-2c table on the Create W-2 Table screen and before generating the electronic W-2c on the Create Federal W-2 File screen. To access this screen, click People » Payroll » Year-End Processing » Manage W-2Cs.
Create Federal W-2 File (PRPW2F)
You can now create an electronic W-2c file on the Create Federal W-2 File screen. The screen provides the following new options:
Field
Description
File Type
Select the type of file that you are processing. The following are the options:
EFW2: Select this option if you are creating electronic W-2 (EFW2) for submitting annual Form W-2 Copy A (Wage and Tax Statement W-2) data.
EFW2C: Select this option if you are creating electronic W-2c (EFW2C) for submitting annual Form W-2C Copy A (Corrected Wage and Tax Statement W-2C) data. If you select this option, the application will generate the new Federal W-2c File Report.
Note: Deltek recommends the use of Arial Narrow font for the Federal W-2c File Report.
Originally Reported Establishment Number
The Establishment Number is a four-position identifier determined by the employer, which further distinguishes the employer reported in an RCE (Employer) Record. The establishment number can be alpha, numeric, or alphanumeric.
Enter the incorrectly reported Establishment Number. This field will only be enabled if File Type is EFW2C.
Leave the field blank if you are not correcting the originally reported Establishment Number.
Correct Establishment Number
The Establishment Number is a four-position identifier determined by the employer, which further distinguishes the employer reported in an RCE (Employer) Record. The establishment number can be alpha, numeric, or alphanumeric.
Enter the correct Establishment Number. This field will only be enabled if File Type is EFW2C.
Leave the field blank if you are not correcting the originally reported Establishment Number.
You may use this field even if you are not correcting the originally reported Establishment Number. For multiple RCE (Employer) Records with the same EIN, you may use this field to assign a unique identifier to each RCE (Employer) Record. For example, store or factory locations or types of payroll.
Export Payroll Taxes (PRPEXTAX)
You can now export W-2c data on the Export Payroll Taxes screen. The screen provides the following new option:
Field
Description
W-2c
Select this option to create the W-2c tax file. Any data provided in the Manage W-2Cs table will be exported. If you select this option, the application will generate the new Export Payroll Taxes Report (W-2c File).
The application will source the W-2c data from the following new W-2c tables:
FED_W2C_FILE
BOX_12_W2C_FILE
STATE_W2C_FILE
LOCAL_W2C_FILE
The following are the updates to the file and report:
A new field, Record Type, was added to the W-2 file to distinguish the W-2 (Record Type: W2) information from W-2c (Record Type: W2C). If the Record Type is W2, existing W-2 fields will continue to report the W-2 information. If the Record Type is W2C, existing W-2 fields will report the correct information from W-2c tables.
New W-2 File fields were added to report the previously reported information from W-2c tables.
A new report, Export Payroll Taxes Report - W-2c File, was added to separately report W-2c data.
Print Data Dictionary Report (SYRDD)
The Print Data Dictionary Report now provides information for the following new tables:
FED_W2C_FILE
BOX_12_W2C_FILE
STATE_W2C_FILE
LOCAL_W2C_FILE
Accounts Payable >> Manage Vendor Terms
Defect 1604304: You encountered an error when you clicked Next to browse through vendor term records. This occurred when you created ten or more new records, clicked Save, logged off Costpoint, and logged on and reopened the Manage Vendors Terms screen.
Accounts Receivable >> Manage Customers
Defect 1629514: When you used Form View and browsed through customers using the Previous and Next buttons and then switched to Table View, Costpoint marked the records you viewed in Form View as modified and deleted their Long Name.
Security >> Manage Segregation of Duties Conflict Overrides
Defect 1627898: When you ran Manage Segregation of Duties Conflict Overrides (SYMCFLO) with the Manually Approved check box selected, the Name field populated with a random username for all groups and users listed.
System Administration >> Compute Cobra Burden Costs
Defect 1577256: When you ran the Compute Cobra Burden Costs process, an error occurred because the level for actual cost information was missing. To address this issue, you can now specify the Level at which to capture actual costs on the Manage Cobra Extraction Parameters screen. The new drop-down list provides the following options:
Control Account
Work Package
The Level at which to capture actual costs field is required, and your selection in this field must match the selection on Cobra's Project Properties screen.
System Administration >> Manage Cobra Extraction Parameters
Defect 1626699: When you ran the Compute Cobra Burden Costs process, an error occurred because the level for actual cost information was missing. To address this issue, you can now specify the Level at which to capture actual costs on the Manage Cobra Extraction Parameters screen. The new drop-down list provides the following options:
Control Account
Work Package
The Level at which to capture actual costs field is required, and your selection in this field must match the selection on Cobra's Project Properties screen.
Opportunities >> Manage Opportunities
Defect 1606611: When you cloned an opportunity record, the new record copied the stage from the cloned record instead of the stage specified in the Initial Stage to assign to new Opportunity records field on the Configure Opportunity Settings screen.
External Tools >> XTDESIGNER
Defect 1613632: You might have received the following extensibility formula error when you tried to add a formula to enable a drop-down control: Error: java.lang.Exception: Can't parse formula :XT_LVL_NO==3 || isRowNew ( );Result set id: null; Object id: XT_NTE_FL;Formula type: formula.
Framework
Defect 1611930: The Build Rate Application Table (PJPBLDRA) process did not run without using a saved parameter.
Defect 1627406: The E-mail plug-in generated a system error when Extensibility users sent emails to Costpoint user groups.
Defect 1630913: A system error occurred in Import GovWin IQ Data (CTPIQDAT) when importing assessment information with no Assessment license in GovWin IQ.
Runtime >> Client
Defect 1628002: The Print Options button was enabled when it should not have been, which, as a result, allowed users to corrupt data.
Product Definition >> Manage Parts
Defect 1618710: When you modified the lead time table, the total lead time days were not equal to the item lead time days upon checking on the Lead Time subtask.
Production Control >> Manage Manufacturing Orders
Defect 1620086: You were unable to load the same part from multiple inventory abbreviations in manufacturing order (MO) requirements.
Purchasing >> Buyer Dashboard
Defect 1614269: When Organization Security was enabled, the Open Request for Quotes dashpart of the Buyer Dashboard displayed only "Loading Data."
Purchasing >> Import Purchase Orders
Defect 1612615: When you updated the Project/Account/Org via Import Purchase Orders, the Project and Account were updated, but the Org was not updated when you checked in Manage Purchase Orders.
Purchasing >> Manage Purchase Orders
Defect 1609182: You were unable to change the purchase order (PO) line accounts allocation rate via the Web Integration Console (WIC).
Purchasing >> Reconcile Purchase Orders
Defect 1614677: You encountered a performance issue when you used the application.
Sales Order Entry >> Import Sales Orders
Defect 1618772: When you reuploaded an input file after adding header notes, the system did not display an error but stopped processing the input file.
Defect 1627993: When you added sales order (SO) header notes for the input file, renamed the original import file, and then reuploaded it, the Remit address disappeared from the SO.
Sales Order Entry >> Manage Sales Orders
Defect 1612613: When you updated the sales order (SO) line warehouse ID and the purchase order ship ID of an SO line that was already issued and shipped and then invoiced it, the system created a new reservation for the new warehouse, which then never got completed because the SO line was already completed.
Benefits >> Create 1094-C and 1095-C Data
Defect 1610535: The source of the plan start month should be the benefit year's plan year start date month. It should not be the month of the employee's coverage start date.
Employee >> Manage Leave Beginning Balances
Defect 1625180: The screen should display a warning if your Balance Transfer Information setup will transfer the balance from a leave code that is based on units of hours worked to one that is not.
Employee Self Service >> State Withholding
Defect 1623153: When you used the screen in Table view, the values in the drop-down fields were truncated.
Employee Self Service >> Total Comp/Benefits Statement
Defect 1607881: An unnecessary header was removed to improve the screen layout. The employee name and ID will now display at the top of the Total Compensation Summary table.
Labor >> Allocate Compensated Overtime Across Timesheet Lines
Defect 1622207: The allocation was incorrect when you selected the Weekly option as the Overtime Calculation Method for processing a single timesheet with multiple timesheet lines that have the following setup:
The timesheet lines had line dates.
The Overtime Basis for the state was Weekly.
In this scenario, the allocation only worked correctly when you selected the Daily option as the Overtime Calculation Method. This setup is wrong since the Overtime Calculation Method should match the state setup.
Labor >> Export Data to Deltek Time and Expense
Defect 1633187: You could not export charge trees from Costpoint when Tree Code was set to Project Owning Org. Charge tree exports stopped responding at 90%, and then the process failed.
Defect 1644244: After you upgraded to MR 8.1.4, Costpoint no longer exported company groups to Deltek Time and Expense. This issue occurred when you have only one company in Costpoint.
Labor >> Manage Timesheets
Defect 1627084: A system error displayed when you clicked Standard Variance on the Manage Timesheets screen and when you ran the Standard Variation process type on the Apply Timesheet Adjustments in Batch Mode screen.
Labor >> Manage Union Profiles
Defect 1607914: The Project Information subtask required valid values in the Crew and Crew Chief fields. This prevented you from entering new union project information if your company does not have crews/crew chiefs. To address this issue, the Crew and Crew Chief fields on the subtask will no longer be required.
Payroll >> Export Payroll Taxes
Defect 1622206: For an Employee Tax (ET) record with a tax type of LCEE, the application should populate field 45 (Employee Resident PSD Code) with the value from the PA_PSD_CD field on the EMPL_TAX record of the employee.
Payroll >> Manage Deductions
Defect 1603466: The application should not allow you to select PCTNET as a computation method for 401K Deduction.
Administration >> Maintain Fiscal Year Periods
Defect 1625857: The application created duplicate records in the ESUB_PD table when you entered fiscal years with an alphanumeric code.
Administration >> Report Table Update Process
Defect 1621077: The refresh process was not completed successfully because you encountered a system error.
Project Budgeting >> Calculate Earned Value
Defect 1604396: When the top-level summary line did not have a Progress %, the values of summary columns were the sums of the sublevels, except for the Schedule Performance Index (SPI), Cost Performance Index (CPI), To Complete Performance Index (TCPI), and Independent Estimate at Complete (IEAC) columns, which should be calculated using specific formulas.
Project Budgeting >> Import Budget/EACs from Excel
Defect 1579814: The performance of Import Budget/EACs from Excel was slow due to the application's validation and error-reporting routines.
Project Budgeting >> Project Budget/EAC Mass Utilities
Defect 1622344: You were unable to create an EAC for a project if PoP Ended was selected. To correct this, the application was updated to allow you to create an EAC when the budget period of performance has ended.
Project Budgeting >> Project Budgets/EACs
Defect 1585287: Performance issues related to deadlock were resolved.
Defect 1628560: The rate ceiling of the top-level account was not used to calculate the project's burdened cost.
Defect 1633622: When you calculated burdened cost using a custom Burden Template, the fringe amounts obtained were not as expected.
Project Budgeting >> Project Spend Chart
Defect 1575804: You encountered an error when you attempted to print the Project Spend Chart that was downloaded and saved in PDF format.
Project Budgeting >> Project Status
Defect 1633507: When you clicked the Ending date field, the Period End Date drop-down list did not display.
Billing >> Calculate Progress Payment Bills
Defect 1603280: When you calculated a monthly progress payment bill, the Line 26 value that displayed on the 1443 bill was incorrect (displayed on the Line Info 20-26 tab of the Manage Progress Payment Bills screen).
Billing >> Calculate Standard Bills
Defect 1622286: The application did not calculate burden costs when there was a burden cost ceiling and the account was in the base of more than one pool.
As a workaround, you can manually calculate burden costs, or you can remove ceiling entries and edit the standard bill.
Defect 1622290: This application did not populate the MU_ORIG_BILL_RT_AMT column in the BILL_EDIT_DETL table.
Defect 1622986: When the billing currency was not equal to the functional currency and there was a bill already posted for the project, this application ignored the direct cost ceiling that was set up for an account when computing bills.
As a workaround, when the ceiling is reached, you can set the transaction amount to on-hold so the bill will not be calculated for the account.
Defect 1623152: A system error occurred when you calculated a bill for a project with Customer Terms set to the 31st DOM in Manage Project User Flow.
As a workaround, on the Proj Bill Info subtask of Manage Project User Flow, set the project's Customer Terms to the 30th DOM (that is, the customer terms selected should have Day of Month set to 30 in Manage Customer Terms).
Defect 1631260: This application did not correctly calculate hour ceilings when both hour ceilings and employee hour ceilings exist.
As a workaround, you can remove either the hour ceilings or the employee hour ceilings.
Defect 1631489: The application did not correctly allocate the Retainage and Over Cost Ceiling amounts in ACRN bills, which resulted in a mismatch between the Invoice Amount and Current ACRN Value displayed on the Manage ACRN Bills screen and ACRN Billing Edit Report.
As a workaround, you can edit the Current ACRN Allocation Value in Manage ACRN Bills.
Defect 1633680: BILL_RT_AMT/MU_BILL_RT_AMT in the BILL_EDIT_DETL table was populated with values from the PROJ_BILL_INFO or OVRIDE_FEE_ON_DIR table.
Defect 1633738: When the posted transactions had net zero hours for a particular project labor category, the MU_BILL_RT_AMT value was zero in the BILL_EDIT_DETL table for records with RPT_ONLY_FL = Y.
Defect 1635586: An error occurred upon running this application when Position of Fiscal Year Code was set to First for Prior FY on the Configure Billing Settings screen.
As a workaround, set Position of Fiscal Year Code to Last.
Defect 1638823: When the Use Transactional Currency Billing check box was selected on the Manage Project Billing Information screen and you ran Calculate Standard Bills for records with a billing currency not equal to the functional currency, the total of the WAWF_WH_AMT column did not match the Withholding amount under the MU_RTNGE_AMT column in the BILL_EDIT_DETL table.
Defect 1638881: There was a rounding issue in WAWF columns for multicurrency bills in the BILL_EDIT_DETL table, which caused a mismatch between the Current ACRN Value and Invoice Amount on the Manage ACRN Bills screen.
Defect 1645932: You encountered the following system error when you ran this application: "Can't parse sql statement: INSERT INTO (BILL_EDIT_KEY, BILL_FM_GRP_NO, BILL_FM_GRP_LBL...)." This error occurred when both the Show Timesheet Date and Show Timesheet Comments check boxes were selected on the Hours tab of the Manage Generic Billing Formats screen.
Billing >> Update Billing Tables Bill Labor Category Description
Defect 1620115: A critical system error occurred when you ran this application for a project with a rate sequence containing more than one source project (with linked PLC/rates) within the same project tree.
As a workaround, on the Def Rate Seq subtask of the Manage Project User Flow screen, limit the source project with linked PLC/rates to only 1 per project tree.
Cost and Revenue Processing >> Assign Account Function Codes
Defect 1603284: The application was taking longer than expected to complete processing. Performance tuning has been conducted to improve the application's runtime.
Cost and Revenue Processing >> Compute Revenue
Defect 1610371: Primary and foreign keys have been removed from the following ADT tables to improve this application's performance:
CEIL_BURDEN_CST_ADT
CEIL_DIR_CST_ADT
CEIL_DIR_HRS_ADT
EMPL_CEIL
OVRIDE_FEE_ON_BURD_ADT
OVRIDE_FEE_ON_DIR_ADT
OVRIDE_MLT_ON_DIR_ADT
PROJ_ACCT_DISC_ADT
PROJ_ADT
PROJ_MOD_ADT
PROJ_REV_SETUP_ADT
PROJ_VOLUME_DISC_ADT
REV_ADJ_HIST_ADT
VEND_CEIL_ADT
Defect 1625764: Performance tuning has been conducted to improve this application's runtime.
Cost and Revenue Processing >> Create Multi-Job Allocation Entries
Defect 1612584: You encountered an intermittent error when running this application.
Cost and Revenue Processing >> Post Revenue
Defect 1621176: Costpoint did not allow you to post revenue to inactive account/organization combinations when Rate Type was set to Target, Total Target Revenue Amount was equal to Reallocation Amount, and Total Target Revenue Amount was not equal to zero in the PROJ_SUM table. Actual revenue and reallocation amounts, on the other hand, were not equal. The system should not have validated for invalid account/organization combinations.
Project Setup >> Check and/or Rebuild Project Segment IDs
Defect 1605571: This utility was not identifying all invalid project segments.
Project Setup >> Manage Prior Year Cost and Revenue
Defect 1615139: When you entered only incurred amounts in Microsoft Excel and copy-pasted these data into the Details table window, Costpoint also populated direct allowed amounts.
This defect updates the copy-paste functionality to only auto-populate fields when the pasted value is null. If a value (including zero) is being pasted, the system will not overwrite that value.
Defect 1622179: When you entered only incurred amounts in Microsoft Excel and copy-pasted these data into the Prior Year Pool Amounts subtask, Costpoint also populated the other fields.
This defect updates the copy-paste functionality to only auto-populate fields when the pasted value is null. If a value (including zero) is being pasted, the system will not overwrite that value.
Project Setup >> Manage Project User Flow
Defect 1611091: On the Proj Levels subtask, when you copied a record and tried to save the newly created record, the following error message displayed: “This record already exists. This combination of columns ( 'PROJ_ID_TOP (Hidden) ','PROJ_LVL_KEY (Hidden) ' ) must be unique.”
As a workaround, manually enter the project level that you want to add.
Business Intelligence >> Business Intelligence
Defect 1616466: The Funded Value Total Amount in the Real Time Project Status Report was not displayed. In addition, the Funded Cost Fee label on the header should have been Funded Value Cost.
Defect 1625669: An ambiguous column error occurred when you generated the Revenue Forecasts report.
Defect 1625678: An ambiguous column error occurred when you generated the Burdened Labor Costs by Project report.
Defect 1626035: An error occurred when you opened the Burdened Labor Cost by Project report because of an Oracle compatibility issue.
Configuration >> Charge Trees
Defect 1631728: You received the error message "Invalid -UDT06" when you saved a charge that was not multi-company and no UDT06 was specified.
Configuration >> UDT01 Types
Defect 1621568: When you queried for more than one record, an internal error occurred and you received an "invalid metadata" error message.
Expense >> Expense Authorization
Defect 1608372: Though the user's locale was configured for non-English, the text associated with submitting the expense authorization displayed in English.
Expense >> Expense Report
Defect 1594250: When a per diem ceiling expense was claimed as part of a batch expense, and the expense amount was over ceiling, the entire expense amount was applied as under ceiling.
Defect 1608380: Though the user's locale was configured for non-English, the text associated with submitting the expense report displayed in English.
Defect 1615913: When you added a manual outstanding expense to a multicurrency expense report, the exchange rate was not drawn from the currency schedule and so defaulted to "1.00."
Expense >> Manage/Approve Expense Authorizations
Defect 1608370: Though the user's locale was configured for non-English, the text associated with approving the expense authorization displayed in English.
Expense >> Manage/Approve Expense Reports
Defect 1608374: Though the user's locale was configured for non-English, the text associated with approving the expense report displayed in English.
Time >> Manage/Approve Timesheets
Defect 1608367: Though the user's locale was configured for non-English, the text associated with approving timesheets displayed in English.
Time >> Timesheet
Defect 1603305: When Include Previous Day(s) Overtime Hours was selected in Timesheet Class settings, the setting was not properly applied during validation, so errors and warnings failed to display.
Defect 1608362: Though the user's locale was configured for non-English, the text associated with signing the timesheet displayed in English.
Defect 1612488: When users who did not have an employee record in Time & Expense opened the Timesheet application, they experienced a system error instead of receiving an error message.
Defect 1622352: SQL query response time was accelerated to improve performance in the Timesheet and Manage/Approve Timesheets applications.
Defect 1626711: The Timesheet lookup for work assignments should have displayed only work assignments associated with Services.
Defect 1630395: A performance issue occurred with the Group Cache charge lookup/manual entry if the employee was assigned to a large number of charge restrictions (around 90,000 or greater).
Defect 1631322: When you used an account that did not apply toward Overtime hours, those hours also did not count as regular hours. Thus, when you tried to sign the timesheet, you received an error message indicating that the timesheet did not contain the minimum number of regular hours.
Time >> Timesheet Classes
Defect 1646032: When you configured the Validation field as Error or Warning for both Weekly Overtime and Daily Overtime, the validation setting for Weekly Overtime reverted to None after the new timesheet class was created.
BnP PSR Trending Analysis Report in Costpoint Business Intelligence
An error may occur if you generate the BnP PSR Trending Analysis report because of an Oracle compatibility issue.
© 2022 Deltek