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 PATCH3818.

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 - 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 in 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 PATCH3819.

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 PATCH3819.

401(k) Annual Compensation Limit

The IRS increased the 401(K) compensation limit from $285,000 in 2020 to $290,000 in 2021. This Costpoint release updates the Manage Federal Taxes screen to support this new limit with an effective date of 01/01/2021.

Attention: For more information, refer to the following:

• https://www.irs.gov/pub/irs-drop/n-20-79.pdf

• https://www.irs.gov/retirement-plans/plan-participant-employee/retirement-topics-401k-and-profit-sharing-plan-contribution-limits

Note: This enhancement requires PATCH3816.

Safe Harbor Affordability Percentage

The affordability of employer-sponsored health coverage increases to 9.83% of an employee's household income for the 2021 plan year.

Attention: For more information, refer to the following: https://www.irs.gov/pub/irs-drop/rp-20-36.pdf.

Note: This enhancement requires PATCH3816.

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.

Oregon

The SUTA limit for 2021 is $43,800.

Utah

The SUTA limit for 2021 is $38,900.

Note: These enhancements require the following:

• PATCH3816

• PATCH3818

• PATCH3819

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 PATCH3818.

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.

Iowa 2021 Tax Table Updates

The following are the 2021 tax withholding updates for Iowa:

• The annual tax bracket thresholds were adjusted.

• The standard deduction increased as follows:

• For employees who claim one or zero allowances, the standard deduction increased from $1,880 a year to $2,130 a year.

• For employees who claim more than one allowance, the standard deduction increased from $4,630 a year to $5,240 a year.

Chart for Step 3

This Costpoint release adds tax table records with an effective date of 01/01/2021 to support the new Iowa state tax withholding standard deduction and tax tables.

Attention: For more information, refer to the Iowa Individual Income Tax Withholding Formula Effective January 1, 2021: https://tax.iowa.gov/sites/default/files/2020-11/IA%20Withholding%20Formula%20and%20Instructions%20TY2021.pdf.

Note: This enhancement requires PATCH3816.

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 PATCH3819.

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 PATCH3819.

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.

Defect 1387531: 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 1387821: If you are using Costpoint with an MS SQL database, you encountered an error when you imported vendor employee information that contains certification details for existing vendor employees. As a workaround, remove the certification details from the input file and manually update the vendor employee certification details on the Manage Vendors or Manage Vendor Employees screen.

Defect 1390741: 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 1387290: If an application was assigned read-only access in one group but full access in another group, the Identify Segregation of Duties Report did not pick up the conflict.

Defect 1351825: The User-Defined Info subtask became disabled after you approved a prospective customer. As a workaround, you can edit the customer's user-defined information on the Manage Customers screen.

Defect 1351828: The User-Defined Info subtask became disabled after you approved a prospective vendor. As a workaround, you can edit the vendor's user-defined information on the Manage Vendors screen.

Defect 1393153: 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 1398980: A fatal error occurred during a file upload when the Sharepoint base URL and the CMI site name started with the same letters.

Defect 1387499: 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 1397293: 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 1387325: You encountered a performance issue when doing an inventory reconciliation job.

Defect 1389809: 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 1393846: 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 1395283: 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 two-way match on Dollars, and the PO line was open.

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

Defect 1366298: The label of the check box should be changed from “Update Vendor Address with Mailing Address” to “Also update my accounts payable address.” If you edit any of the fields in the Mailing Address group box, the application should enable and select the Also update my accounts payable address check box. The screen should also display a message which indicates that the accounts payable address was updated.

Defect 1393299: The label of the check box on the Address/Phone tab should be changed from “Update Vendor Address with Mailing Address” to “Also update my accounts payable address.” If you edit any of the fields in the Mailing Address group box, the application should enable and select the Also update my accounts payable address check box. The screen should also display a message that the accounts payable address was updated.

Defect 1393349: A system error displayed when you saved changes on a timesheet that had recast and fringe lines.

Defect 1382681: 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 1397239: 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 enter data for the Create Manage Deferred Tax Payment Records toolkit.

Defect 1401435: 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.

Defect 1258334: When you did not have a license for Costpoint Payroll, the estimated figure for the following was incorrect:

• Annual Average Number of Employees

• Total Hours Worked by All Employees Last Year

The Annual Average Number of Employees used the hire/termination dates to estimate employment instead of the number of employees paid in every pay period. The Total Hours Worked by All Employees Last Year did not exclude non-work time such as vacation, sick leave, and holidays. Temporary employees are also being excluded in the employment information.

 

This defect affects you if you are required to report OSHA 300A.

 

To address this issue, Costpoint applies the following updates to the OSHA 300A - Employment Information:

• A Use Pay Periods check box was added as an option for the Annual Average Number of Employees. This option is only available and selected by default if you are licensed for Payroll.

• If you select the Use Pay Periods check box, then the annual average number of employees will be calculated by adding the number of employees paid in every pay period and dividing the sum by the number of pay periods.

• The annual average number of employees will be calculated depending on the hire/term date if you are not licensed for Payroll or if the Use Pay Periods check box is clear.

• The total hours worked will be based from the pay type hours in employee earnings if you are licensed for Payroll.

• The total hours worked will be based from the charged hours in posted timesheets if you are not licensed for Payroll.

• All employees will be considered in the annual average number of employees and total hours worked. Temporary employees were previously excluded.

• Leave hours and non-work time will be excluded from the total hours worked. These hours were previously included.

Defect 1394655: Duplicate records in the EPROJ_LAB_CAT_RT_SC table caused the refresh to fail.

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

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

Defect 1384194: Project Generic Staff revenue did not import into Organization Budgets.

Defect 1393078: Labor Utilization tagged multiple accounts as the default account.

Defect 1368203: The application did not include Fiscal Years for New Business Budgets.

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

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

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

Defect 1393086: When you ran this application, the process took too long to complete or never finished.

Defect 1354331: A system error occurred when you tried to view the Project Cost Detail subtask for a fiscal year with cost pool numbers having more than four digits.

Defect 1397222: A performance issue occurred due to COMPANY_ID missing in several SQL statements.

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

Defect 1391153: 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 1400773: A critical system error occurred when you tried to create invoices using an MSS database.

Defect 1349922: 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 1385103: The first page of the summary report displayed only the current hours, whereas the detail report displayed the correct cumulative hours.

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

Defect 1398589: Employee IDs failed to update during import.

Defect 1399791: Because Employee Preference records did not exist for some employees, clients were forced to create them manually.

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

Defect 1389306: The Change Timesheet Status workflow removed tasks for timesheets where you did not change their status.

Defect 1392411: When you filtered a search in Charge Lookup, you received an error message after you drilled down to a charge branch.

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