2020 US Virgin Islands FUTA Credit Reduction

For 2020, the U.S. Virgin Islands (USVI) is the only credit reduction state. The credit reduction rate is 0.03 (3.0%).

This Costpoint release adds a record on the FUTA Credit Reduction States table of the Manage Federal Taxes screen for Virgin Islands.

Attention: For more information, refer to the Schedule A (Form 940) for 2020: https://www.irs.gov/pub/irs-pdf/f940sa.pdf.

Note: This enhancement requires patch dbc_800_10420.

2021 W-4 Deductions Worksheet (Final)

The Internal Revenue Service (IRS) supplied the final version of the 2021 W-4 and introduced changes to Step 4(b)–Deductions Worksheet.

2021 Form W-4

This Costpoint release updates the following screens to comply with the final version of the worksheet:

• Costpoint Employee Self Service (ESS) Federal Withholding screen - Multiple Jobs/Deductions Worksheet tab

• Costpoint Employee Self Service (ESS) Life Events/New Hires screen - Federal Withholding - Deductions Worksheet tab

Attention: The Deductions Worksheet was updated due to the enactment of the 2021 Consolidated Appropriations Act on December 27, 2020. Line 1 of the Deductions Worksheet should now indicate “medical expenses in excess of 7.5% of your income” instead of “medical expenses in excess of 10% of your income,” which was indicated on the previous 2021 Form W-4. This updated text will be reflected in the Deductions Worksheet of Costpoint ESS applications in future releases.

For more information about the 2021 Consolidated Appropriations Act, refer to https://aboutbtax.com/UJc.

Note: This enhancement requires patch dbc_800_10429.

Federal Tax Updates

The following are updates to federal taxes for 2021.

Percentage Method Tables

The percentage method tables have been updated for 2021. This Costpoint release adds 2021 tax tables on the Manage Federal Tax Tables screen to support the tax update.

Attention: For more information, refer to the Federal Income Tax Withholding Methods: https://www.irs.gov/pub/irs-pdf/p15t.pdf.

Note: This enhancement requires patch dbc_800_10429.

2021 SUTA Wage Base

This Costpoint release adds tax table records effective 01/01/2021 for states where the unemployment-taxable wage base has been updated for tax year 2021.

Alaska

The SUTA limit for 2021 is $43,600.

Hawaii

The SUTA limit for 2021 is $47,400.

Illinois

The SUTA limit for 2021 is $12,960.

Idaho

The SUTA limit for 2021 is $43,000.

Kentucky

The SUTA limit for 2021 is $11,100.

New Mexico

The SUTA limit for 2021 is $27,000.

North Carolina

The SUTA limit for 2021 is $26,000.

Note: These enhancements require the following patches:

• dbc_800_10420

• dbc_800_10429

Arkansas 2021 Tax Table Updates

The state of Arkansas Department of Finance has released their withholding formula with an effective date of January 1, 2021.

• The threshold for adjusting the net taxable income at the $50 range (midrange of 100) increased from 87,001 to 88,001.

• The value of a state withholding allowance increased from $26 to $29.

• The tax rates used in the formula decreased to zero to 5.9%, down from zero to 6.6%, and the income tax brackets were adjusted.

This Costpoint release adds tax tables with an effective date of 01/01/2021 for Arkansas and updates the Compute Payroll screen to support the new Arkansas state withholding allowance.

Attention: For more information, refer to the Withholding Tax Formula Method: https://www.dfa.arkansas.gov/images/uploads/incomeTaxOffice/whformula.pdf.

Note: This enhancement requires patch dbc_800_10420.

Hawaii 2020 W-2 Electronic Filing

If you are an employer or payroll provider who is required by the federal government to electronically file Form W-2, Wage and Tax Statements, or Form W-2C during the year, you must also electronically transmit these informational returns to the Hawaii Department of Taxation. For Hawaii employees and withholding, you must use the Social Security Administration’s EFW2 format.

This Costpoint release updates the Create State W-2 File screen to support the EFW2 file for Hawaii W-2 electronic reporting.

Attention: For more information, refer to the EFW2 and EFW2C Format Forms W-2 and W-2C: https://files.hawaii.gov/tax/eservices/ebiz/20pubef10-HI_EFW2SpecsGuide-v1rev102020.pdf.

Missouri 2021 Tax Table Updates

The following are the 2021 tax withholding updates for Missouri:

