Colorado State Filing Status

The 2020 Form W-4, Employee’s Withholding Certificate, was revamped to reflect the elimination of withholding allowances under the tax code overhaul. The new form relies on dollar-amount adjustments reported by employees to calculate income tax withholding.

Revisions to the federal form created a wave of changes in states that used the federal withholding certificate for state income tax withholding purposes and states that used allowances in withholding formulas.

Colorado was among the states that did not develop state withholding certificates and continued to use federal Form W-4 for state withholding. Head of household is a newly added filing status in the federal 2020 Form W-4, and before this release, Colorado did have the Head of Household filing status in Costpoint. This release adds the Head of Household filing status for Colorado in Costpoint for any employee who selected this filing status in the 2020 Form W-4.

Note: Colorado has a flat income tax rate of 4.63% regardless of filing status.

Costpoint PATCH3790 adds the Head of Household filing status records for Colorado on the following screens:

• Manage State Tax Withholding Adjustments

• Manage State Standard Deductions

• Manage State Tax Tables

The patch also applies the following updates to the State Filing Status (STATE_FILING_STATUS) table:

• The new HEAD OF HOUSEHOLD filing status was added.

• The descriptions of MARRIED and SINGLE OR MARRIED filing statuses were updated.

Idaho Income Tax Withholding

The Idaho State Tax Commission released the 2020 withholding methods with the following updates to the highest tax brackets:

• For married individuals, the highest tax bracket now starts at the annual income of $48,320, up from $47,508.

• For other individuals, the highest tax bracket now starts at the annual income of $24,160, up from $23,754.

This release updates the income tax bracket thresholds on the Manage State Tax Tables screen, effective 01/01/2020, to reflect the state tax changes. In addition, the effective date of all Idaho tax tables on the following screens will be updated to 01/01/2020:

• Manage State Taxes

• Manage State Standard Deductions

• Manage State Tax Withholding Adjustments

New Jersey SUTA Electronic Filing

New Jersey’s Department of Labor and Workforce Development phased out all types of magnetic media and replaced them with the Employer Report of Wages Paid (WR-30) form. All employers must file their quarterly wage reporting information (Form WR-30) electronically either online via the New Jersey Payroll Taxes and Wage Withholding-Filing, Payment, and Reporting Service or by Secure File Transfer Protocol (SFTP).

The most recent file layout for New Jersey SUTA electronic filing added the Record Terminus Character field in position 160 of both M and B records. In addition to this change, amended files should also report X in position 159 of the M record.

The following tables show the updated file layouts for M and B Records in the fixed length file format.

Fixed Length File Format

M Record

Record Location	Field Name	Field Length	Type	Description & Remarks
1	Record ID	1	A/N	Always "M"
2	FEIN	12	N	Federal Employer Identification Number
14	Filler	2	A/N	Spaces
16	Employer Name	36	A/N	From Authorization Letter
52	Street Address	35	A/N
87	City	20	A/N
107	State	5	A/N
112	Zip Code	9	A/N	Left justified, followed by spaces if less than 9 numbers
121	Quarter & Year or Report	2	N	Quarter number 1,2,3,4, then last digit of filing tax year
123	Number of Employees Reported	6	N	Right justified, "0" zero fill, must equal the number of employees "B" record lists for this employer
129	Total Wages paid this Quarter	14	N	Right justified, "0" zero fill, dollars & cents no decimal
143	FEIN	9	N	Federal Employer Identification Number
152	Magnetic Authorization Number	4	N	From Authorization Letter
156	Filler	4	A/N	Spaces
159				If “Amended,” enter “X” in position 159.
160	Record Terminus Character	1	A/N

B Record

Location	Field Name	Field Length	Type	Description & Remarks
1	Record ID	1	A/N	Always "B"
2	Employee SSN	9	N	9 numeric characters
11	Employee Name	30	A/N	Last Name, First Name, Middle Initial, no punctuation
41	Employee Wages Paid this Quarter	12	N	Right justified, "0" zero fill, dollars & cents no decimal
53	Employee Base Weeks	2	N	Right justified, "0" zero fill, range 00-14
55	Filler	105	A/N	Spaces
160	Record Terminus Character	1	A/N	Record Terminus Character (End of record) Content: “#”

Texas SUTA Electronic Filing

This Costpoint release updates the ICESA file format generated for the State of Texas for compliance with state requirements. The following fields in the corresponding records will now be blank in the report:

