Certain fields in Sage HRMS have the same or similar meaning as fields in Sage 100. The Sage 100 Standard Link automatically links these fields when data is transferred between the two systems.
Other fields must be mapped manually before data is transferred. Field mapping includes benefit plans to deduction codes, organizations to department codes, job codes to labor codes, and absence reasons to earnings codes.
Automatic Mapping
Review the Sage HRMS and Sage 100 Payroll fields that are automatically mapped together. These mappings cannot be changed.
For example, when an employee is transferred from Sage HRMS to Sage 100 Payroll, the values in the City, State, and ZIP Code fields on the employee’s Demographics page are automatically transferred to the City, State, and ZIP Code fields on the Employee Maintenance screen in Sage 100 Payroll. When an employee is transferred from Sage 100 Payroll to Sage HRMS, the reverse occurs.
Note: The Hire Date in Sage 100 Payroll can be mapped to either the Original Hire Date or the Last Hire Date fields in Sage HRMS, and the Review Date in Sage 100 Payroll can be mapped to either the Next Review or the Next Pay Review date fields in Sage HRMS. For more information on mapping these fields, see Map Employer.
Manual Mapping
Before transferring data between Sage HRMS and Sage 100 Payroll, you need to manually map the following:
- Map Benefit Plans to Deduction Codes. The benefit plans (insurance plans and savings plans) in Sage HRMS must be mapped to the corresponding deduction codes in Sage 100 Payroll.
- Map Organization Codes to Department Codes. The organization codes for the Organization Level you selected in Sage HRMS must be mapped to the department codes in Sage 100 Payroll.
- Map Job Codes to Labor Codes. You have the ability to map job codes in Sage HRMS to the corresponding labor codes in Sage 100 Payroll. This step is not required. However, if you have mapped any job codes, we strongly recommend you continue mapping all of the job codes. Mapping only some of the job codes may create undesirable results and is not supported.
- Map Absence Reasons to Earning Codes. The absence reasons in Time Off must be mapped to the corresponding earnings codes in Sage 100 Payroll.
Note: If no specific codes exist at employer level, the system will default to the codes at the enterprise level. So the Sage HRMS codes you see in the drop-down boxes will apply to this situation.