2020 Pennsylvania SUTA Electronic Filing

Effective January 1, 2020, Pennsylvania requires monthly employee count fields in the Total Tax Record (Record T) for both original and amended ICESA files. To comply with state requirements, the Create Quarterly SUTA Tax File (PRPSMM) screen now provides the following information in Record T of the Pennsylvania SUTA electronic file. The employee count will be provided in the following Record T positions regardless if the Report Type in Record A position 141-153 is "Original" or "Amended.”

Position	Column	Value
227-233	Month 1 Employment for Employer	The number of covered employees who worked or received pay for the pay period, including the 12th day of the 1st month of the reporting period.
234-240	Month 2 Employment for Employer	The number of covered employees who worked or received pay for the pay period, including the 12th day of the 2nd month of the reporting period.
241-247	Month 3 Employment for Employer	The number of covered employees who worked or received pay for the pay period, including the 12th day of the 3rd month of the reporting period.

 

Attention: For more information, refer to File Layouts and Formats for Electronic Reporting of PA Quarterly Unemployment Compensation Wage and Tax Data: https://www.uc.pa.gov/Documents/UC_Forms/UC-2010.pdf.

The Costpoint MR 7.1.6 installer is updated to include support and compatibility for Weblogic 12.1.3 and Weblogic 12.2.1.3 Oracle Critical Patch Update (April 2020) and to include JDK 1.8.0.251. This update aims to address security vulnerabilities.

Costpoint MR 7.1.6 updates the Print VETS-4212 Report (HARV100) screen and changes the existing single date parameter on the screen into a range of dates. You will now be able to enter a pay period date range, which represents the pay period used as the basis for filing the VETS-4212 report. Costpoint will use the pay period date range for reporting the following:

• Number of employees: The application will use the pay period start and end dates as the basis for the employment figure.

• Number of new-hires for the 12-month reporting period: The application will use the pay period end date as the end date for the twelve-month reporting period.

Note: The VETS-4212 Report will be based on a pay period that has an end date between July 1 and August 31. Any Federal contractor or subcontractor that has written approval from the Equal Employment Opportunity Commission to use December 31 as the ending date for the EEO-1 Report may also use that date as the ending date for the payroll period selected for the VETS-4212 Report.

The following are the updates to the Print VETS-4212 Report screen:

• The “Period End Date” label in the Selection Range group box changed to “Pay Period Date.”

• The value in the Option field for Pay Period Date changed to Range.

• The screen now requires start and end dates for the reporting period in the following fields:

• Pay Period Date – Start field: Enter, or use the calendar lookup, the pay period start date to determine the number of employees.

• Pay Period Date – End field: Enter, or use the calendar lookup, the pay period end date to determine the number of employees and the number of new-hires in the previous 12-month period.

The recent H.R. 6201: Families First Coronavirus Response Act regulations for COVID-19 allows employees to receive paid sick leave and Paid Family Medical Leave for certain COVID-19-related situations. The regulations, however, state that employees must use the leave between 04/01/2020 and 12/31/2020.

To allow Costpoint Shop Floor Time users to comply with the regulations, Costpoint MR 7.1.6 updates the way the Export Project Manufacturing Data (LDPEXPM) process handles the export of leave data. The application will now use the start and end dates on the Paid Family Leave subtask of the Manage Employee Leave (LDMELV) screen as the basis of the leave start and end dates exported to Shop Floor Time. This update will prevent employees from charging the COVID-19-related leave outside of the dates allowed by the government regulation.

Costpoint MR 7.1.6 adds the ability to track changes made to the pay stub and W-4 information in the payroll records of employees. You can access the audit trail for employee earnings and payroll on the View Employee Earnings (PRQERF) screen and the View Payroll Edit Table (PRQPTF) screen.

This release applies the following database changes in the corresponding screens for the new functionality:

View Employee Earnings

• New columns were added for the tracking of pay stub information.

