Florida Reemployment Tax Electronic Filing Software ID Update

 

The EDI/XML Development Team of Florida Department of Revenue provided a new production Software ID for Deltek, Inc (Costpoint). The Create Quarterly SUTA Tax File screen now uses the new Software ID in the generated XML file for Florida. 

 

To support the update, Costpoint adds a new State SUTA Electronic File Software Information (S_SUTA_SOFTWARE_INFO) database table, which stores the software developer information per state. 

 

The following screens were updated for this enhancement: 

• Create Quarterly SUTA Tax File (PRPSMM) 

• Print Data Dictionary Report (SYRDD) 

 

Note: This enhancement requires patch dbc_800_10683. 

The Costpoint 8.0.14 MR installer now installs the WebLogic 12.2.1.4 IIS proxy files when you are running that version of WebLogic. To update the DEProxy files, you must also run the 8.0.14 MR on each of your web server(s).

The 8.0.14 MR installer has been updated to include the latest quarterly patch release for WebLogic 12.2.1.4.

• • July 2021 SPB - p33125241_122140_Generic.zip

Also, the Java Development Kit (JDK) has been upgraded to version 1.8.0_301 and is installed with the Costpoint 8.0.14 MR Installer.

The Federal Certified Payroll Report in Costpoint added the ability to report corrections from past pay periods.

Compute Payroll (PRPCPR)

Prior to this version, the Compute Payroll application only allowed you to compute payroll for the timesheets within the open pay period. You can now use the following new field on the screen to enter an earlier starting date for processing:

Field	Description
Starting Timesheet Date	Enter, or click Calendar Lookup, to select an earlier starting date for timesheet selection. Use this field to include corrections from past pay periods. This is necessary for complete certified payroll reporting, which must report hours worked on a particular day.

 

Print Federal Certified Payroll Report (PRRCERT)

The application features the following changes:

• The existing Print Certified Payroll Report screen was renamed to “Print Federal Certified Payroll Report.”

• The Pay Cycle Date fields were updated to display the corresponding start/end dates when you enter a valid pay period starting date or ending date.

• You can now opt to run the report for certain employees. To support this functionality, the screen provides the following field in the Selection Ranges group box:

Field	Description
All Employees	Select this check box to include all employees in the report. If you want the report to include only certain employees, clear the check box to list specific employees on the Employees subtask.

• The new Employees subtask provides the following fields:

Field	Description
Employee	Enter, or click Lookup, to select an employee to include in the report.
Name	This field displays the name of the selected employee.

• The report now includes check number information.

• The application now includes all timesheets (whether regular or correcting types) when it determines the hours worked per day. The corrections are printed in separate sections. One correcting section prints for each pay check.

 

Print Deduction/Contribution/Fringe Report (PRRMBEN)

The application features the following changes:

• The Print Deduction/Benefit Report by Local screen was renamed to “Print Deduction/Contribution/Fringe Report.”

• The report now includes check number information.

• The screen provides the following Report Sort options:

• Type / Code / Employee Name / Check Date / Check Number

• Type / Code / Employee ID / Check Date / Check Number

• Employee Name / Check Date / Check Number / Type / Code

• Employee ID / Check Date / Check Number / Type / Code

• Employee Name/ Check Date / Check Number / Type / Amount

• Employee ID / Check Date / Check Number / Type / Amount

A Time & Expense » Configuration » Utilities » CP/TE Diagnostics Toolkit utility was added to version 8.0 that enables System Administrators to identify and address potential data discrepancies prior to upgrading to version 8.1, which will be available for general release in the first quarter of 2022.

 

In version 8.1, Time & Expense installations that are co-deployed with Costpoint will read directly from the Costpoint tables for UDTs (01-11) across all domains, and therefore, unresolved data discrepancies, such as when a UDT exists in one system but not in the other, may result in system errors in version 8.1.

 

The utility includes 19 separate diagnostics, and where issues are identified, it can automatically resolve the discrepancy by setting the value in one system to that of the other, or in some cases, you may be required to manually update the data, such as adding or deleting a UDT.

 

Although you will be able to run the same diagnostics in version 8.1, discrepancies are resolved more easily from version 8.0. After you upgrade, the Costpoint values, such as for UDTs, become the default value, and the older values from Time & Expense are moved to archive tables. So for example, if you want to set the Costpoint value to the Time & Expense value, that option is no longer available in the utility.

 

For each item you select under Type, the screen displays instructions specific to that diagnostic. The first time you use the application, you must Initialize to populate the Type drop-down list.

 

 

 

 

Following the installation of version 8.0.14, do the following to run the Toolkit:

1. Click Time & Expense » Configuration » Utilities » CP/TE Diagnostics Toolkit.

2. On the Toolkit screen, click the Intialize button.