• The standard deduction amounts have increased.

• The tax bracket thresholds used in the formula were adjusted.

Attention: For more information, refer to the State of Missouri Employer’s Tax Guide: https://dor.mo.gov/forms/4282_2021.pdf.

Note: This enhancement requires patch dbc_800_10429.

New York State/City of Yonkers Updates

The following are the 2021 tax withholding updates for New York:

• The annual withholding tax tables for Married and Single were updated.

• The amount of the adjustment for the difference between federal and New York State withholding allowances increased from $3,200 to $3,300.

Single

Married

Attention: For more information, refer to the following:

• New York State: https://www.tax.ny.gov/pdf/publications/withholding/nys50_t_nys_121.pdf

• City of Yonkers: https://www.tax.ny.gov/pdf/publications/withholding/nys50_t_y_121.pdf

Note: This enhancement requires patch dbc_800_10429.

Puerto Rico 2020 SUTA Electronic Filing

Costpoint was updated to support electronic filing for Puerto Rico SUTA reporting using the following format:

This release applies updates to the Manage SUTA Tax File Data screen and the Create Quarterly SUTA Tax File screen to support the requirements of Puerto Rico.

Attention: For more information, refer to https://patronos.trabajo.pr.gov/patronos/Help/Help_EN/default.htm?turl=aboutus.htm.

The MR Installer now provides a check box option to have your SA/SYSTEM user and password combination used for all connections. When the check box is not selected, you will still be prompted to enter your SA/SYSTEM user and password for each different connection. If the check box is selected, the entered SA/SYSTEM user and password will be used for all connections. If a connection fails, you will be prompted to enter the proper SA/SYSTEM user and password.

Defect 1387556: You encountered an error when you imported a purchase order (PO) voucher with a line that has a Taxable Code of U. This happened because Costpoint incorrectly calculated the Invoice Amount against the Tax Amount. As a workaround, use the Manage Purchase Order Vouchers screen to manually correct the discrepant amounts or to manually create PO vouchers with use tax.

Defect 1394638: The Running Balance fields were both labeled with the functional currency instead of only the lower Running Balance field having the functional currency label.

Defect 1394088: When you set the exchange rates for the journal entry, copied employee labor lines with multicurrency from an external source, and pasted them on the Employee Labor subtask, Costpoint incorrectly calculated the Functional Amount and caused a discrepancy on the journal entry balance.

As a workaround, click Save. After the error message displays, click the Trans Amt or Exchange Rate button in the Recalculation Method group box and click Save again.

Defect 1387862: User-defined labels were listed in alphabetical order instead of being listed according to their assigned sequence number.

Defect 1397094: An incorrect characters error needed to be changed to a warning to allow you to perform a save in the Configuration Utility, without having to change passwords.

Defect 1384489: You could not start a workflow and you did not receive an error if the Contract Description approval entity field in the workflow email had characters beyond the 2,000 character limit. As a workaround, you can reduce the number of characters in the field.

Defect 1394202: You might have received the following error when you tried to paste data from Excel into various Costpoint applications that have Date columns: "Cannot paste data from Excel.Invalid date ‘DD/MM/YYYY.Row # Column X".

 

As a workaround, you can set the Excel date format to MM/DD/YYYY before pasting into the Costpoint application.

Defect 1399664: A fatal error occurred during a file upload when the Sharepoint base URL and the CMI site name started with the same letters.

Defect 1399662: The Exchange Rates subtask window, located in multiple applications, would snap back to its original position when you tried to move or drag it to a new position.

Defect 1387615: You might have received the following system error when you tried to export data via the Export Data to Deltek Time and Expense (LDPDTC) application: "System Error: Action initialization failed. Invalid action Id: µ".

As a workaround, you can turn off Extensibility and export again.

Defect 1390784: When you tried to implement an engineering change notice (ECN) with the same Item Parts but in a different company, you encountered an error exception report.

Defect 1397334: When you deleted a record with an impacted part and added it again, the system did not delete the manufacturing bills of material (MBOM) component.

Defect 1387559: You encountered a performance issue when doing an inventory reconciliation job.

Defect 1381413: The MRP process logic has been modified to take into account the new MRP settings for processing purchase orders (PO) before requisitions.

Defect 1392261: When you ran Import Purchase Requisitions, an error report file was generated even though the file did not exist in the Alternate File Location.

