Orphaned timecard records can block payroll operations, such as deleting future periods. This guide provides a step-by-step approach to resolve such issues and outlines best practices to prevent them in the future.
Resolving Orphaned Timecard Records
To safely remove an orphaned timecard record using the data-fix utility, follow these steps:
Step 1: Identify the Record (Report Only)
Open the data-fix utility and select the following parameters: - Employee: [EMPLOYEE_ID] - Year: [YEAR] - Period: [PERIOD] - Mode: Report Only
Run the utility to generate a report that identifies the records that would be removed without making changes.
Verify the report: - Ensure it corresponds to the correct company (e.g., your company). - Confirm it identifies the expected check and transaction.
If the report is blank, shows unexpected records, or contains errors, stop and review the full report before proceeding.
Step 2: Remove the Record (Update Data)
If the Report Only mode correctly identifies the unwanted timecard, rerun the utility with the same parameters but select Update Data (Single Transaction) mode.
Ensure you have Super Administrator access enabled for this step.
Save the completed update report for your records.
Return to the payroll system (e.g., Weekly Payroll > Period Maintenance) and delete the future period (e.g., [PERIOD]).
Notes:
A passkey or token is not required for Report Only mode but is necessary for Update Data mode when elevated access is needed.
If the update completes but the period deletion is still blocked, capture the update report and the exact error message for further analysis.
Preventing Orphaned Timecard Records
To minimize the risk of orphaned timecard records and similar payroll errors, follow these operational best practices:
Avoid Overlapping Processes: - Ensure that one payroll or timecard process finishes before starting another. For example, do not restart the "Convert Future Timesheets" process while it is still running or load timecards into the same period during conversion.
Handle Errors Carefully: - If a payroll or timecard process returns an error, save the report or error message. - Avoid repeated retries without analyzing the issue, as this can leave behind orphaned records.
Preserve Processing Reports: - Retain reports from preceding processes to enable faster root-cause analysis and prevent leftover records.
By following these steps and best practices, you can effectively resolve and prevent orphaned timecard records, ensuring smoother payroll operations.