It is sometimes very useful to be able to un-finalize a pay period/Calendar Group while testing and/or debugging. However, there is no online functionality to enable this.
The following SQL Script can be used to reset a Calendar Group. After running the script it is important that you run the “Cancel” process using the online “Calculate Absence and Payroll” component.
Whilst I have never had an issue with this process, I would not recommend applying it to a production environment. And as usual: I take no responsibility for any issues resulting from the use of this process 😉
–Reset Seg Stat table