Map Employers

You must map each Sage HRMS employer to a Sage 100 Payroll employer. When you use the data transfer processes, information will be transferred between the employers you have mapped together.

Tip: You can only map employers in a one to one relationship. That is, you cannot map one Sage HRMS employer to more than one Sage 100 Payroll employer. Similarly, you cannot map one Sage 100 Payroll employer to more than one Sage HRMS employer. For example, if the Sage 100 Payroll employer ABC is mapped to the Sage HRMS employer Dunedin Enterprises (DEU), no other relationship may be established for the ABC employer or the DEU employer.

Using Employer Mapping

  1. From the Sage 100 Standard Link main menu, select Setup > Employer and Code Mapping > Employer Mapping. The Employer Mapping page opens
  2. Click Add. The Employer Mapping Detail page opens.
  3. Select the Sage HRMS Employer from the drop-down list.
  4. Select the corresponding Sage 100 Payroll Employer from the drop-down list.
  5. If you want to use the Sage 100 to Time Off transfer process, select the Interface with Time Off check box.
  6. Click the arrow adjacent to Earnings Types for Benefit Date. The Earnings Types page opens.
  7. Select one or more Earnings Types for Time Off Absence Transactions. Generally, these would include the earnings types of Vacation Pay and Sick Pay.
  8. Click OK.
  9. Each Sage 100 earning code you select for transfer must have a corresponding absence reason code setup in Time Off.
    • In Sage 100, earnings types appear in the Type of Earnings field on the Earnings Code Maintenance screen.
    • To review the earnings codes in Sage 100 and their associated types, select Payroll > Setup and Earnings Code Maintenance, then click the Printer button to print a report.
  10. Select from the Sage 100 Review Date Equals drop-down list to indicate whether you want the Review Date in Sage 100 to equal the Next Review date or the Next Pay Review date in Sage HRMS. Example:
    • Let’s say you select Next Review.When you transfer an employee from Sage HRMS to Sage 100 Payroll, the contents of the Next Review field in Sage HRMS will be used to populate the Review Date field in Sage 100 Payroll.

      If you transfer an employee from Sage 100 Payroll to Sage HRMS, the reverse occurs.

    • In Sage HRMS, the Next Review and Next Pay Review fields are located on the Pay and Performance tab of the Current Pay page.
    • In Sage 100, the Review Date field is found on the Main tab of the Payroll > Main > Employee Maintenance page.
  11. Select from the Sage 100 Hire Date Equals drop-down list to indicate whether you want the Hire Date in Sage 100 to equal the Original Hire Date or the Last Hire Date in Sage HRMS.
  12. In Sage HRMS, the Original Hire and Last Hire Date fields are located on the HR Status page.
    • In Sage 100, the Hire Date field is found on the Main tab of the Payroll > Main > Employee Maintenance page.
    • The Status area of each page in Sage HRMS displays the Last Hire Date next to the employee’s name.
  13. From the Sage HRMS Organization Level drop-down list, select to which Sage HRMS organization level you want to map the Sage 100 department.
  14. Click OK to save your changes and return to the Employer Mapping page. If you need to map additional employers, repeat steps 2 through 11. Remember to map each employer only once.