2022 SUTA Wage Base

This Costpoint release adds tax table records effective January 1, 2022 for states where the unemployment-taxable wage base has been updated for tax year 2022.

Note: These enhancements require the following patches:

• dbc_800_10812

• dbc_800_10798

• dbc_800_10826

Delaware

The SUTA Limit for 2022 decreases from $16,500 to $14,500.

Kentucky

The SUTA limit for 2022 increases from $10,800 to $11,100.

North Carolina

The SUTA limit for 2022 increases from $26,000 to $28,000.

Virgin Islands

The SUTA limit wage base decreases from $32,500 to $30,800.

Wyoming

The SUTA limit wage base increases from $27,300 to $27,700.

Guam 2022 Tax Table Update

The tax tables of Guam were updated based on the 2022 federal income tax withholding methods.

Attention: For more information, refer to: https://www.irs.gov/pub/irs-pdf/p15t.pdf.

Note: This enhancement requires patch dbc_800_10826.

Louisiana 2022 Tax Table Updates

The Louisiana Department of Revenue updated their state tax withholding rules effective January 1, 2022. The withholding formulas for the following statuses have been updated:

• Single or Married Taxpayers Claiming 0 or 1 Personal Exemption

• Married Taxpayers Claiming 2 Personal Exemptions

To support the state updates, this release applies changes to the following screens:

• Manage State Tax Withholding Adjustments

• Manage State Tax Tables

• Manage State Taxes

• Manage State Standard Deductions

Attention: For more information, refer to: https://revenue.louisiana.gov/LawsPolicies/Emergency%20Rule_LAC%2061.I.1501_Withholding%20Tables.pdf.

Note: This enhancement requires patch dbc_800_10798.

Maryland 2022 Tax Table Updates

The Maryland Treasury Department updated their state tax withholding rules effective January 1, 2022. The following are the updates:

• Tax rates for Washington county changed from 3.20% to 3.00%.

• Tax rates for Saint Mary's county changed from 3.17% to 3.10%.

• All other counties remained the same.

To support the state updates, this release applies changes to the following screens:

• Manage State Tax Withholding Adjustments

• Manage State Tax Tables

• Manage State Taxes

• Manage State Standard Deductions

Attention: For more information, refer to: https://www.marylandtaxes.gov/forms/Tax_Publications/Tax_Facts/Withholding_Tax_Facts/Withholding_Tax_Facts_2022.pdf#:~:text=For%202022%2c%20we%20will%20use%20eleven%20brackets:%202.25%25%2c%2cof%20an%20exemption%20when%20using%20the%20withholding%20tables.

Note: This enhancement requires patch dbc_800_10803.

Minnesota 2022 Tax Table Updates

The Minnesota Department of Revenue updated their state tax withholding rules effective January 1, 2022. The following are the updates:

• The value of a state allowance increased from $4,350 to $4,450.

• The formula’s tax brackets were adjusted.

• Tax rates continue to range from 5.35% to 9.85%.

• The department also released a 2022 version of Form W-4MN, Minnesota Withholding Allowance/Exemption Certificate.

To support the state updates, this release applies changes to the following screens:

• Manage State Tax Withholding Adjustments

• Manage State Tax Tables

• Manage State Taxes

• Manage State Standard Deductions

Attention: For more information, refer to: https://www.revenue.state.mn.us/sites/default/files/2022-02/wh_inst_22_0.pdf.

Note: This enhancement requires patch dbc_800_10803.

Mississippi 2022 Tax Table Updates

Mississippi’s state revenue department released the 2022 withholding formula. Compared to the 2021 formula, the number of tax brackets decreased to three from four, with rates of zero, 4%, and 5%. 

To support the state requirements, this release applies updates to the following screens: 

• Manage State Standard Deductions 

• Manage State Tax Withholding Adjustments 

• Manage State Tax Tables

• Manage State Taxes

Attention: For more information, refer to: https://www.dor.ms.gov/sites/default/files/Business/Computer%20Payroll%20Flowchart%2010-14-21.pdf. 

Note: This enhancement requires patch dbc_800_10812.

Oregon 2022 Tax Table Updates

The Oregon Department of Revenue announced the following updates to their state tax withholding rules effective January 1, 2022:

• 2022 withholding formulas increase the value of several formula parameters.

