Please refer to the Common SPU Installation Guide for download and installation instructions.
Version 23.1.9 Enhancements
Enhancements
- Updated display message for validation issues to report the number of employees with validation issues, instead of the total number of validation issues.
Corrections
- Resolved an issue where total hours for work and accruals were not reporting correctly.
- Resolved an issue where Add Missing was populating the WCC and WCC Group fields for Expense Reimbursement earnings.
- Resolved an issue where the count displayed in the log was reporting incorrectly.
Previous Version Enhancements
Version 23.1.8 Enhancements
Not released. Enhancements rolled into version 23.1.9
Version 23.1.7 Enhancements
Enhancements
- Added ability to import time data with one source file for multiple employers with a single import operation.
- Added a pop-up message to let the user know if the ‘Delete all data’ feature completed successfully.
Corrections
- Fixed an issue with the installer failing to complete successfully.
- Fixed an issue where user is unable to delete a line item from Time Source Mapping setup.
- Fixed an issue where the Validation table was not clearing correctly after importing time data of an incorrect company.
Version 23.1.6 Enhancements
- Corrected an error condition with Time & Labor Import when the payroll database name begins with a zero (0).
Version 23.1.5 Enhancements
- Added the ability for T&L administrative users to delete all data from the T&L import data and validation tables.
- Corrected an issue where the correct Distribution Code was not set correctly on Auto-Add earning codes.
- Corrected an issue with SPU not starting when choosing Integrated Security as the SQL connection option.
- Corrected an issue where the validation report was listing extraneous records.
- Corrected a licensing issue where Add Missing Earning Codes was activated incorrectly.
Version 23.1.4 Enhancements
- The installation process was updated to use SQL Integrated Security correctly when chosen.
Version 23.1.3 Enhancements
- No enhancements in this release
Version 23.1.2 Enhancements
- Corrected an issue where, for benefit code import records, the Cost Center Override configuration setting was being ignored. This has been corrected to conform to the GL Integration Setup configuration setting.
- Corrected a spurious error: ‘Error generating Crystal Report: The document has not been opened.’
Version 23.1.1 Enhancements (note the version change to align with other products)
- Added a new validation warning message when an earning code is inactive, or its stop date is in the past. The warning does not prevent the posting of the timecard to payroll.
- Added the File Path and File Name to reports and added a variable that enables File Path and File Name to be added to custom reports, as well.
- Added the ability to identify Authorized Users that will be validated using the user currently logged into Windows. Only Authorized users will be able to open the application.
- Added multi-user functionality. Now more than one person at a time can run imports, reports, etc. without affecting other users.
- Added filtering on Company and Code on the Sage Payroll Mapping tab, to better manage translations for larger clients.
- Added support to import benefit deduction enabling the Benefit Arrears import file from HR Analytics
- Added an option to identify a negative PTO balance warning.
Version 10.7.20 Enhancements
- Added a new optional add-on module called Add Missing Earning Codes.
- Added Custom Tabs as a licensable feature to facilitate customization capabilities.
- Added a new validation procedure to identify Inactive employees and prevent posting of timecards for such employees.
- Prevent the reactivation of inactive Time Source Mapping templates when updating T&L features.
Version 10.7.19 Enhancements
- No enhancements in this release
Version 10.7.18 Enhancements
- No enhancements in this release
Version 10.7.17 Enhancements
- Added Embedded links to documentation, release notes, and online forms to request support and submit product suggestions.
- Added support for two new fields, NDBOCDATE1 and NDBOCDATE2, to facilitate importing Non-Discretionary Bonuses.
Version 10.7.16 Enhancements
- Added logic to check if advanced_options and xp_cmdshell are on before the installation process so that we leave them in the same state with the installation process completes. If they were previously on, the install used to process turned them off.
- Added support for SQL Server 2017 CU12
Version 10.7.15 Enhancements
- No enhancements in this release
Version 10.7.14 Enhancements
- No enhancements in this release
Version 10.7.13 Enhancements
- No enhancements in this release
Version 10.7.12 Enhancements
- No enhancements in this release
Version 10.7.11 Enhancements
- No enhancements in this release
Version 10.7.10 Enhancements
- No enhancements in this release
Version 10.7.9 Enhancements
- Added In Product Messaging
Version 10.7.8 Enhancements
- Added check and error message when using Multiple Header Row CSV files.
Version 10.7.7 Enhancements
- Added additional breakpoint during import to allow for custom changes to TimeCardSummary and TimeCardDetail tables.
Version 10.7.6 Enhancements
- Added ability to ignore columns in a CSV file with NO headers.
Version 10.7.5 Enhancements
- Added additional source file column separator values (tab-delimited and pipe ‘|’).
- Added ability to ignore GL Seg column from the import file.
- Added Export/Import function to Time File Structure tab.
- Added Export/Import function to Sage Payroll Mapping tab.
- Allow a user-entered timecard description in the UI
- Added a user-selectable check box to indicate if the timecards being imported should be imported with the “separate check” indicator selected.Added automatic GL Structure creation when importing data.
Version 10.7.4 Enhancements
- Added ability to perform custom SQL procedures after the Post to Sage operation.
- Added ability to support multiple date/time formats in the import file.
Version 10.7.3 Enhancements
- No enhancements in this release
Version 10.7.2 Enhancements
- Automated the database setup and initialization process.
- Reordered tabs to show licensed features first.
- Added webpage to tabs where the feature is not licensed
Version 10.7.1 Enhancements
- Initial release of Sage HRMS Time & Labor
10.7.20 Defect Modifications
| MRID | Description |
| 21121603 | Resolved an issue where existing Time Source Mapping profiles were being reactivated after Time & Labor configuration changes were made. |
| 22032913 | Resolved a problem where if Time & Labor is not licensed, an error referencing Time & Labor files was being displayed in the Log file. |
| 22020344 | Update time import process to treat Inactive employees in the same manner as Terminated employees. The Validation Report will now show such employees as Inactive, and the Post to Payroll operation will prevent the employee’s timecards from posting. |
| 22022871 | Resolved an issue where, when attempting to import Payroll Mappings, the program was non-responsive. |
Previous Version Defect Modifications
10.7.19 Defect Modifications
There were no reported defects in Sage HRMS Time and Labor Import 10.7.19.
10.7.18 Defect Modifications
| MRID | Description |
| 21111974 | The Time and labor import is putting records into the UPTCDO table when the import records do not contain NDBOC dates. |
10.7.17 Defect Modifications
There were no reported defects in Sage HRMS Time and Labor Import 10.7.17.
10.7.16 Defect Modifications
| MRID | Description |
| 19090344 | The initialization process has been updated to correctly work when installing SPU from a server other than the SQL server. |
10.7.15 Defect Modifications
| MRID | Description |
| 20081375 | Fixed issue with initialization script not working. SPs not being updated on install or change of database info. |
10.7.14 Defect Modifications
| MRID | Description |
| 20073055 | Fixed issue with importing of Fixed Format files not working |
10.7.13 Defect Modifications
| MRID | Description |
| 20070715 | Fixed issue on Custom Tabs throwing the error “Could not load file or assembly ‘EPPlus, Version=5.1.2.0” |
10.7.12 Defect Modifications
| MRID | Description |
| 20062398 | SQL Scripts not working when database names start with a number. |
| 20070110 | Update Crystal Reports runtime version to match Sage HRMS 2020 Q2. |
10.7.11 Defect Modifications
There were no reported defects in Sage HRMS Time and Labor Import 10.7.11.
10.7.10 Defect Modifications
There were no reported defects in Sage HRMS Time and Labor Import 10.7.10.
10.7.9 Defect Modifications
| MRID | Description |
| 19011679 | Support In Product Messaging |
10.7.8 Defect Modifications
The following changes were included in Sage HRMS Time and Labor Import 10.7.8.
| MRID | Description |
| 18121079 | Importing of time source data taking over 30 minutes and is usually failing to import |
| 18112153 | transdate & ppenddate not populating during import. |
| 18112152 | Add check and error message when using Multiple Header Row CSV files. |
| 18112150 | Import of Time Source Data failing with error of “failed to convert varchar to decimal” |
| 18112048 | Correct issue where full GL Account number is not being properly built. |
10.7.7 Defect Modifications
The following changes were included in Sage HRMS Time and Labor Import 10.7.7.
| MRID | Description |
| 18101999 | Unable to import cntbase values (pieces, miles, etc.) |
| 18101897 | Add additional breakpoint during import to allow for custom changes to TimeCardSummary and TimeCardDetail tables (similar to the CustomLoad SP). |
| 18101187 | When viewing the Time Card Detail report, the Period End date is not being displayed. |
| 18101186 | When copying an existing Time Source Mapping, the value for “Row containing column names” is not copied. |
| 18101085 | Large values for ‘rate’ or ‘amount’ causing conversion error. |
10.7.6 Defect Modifications
The following changes were included in Sage HRMS Time and Labor Import 10.7.6.
| MRID | Description |
| 18092781 | Import of data is being incorrectly updated. The column ‘amount’ is being updated with ‘rate’ even when an amount exists. |
| 18092074 | Add ability to ignore columns in a CSV file with NO headers. |
10.7.5 Defect Modifications
The following changes were included in Sage HRMS Time and Labor Import 10.7.5.
| MRID | Description |
| 18091871 | Validation report reporting multiple “Employee not found errors for same employee. |
| 18090451 | Allow for additional source file column delimiter values. Tab delimited, and pipe delimited. |
| 18080119 | Error in Validation report is incorrect |
| 18061554 | Add Export/Import function to Time File Structure tab. |
| 18061553 | Add Export/Import function to Sage Payroll Mapping tab under T&L |
| 18050409 | Allow a user entered timecard description in the UI |
| 18050408 | Add a user selectable check box to indicate if the timecards being imported should be imported with the “separate check” indicator selected. |
| 18050407 | Use timecard entry UPDIST.DISTCODE for the earning code to determine the correct GL Structure to be used in creating the GL account for transactions. |
10.7.4 Defect Modifications
The following changes were included in Sage HRMS Time and Labor Import 10.7.4.
| MRID | Description |
| 18070584 | Correct verbiage under View & Post tab, under Post Time & Labor to {Payroll db name} |
| 18070582 | Updates to Validation Report layout |
| 18062976 | Source file headers need to support where there is a space in a column header label. |
| 18062975 | SecJobCode column in source data should not drive to the timecard records “Work Classification” code. |
| 18062974 | Correct Validation Error Report when reporting an Invalid GL Account. |
| 18062973 | Accumulate ALL validation errors in one pass during time source data load. |
| 18062972 | When source file contains a column mapped to PPENDDATE, it is being ignored. |
| 18062766 | Add custom procedure breakpoint after Post to Sage operation |
| 18062060 | TimeSourceData table needs to accept multiple date formats |
| 18062058 | Import file name selection needs to look at any file extension |
| 18062057 | Fixed format file column names are still case sensitive |
10.7.3 Defect Modifications
There were no reported defects in Sage HRMS Time and Time and Labor Import 10.7.3.
10.7.2 Defect Modifications
The following changes were included in Sage HRMS Time and Labor Import 10.7.2.
| MRID | Description |
| 18061552 | Automate SPU database initialization process |
| 18061551 | Modify SPU install script to only install features from licensed products |
| 18042095 | Reorder feature tabs (Time & Labor, Retro Pay, etc.) based on licensed products. |
| 18042094 | Add webpage to tabs where feature is not licensed |