• A new EMPL_E_PAYSTUB_HRLY_RATES_ADT child table was added to track changes to paystub hourly rate information.

View Payroll Edit Table

• New columns were added for the tracking of pay stub information.

• A new EMPL_PR_PAYSTUB_HRLY_RATES_ADT child table was added to track changes to paystub hourly rate information.

The Small Business Administration (SBA), with support from the Department of the Treasury, implemented the Paycheck Protection Program (PPP), which authorizes up to $349 billion in forgivable loans to small businesses to pay their employees during the COVID-19 crisis. The program allows qualifying employers with up to 500 employees to apply for a forgivable loan to cover payroll costs over an eight-week period from February 15 to June 30, 2020.

Note: The deadline to submit the Paycheck Protection Program loan application with the required documentation to an approved lender is on June 30, 2020.

As part of the requirements for the loan application, employers will need to provide payroll costs to determine the average monthly payroll. This includes the following

• Employee gross pay (capped at $100,000 on an annualized basis for each employee)

• Employer-paid benefits contributions

• Employer-paid retirement contributions

• Employer-paid state and local taxes

Attention: For more information, refer to the PAYCHECK PROTECTION PROGRAM (PPP) INFORMATION SHEET: https://home.treasury.gov/system/files/136/PPP--Fact-Sheet.pdf.

To aid in the application for a loan through the COVID 19 Payroll Protection Program, the Payroll Toolkit (PRPTOOLKIT) provides the functionality to calculate your company’s monthly payroll costs for 12 months. The report generated by the toolkit will use 12 months of paycheck data for the selected taxable entity to determine the monthly amounts for the following:

• Gross employee earnings

• Employer paid state/local taxes

• Employer paid health and retirement contributions

• Any gross employee earnings over 100K

• Number of employees

The monthly total payroll costs will be calculated by adding the employee gross earnings, employer paid state/local taxes, and employer paid benefits. The payroll costs above 100K will be subtracted from that amount to find the total payroll costs. The yearly average will be calculated for the total payroll costs and the number of employees.

You can go to People » Payroll » Payroll Utilities menu in Costpoint to access the Payroll Toolkit.

Warning: The report includes only U.S.-based employees. The report will include all contributions unless you specifically exclude certain contribution types. The report should be by taxable entity.

The Costpoint Online Help system now displays information for the People domain in the new and improved help format which presents content in a more structured layout. The new help format always displays the table of contents to allow you to easily navigate through topics for a particular screen. This update is part of Deltek’s transition to a new authoring tool for the Costpoint Online Help.

 

Attention: For more information on the Costpoint Online Help, go to:

• https://help.deltek.com/Product/Costpoint/Documentation/Costpoint_Online_Help.html.

• http://help.deltek.com/Product/Costpoint/7.1.1/GA/Dual_Table_of_Contents.htm

The new check box, Round Column on Supporting Schedule, added to the Print Standard Bills screen lets you include the Rounding Audit column on the Labor Supporting Schedule report. This column indicates the rounding amount and where exactly (at which labor category) the rounding is placed. 

 

This new check box is enabled only if you selected the Supporting Schedules Only or Bills and Supporting Schedules option in the Select Printing group box. When you select this check box, the Rounding Audit column displays on Labor Supporting Schedule, while the Cumulative Hours and Cumulative Amount columns are hidden. 

 

The new column is applicable if the supporting schedules you are printing include amounts. If the Hours Only check box is selected on the Manage Supporting Schedule Formats screen, the Rounding Audit column does not display in the Schedule report even if the option to display it is selected.

 

This enhancement applies to both posted and unposted bills.

Defect 1296294: You encountered an error when you imported purchase order (PO) vouchers containing vendor labor information. As a workaround, do not use a PO Voucher Vendor Labor input file when importing PO vouchers and manually enter vendor labor details on the Manage Purchase Order Vouchers screen.