This process compares the Costpoint and Time & Expense data to identify discrepancies between them. After the initialization process is completed, the Type drop-down list populates with different diagnostics where discrepancies were found. Up to 19 separate types may display.

3. From the Type drop-down list, select the diagnostic you want to review and click Show Results.

The Results table is populated with the data discrepancies uncovered by the diagnostic. Optionally, you can click Record Counts to display record results for all the separate diagnostics.

4. Depending on the type of diagnostic you selected, one of the following options may display below the Results table:

• Set CP Value to T&E Value: Select this option to change the value in Costpoint to match the value in Time & Expense.

• Set T&E Value to CP Value: Select this option to change the value in Time & Expense to match the value in Costpoint.

• Remove from Charge Tree: This option displays only for the diagnostic that identifies records that exists in the Time & Expense charge tree for UDTs 01-11 but do not exist in Costpoint. Select this option to remove the charges from the T&E charge tree. The charges, if needed, must be manually added to the appropriate application in Costpoint.

If no buttons display, corrections must be made manually in the appropriate area of Time & Expense or Costpoint.

 

The table below provides a brief description of each diagnostic that may display under Type. Refer to the on-screen instructions in the CP/TE Diagnostics Toolkit application for details on how to correct the data for each one that occurs in your system.

Diagnostic Type	Purpose
Error - Not in Costpoint - UDT in use	This identifies all records that exist in Time & Expense but do not exist in Costpoint.
Error - Project required flag does not match – UDT in use	This identifies all accounts where the Project Required setting in Time & Expense does not match the same setting in Costpoint.
Error - Whether for time and/or expense does not match - UDT in use	This identifies all projects where the time and/or expense value in Time & Expense does not match the same value in Costpoint.
Warning - Abbreviation does not match	This identifies Project and Org records where the abbreviation does not match between Costpoint and Time & Expense.
Warning - Account type does not match – UDT not in use	This identifies accounts where the Time Collection Account Type value in Costpoint does not match Account Type in Time & Expense.
Warning - Account type does not match - UDT in use	This identifies accounts where the Time Collection Account Type value in Costpoint does not match the same setting in Time & Expense.
Warning - Active flag does not match	This identifies all records where the Active setting in Time & Expense does not match the same setting in Costpoint.
Warning - Allow Charging flag does not match	This identifies all records where the Allow Charging setting in Time & Expense does not match the same setting in Costpoint.
Warning - Calculation does not match	This identifies all Pay Type records where the calculation in Time & Expense does not match the calculation in Costpoint.
Warning - Cost Only flag does not match	This identifies all Pay Type records where the Cost Only setting in Time & Expense does not match the same setting in Costpoint.
Warning - Costpoint company does not match	This identifies all Project and MO records where the Costpoint company in Time & Expense does not match the company in Costpoint.
Warning - Description does not match	This identifies all records where the description in Time & Expense does not match the description in Costpoint.
Warning - Factor does not match	This identifies all Pay Type records where the factor in Time & Expense does not match the factor in Costpoint.
Warning - Not in Costpoint but in Charge Tree	This identifies all records that exist in the Time & Expense Charge Tree but do not exist in Costpoint.
Warning - Overtime flag does not match	This identifies all Pay Type records where the overtime setting in Time & Expense does not match the overtime setting in Costpoint.
Warning - Project required flag does not match - UDT not in use	This identifies all account records where the Project Required setting in Time & Expense does not match the same setting in Costpoint.
Warning - Whether for time and/or expense does not match - UDT not in use	This identifies all project records where the time and/or expense value in Time & Expense does not match the same value in Costpoint.

Defect 1496672: Costpoint displayed incorrect amounts on the View Receivables and Collections screen and in the Accounts Receivable History report when you did the following:

• Entered cash receipt details

• Manually entered the invoice number in the Invoice Line Info group box

• Updated the rates on the Exchange Rates subtask

• Saved and posted the cash receipt

Defect 1495279: When you imported journal entries, Costpoint was unable to retrieve period exchange rates when daily exchange rates were unavailable. This occurred even when the Use Period Rate check box was selected in the Exchange Rate Method group box of the Configure Multicurrency Settings screen.

Defect 1507313: Purchase order (PO) lines can have a period of performance (POP) that is different from that of the subcontract. Multiple POs linked to a single subcontract record can also have different POPs.

Previously, POP fields on the Manage Purchase Orders and Manage Purchase Requisitions screens were read-only and displayed POP dates from Manage Subcontracts by default. Now, those fields will still default from Manage Subcontracts for new PO/PR records, but you will be able to edit them.

• Manage Purchase Orders screen

• Period of Performance Starting (Other Defaults tab)

• Period of Performance Start Date (Purchase Order Lines > Line tab)