Defect 1396016: When you entered the RFQ ID and the Phone field was populated, the system truncated the phone number to 15 characters when using Web Integration Console (WIC).

Defect 1382864: When you used Web Service to create a Customer Repair Type manufacturing order (MO) which had a Manufacturing Execution System (MES) Customer Repair type of Routing, you encountered an error.

Defect 1386215: When you rejected all lines, the purchase order (PO) ID was not listed under Pending Buyer Action (by Purchase Order). Instead, it was listed under New Orders Rejected.

Defect 1396038: When the vouchered quantity exceeded the purchase order (PO) quantity, the calculated open amount displayed as zero. This happened under the following conditions: the PO was a 2-way match on Dollars, and the PO line was open.

Defect 1400847: A critical system error occurred when you attempted to save a record on the Manage Full-Time Equivalent Eligibility screen.

Defect 1395383: Congress passed legislation on March 18, the Families First Coronavirus Response Act (H.R. 6201), which created a federal paid sick leave requirement for coronavirus-related needs and expanded the Family and Medical Leave Act to include a paid leave component for employees caring for children whose schools or child care facilities were closed because of the virus outbreak.

The legislation mandates covered employers to provide paid leave for employees affected by the coronavirus if those employees are unable to work or telework. Those employees will receive 2 weeks (80 hours) of paid sick time at the employee’s full regular rate of pay, subject to dollar caps; this is reduced to two-thirds pay if the leave is due to caring for others (for example, a sick or quarantined family member or a child whose school is closed or whose childcare provider is unavailable due to the coronavirus).

To support the legislation, Costpoint must enable the Average Hourly Compensation Rate field on the Paid Family Leave subtask. The field should also be required. The Families First Coronavirus Response Act put a limit on the amount that can be paid to an employee; therefore, this field needs to be enabled for entry of the Average Hourly Compensation Rate in cases where the calculated amount (Average Weekly Wage divided by the Average Weekly Hours) would cause the employee to exceed the mandated dollar cap.

Defect 1395045: If an employee did not have an assigned withholding state on the Manage Employee Taxes screen, the Federal Withholding in Employee Self Service did not display.

Defect 1395006: A system error occurred when you selected the Changes Since last Download check box and then ran the export process for an MO record that has the following characteristics:

• Has more than 30 characters in the MO Routing Lines description

• Does not exist in the LINK27 table

As a workaround, clear the Changes Since Last Download check box or update the length of the description in the MO Routing Lines to 30 characters for the affected records.

Defect 1397871: The addition of an "S-" prefix and the insertion of a backslash caused records with 20 characters to be truncated when the application writes to the EMPL_GROUP file.

Defect 1400452: When an expense-only leave type has the same expense account assigned to the main currency and all other currencies on the Additional Transaction Currencies subtask, the application displays the following incorrect error message: "Leave balance below minimum limit". This issue occurred when the Multicurrency functionality was enabled.

 

As a workaround, increase the floor of the leave types.

Defect 1395983: If you ran the Post Labor and the Post Leave process at the same time, Costpoint did not update employee leave balances.

As a workaround, wait until the next Post Leave and ensure not to run the process at the same time as Post Labor.

Defect 1402376: The following Box 14 descriptions should only print if the corresponding amount is not equal to 0.00:

• Sick leave subject to $511/day limit

• Sick leave subject to $200/day limit

• Emergency family leave wage

Defect 1402526: The application should not generate Box 14 records if the corresponding amount is not equal to 0.00.

Defect 1402547: When you save a Manage W-2s screen record, the application should only automatically populate the description fields on the COVID 19 Box 14 subtask if the corresponding amount is not 0.00.

Defect 1397240: When you ran the Create payroll records to repay deferred Social Security toolkit, the screen displayed the following error: This Range Option's Starting and Ending value combination is invalid.” The error message indicates that you need to enter data for the Create Manage Deferred Tax Payment Records toolkit.

Defect 1401446: When you selected the Create payroll records to repay deferred Social Security toolkit and then selected the Range or From Beginning option as the range type for Employees, the application did not select valid employees for processing.

This issue does not occur when you use the Create Manage Deferred Tax Payment Records toolkit.

As a workaround, select the Non-Contiguous Range check box and use the Employee Non-Contiguous Range subtask to specify any selection parameters based on a range type of Range or From Beginning. All range types work when you use the Employee Non-Contiguous Range subtask.

