Payroll: Changing a Started Check Date

ReadyPay has a built in function to change the check date for calendar entries that have not yet been started. If you need to change a check date for a calendarId that has already been started, follow the below steps carefully to update the entered payroll details. When complete, you can delete the old calendar entry or mark it as Skipped.

First, add the new/updated Check Date to the company's Calendar. Add the batches exactly like the incorrect (wrong date) entry. Set it in Payroll and Start Payroll — you want the payroll and batches to have the same statuses.

Update and run the following query to get both the new and old calendarID:

select * from CCalendar where co = 'XXXX' order by checkDate

Next, update and run the following query to get the number of records in the old calendarID. Notate the number of records so you can run the same query after this change date process is complete to ensure all records were transferred over.

select * from epayentry where co = 'XXXX' and checkdate = 'MM/DD/YYYY' and calendarId = 'oldcalendarID'

Finally, update and run the below query to update the calendarID of the applicable check date. You can remove the beginDate and endDate settings if the pay period dates were correct in the old calendarId.

update EPayEntry
set calendarId = 'newcalendarID',
    checkdate = '2015-12-19 00:00:00.000',
    beginDate = '2015-12-19 00:00:00.000',
    endDate = '2015-12-19 00:00:00.000'
where co = 'XXXX'
  and calendarId = 'oldcalendarID'
  and calcflag = 'U'