Use the Earning tab on the Employee Configuration window to map earning codes between Sage HRMS and
Mapping Guidelines
Listed below are the most common earning codes along with the recommended settings for each to simplify the mapping process. Before you can map earning codes between the systems, you must set up the earning codes in Payroll on the Earning/Deduction Codes setup window using these guidelines:
Salary Pay
- Category: Earning
- Type: Salary & Wages
- Employee Calculation Method:
- Flat
- Fixed
- Sage HRMS selections include:
- Salaried
- User-defined Employment and Pay fields
Hourly Pay
- Category: Earning
- Type: Salary & Wages
- Employee Calculation Method:
- Hourly Rate
- Amount per Hour
- Sage HRMS selections include:
- Hourly
- User-defined Employment and Pay fields
Bonus Pay
- Category: Earning
- Type: Salary & Wages
- Employee Calculation Method:
- Flat
- Fixed
- Sage HRMS selections include:
- Bonus
- User-defined Employment and Pay fields
Tip: When a bonus is updated in the Open Payroll process, the Ends (date) field on the Employee > Payroll > Pay tab is populated with the payroll Period End Date. This is to prevent the bonus from being paid regularly each payroll period. Because of this, we recommend that you set up a separate Employee Configuration profile for bonuses.
Mapping Earning Codes
- Open the Setup > Payroll > Database Setup > Employee Configuration.
-
Select the Profile ID you previously created, and select the Earning tab.
The system updates the table with the earnings codes you set up in
- Specify the following settings for each earning code set up in Sage 300 Payroll:
- Sage HRMS. Double-click the cells in this column to select from earnings in Sage HRMS.
- Conversion Factor. After specifying the corresponding Sage HRMS earning, the conversion factor defaults to 1.00. You can enter a number here for which the earning rate should be multiplied (or a decimal to divide it).
Dist Code Maps To. Select an organizational level code (such as a Division, Department, Location, or a user-defined code set up in Sage HRMS) for each earning.
Note: You can leave this field blank and instead select a specific distribution code from Sage HRMS with the All Sage HRMS Codes Map to one Dist. Code field.
All Sage HRMS Codes Map To One Dist. Code. Select an organizational level code (such as a Division, Department, Location, or a user-defined code set up in Sage HRMS) for each earning.
After you select the earning in the Sage HRMS column, the program adds a default value (the first distribution code related to the earning in Payroll) here.
- Transfer Default Hour?. Select Yes for the system to update the employee's default hours for this earning. The update passes the Hours/Units from the employee record in Sage HRMS (Job and Pay > Current Pay) and posts to the Default Hours field for the earning on the employee record in Sage 300 Payroll (Pay tab).
- Click .
- Repeat the mapping steps for each Profile ID you set up in Employee Configuration.