...
There are times that cases where after a while of entering of entering timesheet timesheets (months, or even years) with a specific Week Ending date, the company decides that the last day of the week needs to changeto change their working week days. This means changes on Payroll and chnages on the Week Ending Date in Workbench are required.
This is a significant change and needs to be discussed with Consultants or Workbench Support, as it is not a minor process and can have a big impact if not done properly.
There is a script that can be used to chnage change the dates.
Considerations:
When this script is about to be run no one should be entering or editing Timesheets (including reviews, approvals, exports to financials), because there will be validation rules temporarily disabled when this script is run (triggers disabled).
Is recommended that the script is run when no other uses are using the application, as it is run in a SQL transaction, and this blocks any actions where the users might be traying to save data to the database.
If not all historic Timesheets data has Week Ending Dates updated, those previous Timesheets won’t be accessible from Timesheet screens and anywhere where the data is displayed based on a WeekEnding date, because the system will use the new WeekEnding newly define din defined in the Controls table, which does not match the original week ending dates.
Timesheets that were possibly exported in Payroll, will now how a different weekending date than week ending date in Workbench compared to what it is on the financial Payroll system (timesheets exported).
Consider that depending on the direction of the change (example: current week ends on Sunday, but we are moving the week to finish earlier, on the Friday of the current week; this is 'Back'), the Payroll Admin might need to make manual changes for the current week on the Payroll system.
...