• The federal tax adjustment amount increased from $7,050 to $7,250 for an employee with annual wages up to $50,000.

• The federal tax adjustment phase-out amounts changed in 2022 for an employee with annual wages $50,000 or greater.

• The tax table changed for an employee with annual wages of up to $50,000.

• The tax table changed for an employee with annual wages of $50,000 or greater.

• The allowance amount increased from $213 to $219.

• The standard deduction amount increased from $2,350 to $2,420 for an employee filing “Single” with fewer than 3 allowances.

• The standard deduction amount increased from $4,700 to $4,840 for an employee filing “Single” with 3 or more allowances.

• The standard deduction amount increased from $4,700 to $4,840 for an employee filing “Married”.

Attention: For more information, refer to: https://www.oregon.gov/dor/forms/FormsPubs/withholding-tax-formulas_206-436_2021.pdf.

Note: This enhancement requires patch dbc_800_10803.

Virgin Islands 2022 Tax Table Update

The tax tables of the Virgin Islands were updated based on the 2022 federal income tax withholding methods.

Attention: For more information, refer to: https://www.irs.gov/pub/irs-pdf/p15t.pdf.  

Note: This enhancement requires patch dbc_800_10826.

The MR installer has been updated with the latest version of the jose4j.jar file (jose4j-0.7.9.jar).

MR installers also now include an option to temporarily stop the execution during installation and allow you to edit one or more database patch scripts before execution on your database. This feature is handy if you use Oracle partitioned tables or need to add storage clauses to database scripts. This feature eliminates the need to execute database scripts post MR installation to place objects in the correct Oracle tablespace or to recreate partitioned indexes. Therefore, it reduces the length of the maintenance window and application downtime during production upgrades.

As of MR 8.0.19, Deltek successfully completed the test transmissions of electronic 1094-C/1095-C files on the California FTB MEC FX Portal. Related Costpoint updates, which were released in MR 8.0.17, are now ready for use. You can now test electronic file transfers with FTB for California’s Minimum Essential Coverage (MEC) Information Reporting.

Attention: For more information, refer to: https://www.ftb.ca.gov/file/business/report-mec-info/technical-specifications.html.

Costpoint now provides the ability to generate manifest and data files that comply with the latest tax year 2021 schema for the UI transmission channel. This release applies the following updates for the Create 1094-C and 1095-C Electronic File screen to support the latest federal requirements:

• A new record with the software ID for tax year 2021 (Software ID: 21A0012967) and Costpoint contact information (same as 2020 data) was added to the system table S_SOFTWARE_ID.

• When you select the Federal option as the Government Agency, the application will use the following to generate manifest and data files for tax year 2021:

• Manifest file from tax year 2021 schema package

• Form data file from tax year 2021 schema package

• “2021” as the PaymentYr value

• “0” as the PriorYearDataInd value

• Software ID for 2021

• The year in the namespaces of both manifest and data files was updated from “ty20” to “ty21” for tax year 2021.

• Since the form data file cannot exceed 100MB, the submission will be split into two or more transmissions if the form data file is larger than 100 MB.

The District of Columbia enacted legislation that requires all District residents to have minimal essential health care coverage, or have a coverage exemption or pay a tax penalty for tax years ending on or after December 31, 2019. The requirements in the Individual Taxpayer Health Insurance Responsibility Requirement Amendment Act of 2018, effective October 30, 2018 (D.C. Law 22-168), were codified in a new Chapter 51 to Title 47 of the D.C. Official Code.

Insurance companies, businesses providing insurance to their employees, and other applicable entities and third-party service providers that provide minimum essential coverage are required to file returns consistent with D.C. Official Code § 47-5105 as well as other information required by Office of Tax and Revenue (OTR).

All filers are required to file the Health Care Information Returns electronically even if they file less than 250 information returns via the OTR web portal, MyTax.DC.gov.

Attention: For more information, refer to:

• Specifications for Electronically Filing DC Health Care Information Returns for Software Developers and Applicable Entities: https://otr.cfo.dc.gov/sites/default/files/dc/sites/otr/publication/attachments/TY2021%20DC%20Health%20Care%20Info%20Returns%20v2.0_0.pdf