Defect 1394657: Duplicate records on the EPROJ_LAB_CAT_RT_SC table caused the refresh to fail.

Defect 1394763: A SQL timeout error occurred when you refreshed SRC00_PROCESS_BUILD_EREPORT_PROJ_TREND.

Defect 1397259: The rate calculation did not include prior allocations for service centers.

Defect 1402186: When you created a budget for 2021, you encountered an "Invalid object name" system error.

Defect 1393080: Labor Utilization tagged multiple accounts as default.

Defect 1396184: Trailing spaces caused duplicate lines for actuals in Oracle.

Defect 1398711: When you accessed a working EAC, Revenue Analysis failed initially to display values from the previous EAC version.

Defect 1399715: After you saved, the period cells for the budget were disabled.

Defect 1401543: When you reassigned hours from a selected resource to a new resource, the new resource was not added to the "Selected Resource" list.

Defect 1385579: There was a rounding issue in rate when you calculated bills.

Defect 1380228: The process got stuck at 55% and did not finish.

Defect 1394116: The application displayed duplicate costs. This happened when one user printed or previewed the report and the system stopped responding (causing the application to get locked), and then another user accessed the same report parameter while the browser or the system was still up for the first user.

As a workaround, you can perform these steps:

1. On the Print Project Status Report screen, select the Inactive Projects check box to include inactive projects in the report.

2. Open the Clear Users screen, and delete the row where Application Locked = PJRPROJ.

Defect 1378616: The following subtasks were enabled even though the invoice details were provided via the Supplier Portal or created based on timesheets:

• Vendor Labor Details

• Vendor Expense Reports

• Expense Report Details

• Expense Transaction Details

 

Part of the fix for this bug includes the following changes:

• Vendor Labor subtask: This is no longer a read-only subtask. The following updates have been made to allow users to add missing information when the invoice is created by the supplier through the Supplier Portal:

• For an existing row that has Sales Tax/VAT on Labor set to N, the GLC and PLC fields are now enabled and can be edited. Note, however, that the Copy and Delete functions are not allowed even though editing of tax information is conditionally allowed. Costpoint displays a message when you click any of these buttons and save the record.

• You can now add a new row on this subtask to add tax information. New rows will always have Sales Tax/VAT on Labor set to Y and more fields that are enabled. 

• Rows with Sales Tax/VAT on Labor set to Y can be edited and deleted.

• Vendor Expense Reports, Expense Report Details, and Expense Transaction Details subtasks: These subtasks are no longer read-only subtasks and have been modified to allow approvers to modify tax information on an expense report submitted by the supplier.

  • The Sales/VAT Tax Amount and VAT Recovery Amount fields are now enabled and editable on all three subtasks.

  • The New, Copy, and Delete functions are not allowed even though editing of tax amount fields is allowed. Costpoint displays a message when you click any of these buttons and save the record.

Defect 1375732: Rounding issues occurred when you ran this application.

Defect 1388373: If you have an existing saved parameter in this application and you upgraded to Costpoint 8.0, an error occurred when you ran this screen. There were some new fields added that caused the system to enter a NULL value in a field that should not have this value.

 

As a workaround, you can run the following script:

UPDATE FROM CPTRAN_97576_IEACOR.VCHR_HDR

SET SUBC_TS_IND = 1

WHERE PO_ID IN (SELECT PO_ID

FROM CPTRAN_97576_IEACOR.WA_HDR WHERE WA_ID = 'WA-000012');

Defect 1356127: On the Charges subtask, the values in the following fields were incorrect after you executed Create Subcontractor Invoices:

• Trans Remaining PO Line Amount

• Func Remaining PO Line Amount

• Remaining PO Line Quantity

Defect 1385958: The first page of the summary report displayed only the current hours, whereas the detail report displayed the correct cumulative hours.

Defect 1393269: Due to related performance issues, error message texts are now limited to 4,000 characters.

Defect 1398590: Employee IDs failed to update during import.

Defect 1393250: Due to related performance issues, error message texts are now limited to 4,000 characters.

Defect 1402427: UDTs embedded under Charge Favorites failed to load when selected from the Favorites lookup on Mobile Time. Instead, default charges loaded.

Defect 1390233: The Employee Notifications subtask in Time Controls » Manage Events did not include all the timesheet classes, so members of those classes did not receive workflow notifications (for example, notice of a daily floor check failure).