• Record A

• Position 220: Allocation List Indicator

• Position 221-229: Service Agent ID

• Position 230-242: Total Remittance Amount

• Record B

• Position 15-22: Computer

• Position 23-24: Internal Label

• Position 26-27: Density

• Position 28-30: Recording Code (EBCDIC or ASCII Character Set)

• Position 31-32: Number of Tracks

• Position 33-34: Blocking Factor

• Position 147-190: Organization Name

• Position 191-225: Street Address

• Position 226-245: City

• Position 246-247: State

• Position 253-257: Zip Code

• Position 258-262: Zip Code Extension

• Record T

• Position 186-198: Allocation Amount

This regulatory update requires Costpoint PATCH3786.

Application Updates

Manage SUTA Tax File Data (PRMSMM)

The screen contains the following new field:

Field	Description
NAICS Code	Enter the 6-digit North American Industry Classification System code that best classifies your company.

Fields and validations that are no longer applicable for Texas were also removed from the Manage SUTA Tax File Data screen.

Create Quarterly SUTA Tax File (PRPSMM)

The Create Quarterly SUTA Tax File screen now generates a SUTA tax file for Texas in the updated ICESA file format required by the state.

This release also applies the following changes for Texas:

• The values in the following fields were updated:

• Record E Position 182-187 NAICS Code field reports the value entered in the NAICS Code field on the Manage SUTA Tax File Data screen.

• Record T Position 248-250 County Code field now reports the value entered in the Industry/County Code/Location Code/Branch field on the Manage SUTA Tax File Data screen.

• Record T Position 251-257 Outside County Employees now reports the value entered in the Remitter Number/Employee Outside County field on the Manage SUTA Tax File Data screen.

• The application no longer displays the message: "Warning: This file should be named 'TWCWAGES' before submitting to the government agency. Continue?"

• The application now provides validations on fields that are related to the Configure Company Information screen.

• The Computer Manufacturer field is now disabled.

Print Data Dictionary Report (SYRDD)

The report now provides information for the NAICS Code column on the State SUTA Reporting database table.

The following applications have been enhanced to process more efficiently and decrease their runtime during simultaneous or batch processing. Deltek recommends that you install the Costpoint 7.1.8 MR in a test environment and test the applications before deploying the MR to production.

• Create Unbilled Analysis Report Tables (BLPUNBIL)

• Compute Burden Costs (PJPALCST)

• Load Labor Rates (PJPLDRAT)

Defect 1311749: When you created a purchase order (PO) with a Transaction Currency different from the Functional Currency, entered a voucher for that PO and updated the exchange rate, and then entered lines for that voucher and updated the exchange rate again, the Ext Cost Amt and Ordered Unit Cost were not updated. As a workaround, delete existing voucher lines and re-enter them before updating the exchange rate.

Defect 1316415: When you cleared the Taxable check box of an existing purchase order (PO) voucher, the VAT Recovery Amt was not set to 0.

Defect 1313326: If you are using Costpoint with an MS SQL database, you encountered an error when you imported asset disposals using an input file with a table format.

Defect 1317015: When you ran the disposal process first before calculating the current period depreciation, Costpoint allowed you to post asset disposals.

Defect 1317742: In Manage User Suppression (SYMUSRSUP), employee details did not display correctly when new salary records were created in Manage Employee Information (LDMEINFO).

Defect 1307981: When you did not set up the connection to Cobra, and then you queried records on the screen, a system error occurred.

Defect 1224398: An error occurred when you attempted to import opportunities from GovWin IQ into multiple companies in Costpoint (that is, Current Account was selected in Import GovWin IQ Data).

Defect 1310959: The application updated all opportunities from GovWin IQ even if the selected Opportunity range option was One, Range, From Beginning, or To End.

Defect 1318471: When you imported a new opportunity to Costpoint from GovWin IQ, the GWIQ_CONTACTS_KEY value started with 2 instead of 1 even though the opportunity ID is unique to the company.

Defect 1313988: Extensibility result set metadata did not generate for the Word Add-In.

Defect 1316907: A system error occurred in Manage Expense Report when you edited the From or To date fields on the Purpose tab in Wizard Mode.

Defect 1331118: On the Manage Warehouses (INMWHSE) screen, you could not save the transaction if you had hyphens or dashes in your legacy location ID fields. This issue affects you if you use MR 7.1.6 or higher.