• File format: https://otr.cfo.dc.gov/sites/default/files/dc/sites/otr/publication/attachments/Copy%20of%201094B%201095B%201094C%20and%201095C%202021%20Layouts%202.2.2022.xlsx

Note: These enhancements require patch dbc_800_10821.

 

Create 1094-C and 1095-C Electronic File (HBP1094C)

Costpoint adds the ability to create 1094-C and 1095-C electronic files for District of Columbia.

 

Print Data Dictionary Report (SYRDD)

The report now provides information for the new HB_ACA_DATA_DC database table, which stores the employee Record IDs from the generated District of Columbia file.

Import Master Data was updated as follows:

• The incidental rate was changed from 3.00 to 5.00 dollars. As part of this change, a new Incidental Amount column was added. For CONUS (S_SOURCE_CD  = ‘C’), the incidental amount will be 3.00 if the date is earlier than October 1, 2009, but if it is during or later than that date, the incidental amount will be 5.00

• A Meal Amount (MEAL_AMT) column was also added. The amount that displays in the column equals the difference between the Incidental Amount (INCIDENTAL_AMT) value and the Incidental Meals Amount (MEALS_INCIDENTAL_AMT) value.

For example, if the MEALS_INCIDENTAL_AMT column displays 45 and the INCIDENTAL_AMT column displays 3, the MEAL_AMT column displays 42.

Note that the above calculation is true for both CONUS and OCONUS, except that for OCONUS (S_SOURCE_CD = ‘O’ or ‘U’), the incidental amount is derived (INCIDENTAL_AMT) from the MEAL_INCIDENTAL_BREAKDOWN.INCIDENTAL_AMT (MIB) table.

Defect 1575527: If you use Costpoint with an MS SQL database, Costpoint set the values in the Amt Recvd column to 0 and deleted the values in the Bill Currency column when you clicked Save. This occurred when you entered an invoice that does not exist yet in Costpoint in the Cash Receipt Details table window.

Defect 1575444: When you updated general ledger beginning balances for multiple companies for the same fiscal year, Costpoint successfully updated the balances for the first company but displayed an error for the succeeding company. This occurred because the temporary database tables (Z tables) generated for the first company were not deleted when the update process was completed. As a workaround, manually delete the temporary tables.

Defect 1546381: When you manually replaced the employee ID in Billing Analyst, Subcontract Administrator, or Contract Administrator and saved the record without tabbing out of the field, Costpoint did not automatically replace the value in Billing Analyst Name, Subcontract Administrator Name, or Contract Administrator Name. The same issue happened when you used the Replace function for the employee ID fields; the name was not automatically updated.

As a workaround, you can clear the value in the employee ID field and tab out of the field before entering a new employee ID. Alternatively, you can use the field lookup so both the employee ID and name will be updated.

Defect 1552418: On the FAR Clauses/Provisions and Supplemental Regulations subtasks, when you added a new record and used lookup to select a FAR Number or Clause Number with a blank Effective Date, Costpoint inserted the selected row and filled the date with the most recent effective date.

 

As a workaround, manually remove or change the Effective Date value.

Defect 1580834: When you used the Mass Add process via the Project Initialization subtask of Manage Contracts, a system error was recorded in the log file but not displayed on the Manage Contracts screen.

Defect 1552420: On the FAR Clauses/Provisions and Supplemental Regulations subtasks, when you added a new record and used lookup to select a FAR Number or Clause Number with a blank Effective Date, Costpoint inserted the selected row and filled the date with the most recent effective date.

As a workaround, manually remove or change the Effective Date value.

Defect 1546382: When you cloned an OCI record and then deleted entries on the Opportunities, Projects, Employees, Subs/Vendors, or Documents subtask, whether in the original OCI record or the newly created OCI record(s), those entries were also deleted in the original and new OCI records.

Defect 1379677: When you made updates to the NDA and Teaming Agreement subtasks for a prospective vendor and tried to save the record, the following error message displayed: "Error(s) This row has been approved by <USER_ID> Table: VEND Operation: APPROVE." The same error displayed when adding new rows on the Address/Contact Info subtask and saving the record.

Defect 1490561: An error displayed when you entered a value with trailing spaces in the Business ID field (on the Business Affiliations subtask) and tabbed out of the field.

Defect 1579293: The "Column BUYER_ID not found in row set" system error occurred when you started the approval workflow for the Manage Purchase Order Vouchers application.