Defect 1276876: When you queried a Pay Vendor with open voucher lines, entered all required values, and clicked Save without selecting any voucher for payment, you encountered a system error instead of the error message "You must have at least one row in Selected Vouchers".

Defect 1279123: Vendor employee and vendor labor timesheet information were not included in the updated record after you reversed a subcontractor purchase order voucher.

Defect 1294577: Costpoint treated the rates in the LAB_RT_AMT, TRN_LAB_RT_AMT, LAB_RT_ADJ_AMT, and TRN_LAB_RT_ADJ_AMT columns in the VCHR_LAB_VEND_TS_HS table as amounts and negated their values.

Defect 1275811: When you printed an Accounts Receivable Aging report that contains a partially paid invoice with a Billing Currency that is different from the Functional Currency, the Unrealized Gain/Loss for that invoice was not correctly updated on the report.

Defect 1281197: Costpoint did not subtract the Salvage Value of an asset before computing its projected Depreciation Expense Amount even if the Depreciation Method for that asset has the Subtract Salvage Value Before Calculation check box selected.

Defect 1282909: The lookup functionality for Cobra projects did not display projects with descriptions that exceeded 60 characters. This issue affects you if you use Costpoint to Cobra integration.

The following applications displayed this issue:

Application	Defect No.
Manage Cobra Resource Templates (AOMCBBET)	1281735
Manage Cobra Charge Templates (AOMCBCHG)	1281739
Manage Cobra Cost Templates (AOMCBCST)	1281740
Manage Cobra Extraction Parameters (AOMCBEXT)	1281742
Manage Cobra Project Mapping (AOMCBPRJ)	1281743

Defect 1284963: The application automatically assigns opportunity IDs even though you cleared the Auto-assign Opportunity IDs check box on the Configure Opportunity Settings screen.

Defect 1239778: The application did not allow you to successfully migrate contracts data from GovWin Capture Management to Costpoint because of various required field errors.

Defect 1285506: When you imported GovWin IQ data, the errors for failed records did not display on the S_INTERFACE_ERR table or on the Export/Import Errors subtask. As a workaround, you can check the log file (CP_INT_GOVWINIQ_DEServer.log) for the actual error.

Defect 1281129: When you migrated an updated contract record from Capture Management into Costpoint, and this record was already existing in Costpoint, the system created a new contract record in Costpoint instead of updating the existing one.

Defect 1271472: Costpoint did not clear the Address Code fields on the Details/Addresses tab when you deleted entries in the Prime Contractor, Primary Customer, and Acquisition Customer fields on the General tab.

Defect 1276636: When you migrated opportunity data from Capture Management into Costpoint and then updated that opportunity record in Capture Management, an incorrect status message displayed in the process logs.

Defect 1288162: The mobile PIN for Costpoint on a smartphone worked with a system name that was different than the system name for which it was saved.

Defect 1293216: The Paste function did not work correctly when you pasted multiple lines that were copied from Excel into Costpoint on the Firefox browser. Alternatively, you could paste single lines.

Defect 1291306: The approval dialog box locked when you approved a line record where the header row was read-only.

Defect 1271469: The trailing space in the account number caused the account numbers and expenses to display twice in the income statement.

Defect 1291654: A critical system error occurred when you performed any content management integration (CMI) operation with SharePoint in Office 365 Government Community Cloud High (GCC High).

Defect 1287339: When you tried to do a standard inventory location transfer by moving a single item or an entire location, you received an error message that said an inventory allocation is required on save.

Defect 1296427: You were unable to post the inventory journal due to missing organization IDs on transactions that were uploaded using the Import Inventory Transactions screen. The preprocessor failed to validate the organization on the Charging side of the transaction.

Defect 1295557: When you deleted a generated purchase order (PO), the system incorrectly updated the requisition line generated quantity.

Defect 1290513: When the quantity/unit of measure were changed in the Apply PO Info to Purchase Requisitions screen and the PO was generated, the On Requisition quantity in the inventory was incorrectly calculated, which caused a Reconciliation issue.