• Period of Performance Ending (Other Defaults tab)

• Period of Performance End Date (Purchase Order Lines > Line tab)

• Manage Purchase Requisitions screen

• Period of Performance Start Date (Requisition Lines > Other Information tab)

• Period of Performance End Date (Requisition Lines > Other Information tab)

In PO/PR records, if the POP start or end date is outside the subcontract's start or end POP range, Costpoint displays a warning message. If you change the subcontract ID linked to the PO/PR record, Costpoint refreshes the POP information in the PO/PR record.

Defect 1503684: You could not open a Requisition through the email approval link.

Defect 1497480: When the Part was a Make, the Planned Order Settings/Purchase Vendor Lead Time Calculation was set to Standard Calendar, and the Production Control Settings/Lead Time Calculation was set to Shop Days, the resulting order date was incorrect.

Defect 1507319: You can now edit the requisition line Period of Performance Start and End Dates even when a subcontract ID is referenced in the requisition. If the Period of Performance (POP) start or end date is outside the subcontract record's start or end POP range, Costpoint displays a warning message. If you change the subcontract ID linked to the record, Costpoint refreshes the POP information in the record.

Defect 1507322: You can now edit the Period of Performance Start and End Dates even when a subcontract ID is referenced in the requisition. If the Period of Performance (POP) start or end date is outside the subcontract record's start or end POP range, Costpoint displays a warning message. If you change the subcontract ID linked to the record, Costpoint refreshes the POP information in the record.

Defect 1502164: When you resubmitted rejected lines for a requisition with line text associated to it, you encountered an error.

Defect 1507316: You can now edit the requisition line Period of Performance Start and End Dates even when a subcontract ID is referenced in the requisition. If the Period of Performance (POP) start or end date is outside the subcontract record's start or end POP range, Costpoint displays a warning message. If you change the subcontract ID linked to the record, Costpoint refreshes the POP information in the record.

Defect 1508123: When you created a manufacturing order (MO) relief and saved it, you encountered an error.

Defect 1494207: When you manually added parts to the manufacturing order (MO) requirements after you changed the As of Date, the added parts were not included in the requirements.

Defect 1506217: You can now edit the purchase order header and line Period of Performance Start and End Dates even when a subcontract ID is referenced in the purchase order (PO). If the Period of Performance (POP) start or end date is outside the subcontract record's start or end POP range, Costpoint displays a warning message. If you change the subcontract ID linked to the PO record, Costpoint refreshes the POP information in the record.

Defect 1509768: When you updated a purchase order (PO) but did not change the status, the APPRVL_USER_ID table was also updated.

Defect 1492360: When you created and saved quantity adjustments for parts that were lot tracked only, you encountered an error.

Defect 1496397: When you sent a Plan to Costpoint from Manufacturing Execution System (MES), you encountered the following error message: An attempt to Insert row for the result set RUMROUT_ROUTINGLN_CTW was denied due to insufficient rights.

Defect 1501507: When you changed the warehouse ID, the reservation ID was not correctly reassigned in Costpoint.

Defect 1499795: The report did not print when:

• The effective date of the Salary Information record was within the training start and end dates.

• There was no course information for the employee.

Defect 1479914: The application did not generate the import error report when a record in the input file was missing a comma.

Defect 1499447: Some imported employees with salary increase had negative percent of increase.

Defect 1462041: The printed paystub did not display the company logo even if you correctly set up the logo file on the Configure System Settings screen.

Defect 1509244: When you reprocessed timesheets with previously created adjustments, the application created retroactive timesheets with incorrect transactional amounts. It created incorrect retroactive timesheets for each instance that you reprocessed the same date range.

Defect 1502388: The Create CSV Export Files for Base/Link Tables check box should be clear by default when you first open the screen.

Defect 1515167: The application doubled the amount of leave payout lines when there was more than one leave type assigned to be paid out.

Defect 1510475: The application should not generate union fringes and deductions for employees that are not set up as union employees on the Manage Employee Information screen.

Defect 1282079: The Export Payroll Taxes process miscalculated the YTD earnings on the local tax line for an employee who moved to another state. For example, the employee moved from Nevada to California.

Defect 1500379: The calculation was incorrect for the QTD Total Hours (Field 15) and YTD Total Hours (Field 16) in LCEE and LCER records.

Defect 1512477: The YTD deduction amount included the previous calendar year amount.

Defect 1507875: During refresh of the CER table, the ACT_BURDEN_DELTA routine caused unnecessary updates.

Defect 1511082: When the Subperiod Method field in Configuration Settings was set to Combine Subperiods, the year-to-date rate adjustment values in Burden Cost Breakdowns did not display as expected.

Defect 1507572: Hours-based service centers showed a doubling in EACs, while future service center costs were not reflected in EACs or budgets.