Defect 1600158: When you clicked Save in Manage Dashparts for a dashboard, an error occurred when you closed the dashboard. 

Defect 1579780: You could not change the company when IIS was configured to return the "x-content-type-options: nosniff" HTTP response header.

Defect 1586083: For Costpoint MES and SFT clients, the PMFG web service file location has changed slightly. Web service files are now split into three folders:

• C:\Deltek\Costpoint\80\cpupdates\wspmfg\MES

• C:\Deltek\Costpoint\80\cpupdates\wspmfg\SFT

• C:\Deltek\Costpoint\80\cpupdates\wspmfg\SFTgeneric

Please read DeltekCostpoint80MaintenanceReleaseInstallation.pdf for instructions on what and how to install.

Defect 1505675: The application has been tuned to optimize its performance.

Defect 1597597: When you opened the Full Requirements and Planned Requirements subtasks, the child table window (CTW) only loaded properly if either of them was selected first; the second subtask you selected loaded as blank. This issue persisted even after you cleared the cookies and browser cache.

Defect 1581049: When you ran Update Material Requirements Plan, Costpoint generated planned supply for phantom parts.

Defect 1585788: When you verified the value of the buyer's organization, Costpoint defaulted to the value from the requisitioner's organization.

Defect 1590865: When you cloned an original part and saved it, the part description overwrote the selling description and the Comments updated the long selling description.

Defect 1572852: When you ran Update Make Part Standard Cost, the Material Burden and Subcontractor Costs did not update from either Routing or Standard Cost.

Defect 1590611: When you ran inventory reconcile for reservations and planned reservations, you encountered a reservation error, which resulted in an incorrect net available quantity.

Defect 1600137: When you performed an over issue, the reserve quantity was reduced and did not match the requirements.

Defect 1583701: For unissued manufacturing orders (MO), when you changed the Make/Buy field, the changes loaded automatically based on the As Of Date (current), but the Stop Explosion check box was not selected.

Defect 1592822: When you updated the As of Date to the current date, the Operations were deleted from reworked orders.

Defect 1592826: When you zeroed out the Component Quantity in Manufacturing Execution System (MES), the Routing line components and requirements were zeroed out in Cosptoint, but the reservation remained the same.

Defect 1568555: When you imported a file, the purchase order (PO) line resources were not imported when the PO Header and Line information were not included in the input file.

Defect 1583335: When you imported a purchase order (PO) where the Taxability check box was selected on the PO line and the sales tax had a 100% recovery rate, the sales tax recovery amount was calculated incorrectly.

Defect 1581436: When you printed a purchase order (PO) activity using an Agency ID with more than eight (8) characters, you encountered a system error. This occurred even though the AGENCY_ID accepts up to 15 characters (in Manage Project User Flow).

Defect 1581817: The application has been modified to correct a Business Intelligence Reporting Tool (BIRT) error.

Defect 1581071: The application has been modified to correct a Business Intelligence Reporting Tool (BIRT) error.

Defect 1578231: Web Integration Console (WIC): When you sent an UPDATE command to change quantities in Manage Quality Control Inspections, the Recd Qty on the Serial/Lot subtask changed to zero and threw several errors.

Defect 1593455: When you used a release order receipt, an incorrect value of the the purchase order (PO) release number was loaded into the quality control inspection screens.

Defect 1567697: When you approved a sales order (SO) record, the header status of the record stayed in In-Approval when it should have been Approved.

Defect 1588867: When you added Header notes to a sales order (SO) input file, and then renamed and reimported it, the value in the SO changed when you queried the SO on the Manage Sales Orders screen.

Defect 1583752: There was no validation to prevent duplication of combinations of labor group/labor location, which caused a failure on the Import Employee Data screen.

Defect 1572252: If you imported data that did not include the City of Birth, the application changed the current location in Costpoint to blank. This issue occurred regardless of the data that you were updating.

Defect 1572255: When you selected Error as the Employee Class Code Validation Method on the Configure Labor Settings screen, the following issues occurred when you imported Employee Master data:

• The application did not display any errors when there was a mismatch between the class code and the Hourly/Salary or the Exempt/Non-Exempt fields.

• The employee record was updated with incorrect flags.