Defect 1200757: On the Manage Timesheets screen, some open subtasks did not save with a customized screen configuration for users or UI profiles. As a workaround, you can open the subtasks each time you viewed the application screen. 

Defect 1319618: The Claimed Expenses form was missing in the Manage Expense Report (EPMEXPRPT) and Manage/Approve Expense Reports (EPMEXPRPTAPPROVE) applications. As a workaround, you can use Wizard mode for these applications.

Defect 1313429: In Manage Standard Bills (BLMGBILL), a system error occurred when you opened the Detail subtask for an invoice while WFA Feature Test Mode is enabled. As a workaround, you can turn off WFA Feature Test Mode.

Defect 1314105: JSON-based web service returned a document in an incorrect format when the document contained double quotes in data. As a workaround, you can use XML-based web services.

Defect 1323436: After authentication with Office 365 failed, Costpoint was supposed to fetch a new authentication token and retry the same request. A first request with an expired token failed and threw an exception, while all subsequent requests were successful because they used the new valid token.

Defect 1327360: For WebLogic 12.2.1.3, the MR installers would incorrectly delete the bcprov-jdk16-1.45.jar file from C:\Oracle\Middleware12.2.1.3\oracle_common\modules\.

Defect 1317682: When you opened the Demand subtask, you received a critical system error.

Defect 1317685: When you accessed the application and performed a query, you encountered a critical system error.

Defect 1319317: MRP transfers were not consistent with the plan substitute part selection. As a workaround, use a substitute planning order other than the original part across projects.

Defect 1314693: When you entered the part you created, the QC inspection required and certificate of conformance required options were set to None instead of Yes or No.

Defect 1321368: When you entered a new line but left the sequence number blank and clicked Save, you encountered an error, instead of having Costpoint auto-assign the sequence number.

Defect 1316518: When you performed skipped data collection with an incomplete XML with a prior successful negative issue transaction and a last lot number assigned to the part definition, the process created a negative issue in Costpoint.

Defect 1322620: You encountered an issue where a reservation was not deleted even when the manufacturing order (MO) status was set to Closed or Completed.

Defect 1318241: When a purchase order (PO) receipt in Costpoint had multiple lot numbers and was sent to Manufacturing Execution System (MES), and then you tried to generate a quality control inspection in Costpoint from the same record, you encountered an error.

Defect 1271780: When you selected the Component 1 Data option, the application reported 2 counts for an employee that has been rehired within the same year based on the salary records on the Manage Employee Salary Information screen.

Defect 1301136: The EEO report displayed incorrect employee totals. For example, Component 1 and Component 2 values did not match.

Defect 1293791: When you used the user-defined file format to import employee data, the application displayed an error when it attempted to change fields that were not selected in the format. As a workaround, you can select a different file format in the preprocessor.

Defect 1323222: When you import employee data into Costpoint, the application should provide an option that allows you to append the country code to the state code for employee addresses.

As a workaround, you can remove the prefixed country code in the State/Province Code field on the Manage States and Provinces screen.

Defect 1324286: When you selected the Append Country Code to State Code for User Addresses using check box without selecting a Country Code Type option, the application process still successfully completed and saved. The screen should display an error in this scenario.

Defect 1306844: The matching portion did not display on the Total Compensation Statement when you used the Contribution Matching table.

Defect 1306396: The Create Retroactive Timesheet Adjustments process did not work correctly for fringe lines when you entered a wage determination retroactive record. The retroactive adjustment applied the employee hourly rate to the fringe lines instead of the corresponding fringe rate.

Defect 1328855: When you printed/processed twice using the same saved parameter ID, you encountered a fatal error.

Defect 716881: The application's auto-adjust calculation for regular timesheet transaction amount was incorrect. The auto-adjust calculation included L-type lines with zero amount and non-zero hours.

Defect 889892: If you imported a timesheet more than once from Deltek Time and Expense, and then used the auto-adjust functionality, Costpoint applies incorrect Transaction Amount (TRN_LAB_AMT) values after the second import. In this scenario, the Labor Cost Amount (LAB_CST_AMT) values are correct. 

As a workaround, you can perform the following:

• If you have not posted the timesheets, you can delete all the timesheets and reimport them as one batch.

• If you have posted the timesheets, you can reverse all the timesheets and reimport them as one batch.

