Use this tab on the Employee Configuration page to map Sage 300 General Ledger account segments cost center codes to employees in Sage HRMS.
Note: This tab displays only if you have Use Cost Center Override is selected on the Payroll Setup G/L Integration window and cost center override is configured for employees. See the Payroll help topic 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 page on the Employee Configuration tab 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 page on the Employee Configuration tab 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 page 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
Example 1: Account segments are set up by departments
- 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.
Example 2: G/L accounts are structured by products
Consider this example for a company that 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.
Mapping Cost Center Codes
- Open the Setup > Payroll > Database Setup > Employee Configuration.
-
Select the Profile ID you previously created, and select the Cost Center tab.
The system updates the table with the Cost Center codes you 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 codes in Sage HRMS.
- Click .
- Repeat the mapping steps for each Profile ID you set up in Employee Configuration.