Defect 1582266: The application required logic updates to populate the Generic Code to Group Vendors (VEND_GRP_CD) column in the Vendor (VEND) table with the correct value.

Defect 1583755: A critical error occurred when a labor group/labor location combination was assigned to more than one compensation plan on the Manage Compensation Plan Defaults screen.

Defect 1543294: The following message displayed even if the Same Address as Employee check box was already selected when you opened the employee’s record: "Address fields will be overwritten with the Employee's address. Continue populating address fields?“ As a workaround, click OK on the message every time it displays.

Defect 1591704: When you corrected a record that had a duplicate Social Security Number, and you then saved your changes, the following error displayed: "A User ID must be entered when a Login ID is specified."

Defect 1550289: The wording on the FSA Worksheet for open enrollment required updates.

Defect 1579629: The year indicated on the Federal Withholding tab should be changed from 2020 to 2022.

Defect 1550291: The wording on the FSA Worksheet for open enrollment required updates.

Defect 1580371: The year indicated on the Federal Withholding tab should be changed from 2020 to 2022.

Defect 1579673: The leave balance in Deltek Time and Expense was not always correct when an employee had an adjustment and an accrual in the same leave period. This issue occurred when the adjustment and accrual were exported to Deltek Time and Expense in two different batch cycles.

Defect 1590482: If an employee took a leave during the same period of a leave payout, the application exported both the leave payout and time taken for the period. This issue caused a double deduction on the Leave subtask of Deltek Time and Expense.

Defect 1566017: When Costpoint generated a union cash fringe timesheet line, the application did not populate the following columns in the TS_LN table:

• FRINGE_CD

• PROJ_ABBRV_CD

• PROJ_ACCT_ABBRV_CD

Defect 1575357: After you posted timesheets, the posting report displayed two lines for an accrued salary account when the TRN_CRNCY_CD column on the EMPL_LAB_INFO record had a NULL value.

Defect 1575837: When you enable the Multicurrency functionality, the Accrued Leave Posting Report should group the records by currency.

Defect 1581925: An error displayed when the Contribution Accrual Account and the Expense Account were the same. The error message should be a warning.

Defect 1589032: The screen displayed incorrect rates for the Single with 3 or more allowances filing status for Oregon.

If you opt to not install this maintenance release, you can use the following workaround for this issue:

1. On the Manage State Tax Withholding Adjustments screen, click Query.

2. On the Find tab, enter the following parameters, and then click Find.

Field	Condition	Value
State	begins with	OR
Type	is	Federal W/H Credit Limit
Effective Date	is	01/01/2022
Filing Status	begins with	SINGLE 3 OR MORE ALLOWANCES

3. Delete the existing rows in the Tax Withholding Adjustments table.

4. Enter new rows with the following data:

For Annualized Wage Over/ Wage Basis	Base Amount	Amount Per Credit/ Exemption	% of Excess	1st Exempt Override (Y/N)	1st Exempt Override Amt	Credit Limit 1
0.00	0.00	0.00	0.00%	N	0.00	7,250.00
49,999.99	0.00	0.00	0.00%	N	0.00	7,250.00
124,999.99	0.00	0.00	0.00%	N	0.00	5,800.00
129,999.99	0.00	0.00	0.00%	N	0.00	4,350.00
134,999.99	0.00	0.00	0.00%	N	0.00	2,900.00
139,999.99	0.00	0.00	0.00%	N	0.00	1,450.00
144,999.99	0.00	0.00	0.00%	N	0.00	0.00

5. Save the record.

Defect 1600791: When you clicked the lookup on the Adjustment Reason Code field, the results displayed multiple records of the same reason code.

Defect 1574982: When you added a future Fiscal Year with an alphanumeric code, the ESUB_PD table was not automatically updated after running the Refresh Process.

Defect 1530867: When cost pools were not set up for a future fiscal year (2023, for example) and you created a budget for that year, Burdened Cost was not calculated for the corresponding pool.

Defect 1574879: During routine checks, the contract end dates were considered when inserting records instead of the budget end dates.

Defect 1503600: The application did not allow changes to Period of Performance for Indirect Project Budgets.

Defect 1541474: When you created an EAC for a Direct Project Budget, the actual costs that came in after the Period of Performance date were not included in the EAC.