Defect 1504027: Performance tuning has been performed for Calculate Standard Bills to decrease the application's runtime.

Defect 1496548: Task order number values were not printed using Print Standard Bills when any of the columns on the Details subtask of Manage Standard Bills were modified.

Defect 1494986: This application has been updated to post zero sales tax rows to the AR_SALES_TAX table.

Defect 1397213: The currency symbol printed in the Rounding Audit column of the T&M Labor Supporting Schedule was for the functional currency rather than for the billing currency.

Defect 1487853: The application was running longer than expected.

Defect 1489042: When you entered revenue information for two project levels (for example, level 3 PROJ.01.01 and level 4 PROJ.01.02.01) and then ran Redistribute Revenue for the lower-level project (PROJ.01.02.01 in the example), Costpoint displayed the following error message: "No Revenue formula is set up at this level of the Project or a lower level. Redistribute will not be run."

Defect 1488290: The report included accounts with zero rates, which caused some projects to be printed with incorrect period rates.

Defect 1478403: A critical system error occurred while running the Load Labor Rates application as a result of Link PLC Rates to Employee/Vendor allowing users to enter and save duplicate lines for the same vendor, project labor category (PLC), bill rate, and date.

Defect 1376878: When cloning a record in Manage Employee Work Force, the system allowed you to save a record that includes a project labor category (PLC) which is not linked to the project.

Defect 1385963: Depending on the order of data entry, cumulative amounts were either calculated incorrectly or not updated instantaneously before the modification was saved.

Defect 1394694: When you created new project modifications via web services, the cost values passed from the XML file were incorrectly saved.

As a workaround, you can create new modifications on the application's UI, or you can do an UPDATE Transtype via the Web Integration Console (WIC) to correct the values.

Defect 1496408: On the Modifications subtask, Costpoint doubled the first value that you entered in both the Value Modifications and Funding Modifications group boxes upon tabbing out of the field. The correct values were reflected only after you saved the record.

Defect 1500414: The dates on the x-axis of the Opportunity Dashboard should have displayed in ascending order.

Defect 1500415: The Benefits Enrollment Report in Costpoint Enterprise Reporting for HR and Payroll displayed data for another Organization EIN.

Defect 1508002: The net income for the Period 6 column used the Period 5 net income as reference on the Trended Income Statement found in Team content » General Ledger. As a workaround, use the legacy version of the Income Statement or the Costpoint Income Statement report.

Defect 1509299: The PSR Report template in Planning did not reflect all rows for a project.

Defect 1516307: The CER__ADV_LITE user should have rights to run custom SQL queries and not create them. To address this defect and apply the fix, see Knowledge Base Article 106409 - Data Source Connections Permissions. The fix is only necessary if you use the CER__ADV_LITE user group. For cloud customers, DCO applies the fix. For on-premises users, the system administrator applies it.

Defect 1511466: For VISA transactions, when the batch type Wizard subtask was set to direct the transaction to a different pay method, the import process assigned the wrong pay method to other transactions.

Defect 1493616: Though the related expense report was voided, the expense authorization remained in a processed state.

Defect 1500390: When you delegated a specific role, the delegation instead applied to all roles. As a result, some users were able to view content that was not supposed to be visible to them, as well render approvals that were outside of their roles.

Defect 1510504: Processing of the Attachment table was addressed to resolve issues that slowed performance.

Defect 1512587: When you printed from the Expense Report screen, you received an "Invalid Action" error message.

Defect 1507483: When one of two attachments on an expense report was deleted, the Attach Line View displayed the deleted receipt.

Defect 1512584: When you printed from the Print Expense Report screen, you received an "Invalid Action" error message.

Defect 1508723: Because floorcheck emails were part of the transaction workflow, delays in their transmission contributed to keeping the database transaction open for an extended period of time.

Defect 1502861: A supervisor was able to modify a timesheet that was in the process of being exported.

Defect 1500546: When you used the start/stop summary and the UDT10 or charge required a comment, adding a single comment on the charge line still produced an error message stating that a comment is required.

Defect 1500548: When you used the start/stop summary and the UDT10 or charge required a comment, adding a single comment on the charge line still produced an error message stating that a comment is required.

Defect 1506691: Missing timesheet notifications were sent out to employees for the wrong timesheet schedule and period.

Defect 1508724: Because floorcheck emails were part of the transaction workflow, delays in their transmission contributed to keeping the database transaction open for an extended period of time.

Defect 1511087: When you ran queries for all timesheet classes with Global Full Time Exempt selected as a starting class, an Oracle error occurred.

Defect 1510696: The New Leave Request dialog box closed unexpectedly when you requested leave with hours that exceeded the maximum number of standard hours.