Defect 1319534: The quarterly SUTA file did not include employee records that had an effective date after the quarter start date. This issue occurred whether the employee had 1 or 2 Salary Information records.

Defect 1322257: When you queried a saved parameter, the screen enabled the Month 1–3 fields in the Employee Count group box even if you selected System as the Employee Count Method on the Manage SUTA Tax File Data screen.

As a workaround, complete the following steps:

1. Query a saved parameter.

2. Enter another SUTA state.

3. Re-enter the correct SUTA state to refresh the screen.

Defect 1205744: The application cleared the Federal Filing Status field when an error occurred upon recalculation.

Defect 1319160: A system error occurred when you used the Recalculate function on a record that did not have an assigned check number.

As a workaround, save the record before you use the Recalculate function.

Defect 1319558: This update corrects the posting of payroll so that union contributions do not post to both the employee's home organization and the balance sheet level of the employee's home organization.

Defect 1323029: After you printed paychecks, the check number did not display on the Manage Payroll Records screen.

Defect 1316060: The application did not sort deductions based on deduction codes.

Defect 1321581: After you printed payment advices, the advice number did not display on the Manage Payroll Records screen.

Defect 1245027: CER Actual Burden amounts were not updating for the prior year because the prior year was not closed yet.

Defect 1305457: You encountered a system error during the refresh process due to the last period in the fiscal year being greater than the current fiscal year.

Defect 1312360: As an administrator, you could not modify a new business budget that you did not own.

Defect 1309338: The system used subperiod-based function instead of period-based function when generating Org Reports.

Defect 1298388: The system was not computing Forward Rates as expected.

Defect 1317239: The dynamic columns were not reinitializing when you changed the fiscal year. This defect also affected another application.

 

Affected Application	Defect Number
Profit and Loss by Account (COP2, BOP2, POP2)	1317242

Defect 1293983: Report data was missing "Unmapped" information, which made it inconsistent with other reports.

Defect 1314689: PLC rates for a project were calculated on the PC level instead of the PEC/PVC level.

Defect 1316683: The system was pulling an incorrect hourly rate for Generic Staff when the rate was zero.

Defect 1310632: Costpoint did not calculate the billable value for some foreign transactions on the Z_BLPUBILL_RPT table.

Defect 1328235: A system error occurred when you ran this application using Billable Value on Unbilled Transactions.

Defect 1306991: When you ran Post Milestone Percent Complete Bills in batch mode through a job server and there was nothing to post (no records meet the selection criteria), Costpoint sent an email notification indicating a failed job. As a workaround, you can manually input each project record in the application, and then process each record in the job server.

Defect 1307928: When setting up a multi-job allocation with Allocation Method of Cost Incurred or Hours Incurred, Costpoint did not throw an error when you entered an invalid account (the account is not in the project account group).

Defect 1301375: The application created allocations for all IWOs, including those with no transactions and cost. This occurred when you ran the application for a range of projects that include at least one IWO project with cost. As a workaround, you can manually delete rows with zero amount on the Manage IWO Allocations screen.

Defect 1306147: You were unable to create an IWO allocation for an IWO project with different invoice dates. The Create IWO Allocations process did not complete and gave out an error. As a workaround, you can add a default rate group and rate date in Create IWO Allocations for the IWO project.

Defect 1314726: A system error occurred during IWO journal posting when the tax rate for the sales tax code used by the sending project was zero. As a workaround, set the tax rate for the tax code to any value other than zero on the Manage Sales or Value Added Taxes screen.

Defect 1296819: When you cloned a lower-level project with the Project Work Force Required check box selected but the higher-level project had this check box cleared, the check box on the newly created record had the higher-level project's value instead of the original record cloned.

Defect 1319270: Importing Employee History resulted in an "Invalid Timesheet Schedule" error when the user had yet to create the timesheet.

Defect 1322816: If a charge tree or branch that was set as restricted had no groups assigned to it, the tree or branch could be visible to all users in the Group Cache Lookup.

Defect 1322669: After a user's security role was changed, the user was removed from the "Everyone" user group.

Defect 1316728: When you navigated to the Clear Expense Authorizations screen using Smartphone Mode, an error occurred.

Defect 1317031: An import error indicated that the field displaying the name of the renter contained too many characters.

Defect 1310679: Advance statuses altered after export (at which point they had a status of Processed). Because of this error, advances were exported more than one time.

Defect 1316245: When you selected a UDT02 charge, an error occurred.