Defect 1562964: When you used the same pool number across multiple fiscal years but the pool name was different, Costpoint did not summarize the burden amounts on the same invoice line.

To help fix the issue, a new check box, Summarize Pools by Pool ID, has been added to the Configure Billing Settings screen. If you select this check box, Costpoint will print pools by pool ID on the invoices (amounts will be summarized by pool ID across multiple fiscal years). If you do not select this check box, pools will be printed by pool ID and also by fiscal year on the invoices (amounts will be on different invoice lines per fiscal year and pool ID).

This affects the following applications:

Application	Defect No.
Calculate Standard Bills	1562964
Configure Billing Settings	1584496

Defect 1582604: A system error occurred upon running this application when:

• the project record's customer terms had a Due Date Method of Day of Month, and Day of Month was set to 30 (in Manage Customer Terms), and

• the Invoice Date in Calculate Standard Bills fell in the month of January.

Defect 1562970: Web Integration Console (WIC): The application was not printing all bills when using Billing Cycles and printing the report in HTML. Only 1 of the 3 invoices was printed to HTML via WIC.

Defect 1568849: The 1035 Generic billing format should have displayed a subtotal of zero regardless of the Detail Invoices check box setting in the main bill. As a workaround, you can print the invoice with the Detail Invoices check box selected.

Defect 1575480: Costpoint did not allow you to post revenue to inactive account/organization combinations. As a workaround, you can run the Redistribute Revenue screen after the revenue is posted to change the process flow.

Defect 1580620: The transactional currency/amount posted in GL of the sending entry created by the IWO was in the functional currency/amount of the sending project, even though the project's billing currency was not the same as the functional currency. The transactional currency/amount in the sending and receiving companies should have been in the sending company's billing currency/amount.

This defect affects users with a billing currency not equal to the functional currency.

Defect 1580627: The transactional currency/amount posted in GL of the sending entry created by the IWO was in the functional currency/amount of the sending project, even though the project's billing currency was not the same as the functional currency. The transactional currency/amount in the sending and receiving companies should have been in the sending company's billing currency/amount.

This defect affects users with a billing currency not equal to the functional currency.

Defect 1581098: When you created a new work assignment, Costpoint did not bring in the rates, project labor category, and general labor category from the vendor employee into the work assignment.

Defect 1600200: The application randomly did not complete processing upon Save. Because of this and related issues, new indexes were created in the backend to improve the performance of work assignment management.

Defect 1592924: You were able to look up and view restricted charges that were not assigned to you.

Defect 1579290: Following the import of existing employee group records using a type B import code, the import history displayed a duplication error because the import transformed the records using an "add" (A) transaction instead of a "change" (C) transaction.

Defect 1581943: You were able to manually enter Time-only project charges into expense reports.

Defect 1583291: Certain specific procedures associated with charging a per diem ceiling meals expense in tandem with an entertainment meals expense inolving attendees led to a 'double-claimed expenses' error.

Defect 1583354: The Other expenses for lodging expenses displayed expenses with inactive expense types.

Defect 1579620: The Manage/Approve Expense Reports text did not display for the final approval task.

Defect 1597523: New indexes were created in the backend to improve the performance of Work Assignment management.

Defect 1581805: Though a UDT01 type was not flagged for export, the correcting timesheet exported it nevertheless and errors resulted.

Defect 1590742: Cell Comments were deleted from the timesheet after you ran the Mass Correct Timesheets utility.

Defect 1573187: When you copied two lines and added opposing Start/Stop Summary hours, an error message erroneously announced a discrepancy between the total hours and the Start/Stop time.

Defect 1579040: The Locale ID date format setting was not reflected in the header for the timesheet Date column.

Defect 1579157: When your copied lines to paste into new records, the number for the newly inserted line skipped the next line number in the sequence and an error resulted when you clicked Save.

Defect 1583359: When you copied a record onto a new timesheet line, the previous validations, for example, a disabled UDT, were not carried over.

Defect 1592798: Because the Charge Lookup Group Cache and the Charge Lookup Resource Restricted Charges were not fully integrated, lookup performance was inhibited for resources with restricted charges.

Defect 1598292: When you scrolled back to earlier timesheets that contained a different work schedule (for example, part-time instead of full-time), the display of work days, non-work days, and holidays reflected the current, newer work schedule rather than the one in effect at the earlier time.