Duplication of Hours will occur easily if transactions are uploaded more than once. This happens if:
- You accidentally upload the transactions more than once in the Excel upload or with the GP Connector
- If you see this error on the transaction upload “Employee Not Found…” beware! Do NOT uploaded transactions before you uploaded Employees SUCCESSFULLY. In this situation, the cloud solution is saying we cannot find an ID to attach these transactions. The fix is to upload the employees successfully every time before you upload transactions. That way the new hires will be in the system and a transaction upload error for these employees will not occur.
You need to know the following about situation 2: All the other employee transactions that were not in error did go in and duplication of hours is possible with the next upload. This will occur when you upload the entire corrected employee file the second time. **Notice this is different from an erred Employee File. When an error occurs with an Employee file, the entire upload is stopped until you fix it and re-upload.
To see if you have duplicated hours, go to the Alerts and Reports/ACA Reports/Employee/Monthly Hours Breakdown and pull up the year that was uploaded giving that error. Look on that report for the month or months that the duplication started. For a FT Salaried employee the month should show 160 hours except for 2 months that show 240.
A new and simpler way of deleting whole batches of erred duplicate uploads is found in KB14-078.
The other way of filtering to find the erred range of transactions that did go into the Cloud is to go to Maintenance/Transactions and filter for the Check Date or Start Date of when the duplication began. Delete all Viewable Records. See below. Then re-upload, first employees, then, transactions with the Spreadsheet or GP Connector beginning when you deleted.
The Step-by-Step fix on the Cloud for duplication of your hours through the transactions upload is as follows:
- On the Cloud Solution go to Maintenance/Transactions.
- Filter for that check date or start date that was uploaded more than once.
- Change the “Display a maximum of” to more than the total transactions
- DELETE ALL VIEWABLE RECORDS on the blue line.
- Re-upload the transaction file (after a successful employee upload)
For example: If you filtered “is equal to” 8/18/2017, then those are the transactions that went into the Cloud for that duplicated upload. You will need to Delete All Viewable Records (the white letters on the long blue line) because you do not want to duplicate hours when you re-upload the 8/18 check date (after uploading employees).
Another example of a larger range of duplicated transactions needing deleted is below. Deleting From after 3/1/2017 To the present.
Questions / Resources
If you have questions or comments please email Support@integrity-data.com.
If you would like to search for information and resources for Integrity Data products check out the following sites:
- Knowledge Base: https://www.integrity-data.com/knowledge-base/
- Videos: https://www.integrity-data.com/video-library/
Last Review: 10/17/2017 – Revision: 1.0
Applies To: ACA Compliance Solution
Categories: Import of Data
Keywords: Deleting, Duplicated