Use the Cost Center tab on the Employee Configuration page to map Sage 300 General Ledger account segment cost center codes to employees in Sage HRMS.
Note: This tab only displays if Use Cost Center Override is selected in the Payroll Setup G/L Integration window and cost center override is configured for employees. See the Payroll help topic titled Using Cost Center Overrides for more information.
Mapping guidelines
The segments specified will be used as the default account segments when payroll transactions are posted in General Ledger.
- If account segments are set up by department, the department codes can be assigned to each employee.
- If Use Cost Center Override is not selected, the Cost Center tab on the Employee Configuration page will be hidden.
- If Use Cost Center Override is selected, but None is selected for the Use Cost Center Override in Accounts field, the Cost Center tab on the Employee Configuration page will be hidden.
- In all other situations (when you select Use Cost Center Override and Override Expense Accounts or Override Expense and Liability Accounts), the Cost Center tab will be displayed. Also, you will have a choice to map Payroll segments to Organization Codes from Sage HRMS or to user-defined tables. After selecting an organization code or a user-defined table, you must map each individual segment to the value of the organization code table or user-defined table.
Examples of account segment setups
The department codes are 100, 200, 300, and 400.
G/L accounts are set up as follows for account 6720 Wages and benefits:
- 6720 – 100: Wages and benefits, dept 100
- 6720 – 200: Wages and benefits, dept 200
- 6720 – 300: Wages and benefits, dept 300
- 6720 – 400: Wages and benefits, dept 400
An employee who works in department 100 will be assigned the Department segment code 100, and an employee who works in department 200 will be assigned the Department segment code 200. As a result, when payroll transactions are posted in General Ledger, the 6720 expense account will be overridden with account 6720-100 for all employees who work in department 100 and 6720-200 for all employees who work in the department 200.
A company manufactures desks, chairs, and shelves.
The product line G/L segments are:
- 100 - desks
- 200 - chairs
- 300 - shelves
G/L accounts are set up as follows for account 6720 Wages and benefits:
- 6720 – 100 Wages and benefits, desks
- 6720 – 200 Wages and benefits, chairs
- 6720 – 300 Wages and benefits, shelves
All employees who work in desk production will be assigned segment code "100" in the Product Line segment; employees who work in chair production will be assigned segment code "200", and so on.
To map cost center codes
- Select Setup > Payroll > Database Setup > Employee Configuration.
-
Select the Profile ID that was previously created, and select the Cost Center tab.
The system updates the table with the Cost Center codes set up in
- Select the Map Option and Sage HRMS Field from the drop-down menus.
- Double-click the cells in the Sage HRMS column to select from the list of Sage HRMS codes.
- Click .
- Repeat steps 2-5 for each Profile ID set up in Employee Configuration.