Defect 1285086: When you entered a part on a requisition line and selected Certificate of Conformance (CofC) or Quality Control Inspection (QCI), and then you clicked New to add a line, the first line's selected check boxes reverted to clear.

Defect 1293843: You received a Request for Quotes (RFQ)/Item combination error when you tried to create a vendor quote using web services.

Defect 1283484: When you set a new Item User Defined (UDEF) Label, added a value in Manage Parts for that Label, and then saved the record, a new Label related to the Project User Defined Info was created instead of just the Item UDEF.

Defect 1291526: When you removed a substitute part in place of a primary from Manufacturing Execution System (MES), you encountered the following error: PC_RQMT_SEQNO_DOESNOT_EXIST: ERROR:This MO operation sequence is not associated with the MO requirement line being issued.

Defect 907135: When you created two open purchase orders (PO) in the same session and assigned the same serial ID to both POs, you received a system error upon save.

Defect 1280263: When you saved a new quality control inspection, you encountered the following error: "This record already exists."

Defect 1279783: When you created an invoice, the sales order invoice process incorrectly applied tax on top of an extended price that already had tax applied to it.

Defect 1191715: The application printed inconsistent minimum/maximum employee counts on the VETS-100 report.

 

Defect 1294797: When you entered a new record and then pressed the TAB key to move out of the Employee field, a critical system error (NullPointerException) displayed. This issue occurred when the Costpoint Payroll license is off.

The issue was caused by the fix for Bug 1031402, which was included in MR 7.1.5.

Defect 1291116: The application should remove the country code and dash/hyphen from the state code value when it sends the data to Deltek Talent Management.

Defect 1294475: The application exported the project code from Costpoint as an active charge tree record even if you set None as the Export Project classification on the Manage Project User Flow screen. In this scenario, the application should only generate a deletion record.

Defect 1029604: The Manage Leave Types screen required updates so that it will properly enable/disable fields when you set up a leave type as Use as Excess Leave Type. This update is necessary for the Compute Leave Accruals screen and Close Leave Year screen to correctly apply year balance ceilings to leave types flagged as Use as Excess Leave Type.

Defect 1097749: When you had a leave type set up for deferral, and then you marked the same leave type for transfer to a new leave type, the application proceeded with the transfer. It created the new leave type record with deferred leave, whether or not you set up the new leave type for deferral. The application should not include the leave in deferral state when processing leave type transfers.

Defect 1293876: The error report did not display an error when a record did not have a project even though a project was required for the record's account.

Defect 1294713: The generated SUTA file excluded employee records that had an Effective Date (EFFECT_DT) column value equal to the first day of the next quarter on the Salary Information and History (EMPL_LAB_INFO) table. As a workaround, you can change the Effective Date column value in the affected employee records.

Defect 1284510: When you ran the Update Excess Life Deductions process, Costpoint deleted the EXLI (Excess Life Insurance) deductions from the Manage Employee Deductions screen for employees whose Supplemental Life deduction was higher than the calculated EXLI deduction. As a workaround, you can manually add the EXLI deduction back to all the affected employees and manually calculate the EXLI amount for the deduction.

Defect 1270637: The organizational security functionality did not work on the Approve Position Requisitions screen. The screen allowed you to view all requisitions instead of only those requisitions for your organization security profile.

Defect 1236831: You could not delete Project Budget Approvers (MAP8) source entries.

Defect 1279301: The system counted the Period work days incorrectly.

Defect 1287738: You received a critical system error when you opened the Refresh Process application.

Defect 1290549: Duplicate records were displayed in the Report Project Details table.

Defect 1285277: When you computed forward rates, credit allocations were not created.

Defect 1242238: When you viewed the Pool Rates subtask, the Reclass pools were identified as Service Center pools.

Defect 1295341: You encountered a system error when you tried to create an Outlook.

