...
There are cases where after a while of entering timesheets (months, or even years) with a specific Week Ending date, the company decides to change their working week days. This means changes on Payroll and changes on the Week Ending Date in Workbench are required. If Upvise is being used, Week Ending dates must be changed there as well.
It 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.
...
Decide dates and direction of the change.
Take a backup of the database before running script.
Open script wbData_ChangeWEDate.sql in Notepadd++ (or any text editor) and edit parameters. Save and then open this script in the CORRECT SQL database.
This is a sample of the parameters that must be configured:
Execute script.
Then populate the statement below with the new Week Ending day, and execute it. Or you can update it using Scaffold on Web Workbench, on the Control table.
UPDATE dbo.control SET WeekEndingDay = 'Friday'Validate Timesheets:
Open existing ones and new ones.
Create new timesheets. Specifically validate the current, past and next week.
Once validation is done, inform users they can log back in.