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.

You must be a system admin to perform the following steps.
  1. Log in to the SQL Server where the portal is installed.
  2. In Object Explorer, expand SQL Server Agent.
  3. Right-click Jobs and select New Job.
  4. In the pop-up titled New Job, give the new job a name (ex. ABC-HRIM_MSISyncCo10).
  5. In the left-hand panel, select Steps.
  6. Select New.
  7. In the pop-up titled New Job Step, give the step a name. (ex. MSI Sync Co 10).
  8. Select the Viewpoint database from the Database dropdown.
  9. Copy and paste the following into Command: exec KDS_PRMyTimesheetProcessAll @PRCo = [PRCo], @ReturnMessage = null.
  10. 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.
  11. Select OK.
  12. In the pop-up titled New Job, select Schedules from the left-hand panel.
  13. Select New.
  14. In the pop-up titled New Job Schedule, choose a name for your schedule and determine the job frequency.
  15. Select OK.
  16. In the pop-up titled New Job, select OK.
  17. In Object Explorer > SQL Server Agent > Job, locate the new job.
  18. 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.
If errors occur during the final step, create a case in the Viewpoint Customer Portal under Viewpoint HR Management for additional assistance.