MSI Sync: Add a Payroll Company
Install an additional payroll company to sync with timecards. MSI time is automatically imported into a batch based on the schedule established during installation.
- Log in to the SQL Server where the portal is installed.
- In Object Explorer, expand SQL Server Agent.
- Right-click Jobs and select New Job.
- In the pop-up titled New Job, give the new job a name (ex. ABC-HRIM_MSISyncCo10).
- In the left-hand panel, select Steps.
- Click New.
- In the pop-up titled New Job Step, give the step a name. (ex. MSI Sync Co 10).
- Select the Viewpoint database from the Database drop-down.
- Copy and paste the following into Command: exec KDS_PRMyTimesheetProcessAll @PRCo = [PRCo], @ReturnMessage = null.
- Replace [PRCo] with number of the new payroll company you are adding. For example, if the PRCo is 10: exec KDS_PRMyTimesheetProcessAll @PRCo = 10, @ReturnMessage = null.
- Click OK.
- In the pop-up titled New Job, select Schedules from the left-hand panel.
- Click New.
- In the pop-up titled New Job Schedule, choose a name for your schedule and determine the job frequency.
- Click OK.
- In the pop-up titled New Job, click OK.
- In , locate the new job.
- Right-click the job you just created and select Start Job at Step. This imports current MSI time into the batch. The process typically takes a few seconds to finish.