Defect 1298976: OLK reports did not display the correct period values for outlook (BOL2) due to wrong period counts when the fiscal year was after the last closed period fiscal year.

Defect 1246899: Pending costs were not displayed if the Project End Date was already over.

Defect 1287389: The Use Fixed Revenue Amount as Total Amount check box was selected by default when the revenue formula was set to Loaded Labor Rate. However, the check box should have been cleared.

Defect 1261806: When you tried to save Distributed Revenue, only the Working Budgets were saved.

Defect 1285152: The Fixed Revenue & Adjustments row should be displayed as two rows, namely, Fixed Revenue and Adjustments from Revenue Ceiling and EAC Adjustment to Actual Revenue.

This issue also affected the following application:

Affected Application	Defect No.
Revenue Analysis (BPA17)	1285155

Defect 1295331:You should not have been able to edit the Period of Performance Start and End Dates to be less than Contract Dates for EACs.

Defect 1297861: You encountered a system error during burden calculation.

Defect 1289808: When you ran the report, Prior Year values did not match the Costpoint Project Status Report.

Defect 1281127: An error occurred when you ran this application for a project with supporting schedule. As a workaround, you can remove the supporting schedule setup for the project (delete all rows on the Detail Levels subtask of the Manage Project Billing Information screen).

Defect 1282789: When the transaction and billing currencies were different from the functional currency, Costpoint used the USD currency for the burden calculation and used the invoice date to convert the burden cost to the billing currency.

Defect 1291282: When a project has records in the Z_BLPUBILL_RPT table but no longer has data in Manage Open Billing Detail, Costpoint now removes those records from the Z table. This is to avoid encountering an error when calculating bills.

Defect 1283503: You received the following error message when you tried to release a transaction amount on hold: "Either Amt On Hold or Write Off Amt or Amt Prev Billed or sum of Amt Prev Billed and Amount to Bill absolute value cannot be greater than the Transaction Amt absolute value." As a workaround, use the Adjust Open Billing Detail Records screen to release the amount.

Defect 1282063: A critical system error occurred when you saved a record with the Period field blank. Costpoint should have displayed this error message instead: "The following field is required: Period." As a workaround, enter a value in Period to avoid the error.

Defect 1279174: The NL_DISC_AMT column value in the BILL_EDIT_INVC_HDR table turned NULL after you executed the Reverse Previous Bills process.

Defect 1262906: When you computed revenue, the Manage Direct Cost Ceilings application held cost as over the ceiling despite the cost not reaching the ceiling threshold.

Defect 1282905: Costpoint did not enforce negative ceilings when you computed revenue.

Defect 1271475: The inception-to-date (ITD) hours and amounts were incorrect in the Project Labor Summary Report. This defect affects Oracle and MSS users of Costpoint.

Defect 1294608: When you imported link27 XML files, the error log displayed the message: "Can't find bind variable adjustedImportCd among public variables of the class."

Defect 1288077: When you uploaded a file to Costpoint, the file did not display the short description in the Voucher Notes field if the expense report did not include comments.

Defect 1286260: An error occurred when you imported AMEX files for an invalid or incorrect Departure Date. This error did not occur for clients using Oracle and Costpoint 8.

Defect 1286739: When supervisors created expense reports, the Individual expense attachments were deleted.

Defect 1287840: When users with approval roles selected multiple rows that included rows to which they lacked rights, the buttons did not disable, allowing the users to approve all of the selected tasks.

Defect 1288660: SubQ employees adding claimed expenses encountered errors when they opened Lookup and selected an expense type.

Defect 1293106: The Create and Submit task buttons were missing from the Manage Expense Report Workflow subtask.

Defect 1286537: After you clicked Correct on a timesheet with line level-approved charges, the previously approved lines remained marked as approved. Those approved lines failed to display when queried. If you queried the database, these lines were marked as approved, but approved hours were set to 0.

This issue also affected the following application: 

Affected Application	Defect No.
Mass Correct Timesheets	1290738