How to Configure Split GL Accounts

HOW TO CONFIGURE SPLIT GL ACCOUNTS

ISSUE: Employee with 2 Positions needs to split compensation across multiple GLs. 

Staffing > Position & Assignment

EID xxxx

select EMPLOYEE_ID, EMP_GROUP_CODE, ACTUAL_FTE, JOB_CODE, LOCATION_CODE, POSITION_START_DATE, POSITION_END_DATE, SHIFT_CODE, GL_ACCOUNT_CODE_1, GL_ACCOUNT_CODE_2, GL_SPLIT_1, GL_SPLIT_2 from EC_EMPLOYEE_POSITIONS

where EMPLOYEE_ID = 'xxxx'

and POSITION_END_DATE is null

Note: Ensure that the GL Split %’s total 100% as this must always be the total. 

POS 1:

Additional Note: The GL % field will round to the nearest percentage. 

Example: 33.4 rounded to 33, while 66.6 rounded to 67

POS 2:

Compensation > Salary and Allowances

EID xxxx

select EMPLOYEE_ID, EMP_GROUP_CODE, JOB_CODE, SALARY_START_DATE, SALARY_END_DATE, COMPENSATION_RATE, HOURLY_RATE from EC_EMPLOYEE_SALARY

where EMPLOYEE_ID = 'xxxx'

and SALARY_START_DATE > '2021-06-01'

and SALARY_END_DATE is NULL 

Board Control > General Tables > GL Account Maintenance

select GL_ACCOUNT_CODE, DESCRIPTION_TEXT, RECORD_STATUS, RECORD_ADD_DATE from EC_GL_ACCOUNT

where RECORD_STATUS = 'A'

and GL_ACCOUNT_CODE in ('xxxxxxxxx', 'xxxxxxxxxx', 'xxxxxxxxxx', 'xxxxxxxxxxx')

**All Active

Complete the following before running a Pay to ensure all changes are updated

1. Entitlement
   1. For the relevant group(s)
2. Group Authorization
3. Schedule Groups

Finally, run a Pay and verify the Pay Register and EC_EMPLOYEE_ACCOUNTING table

EC_EMPLOYEE_ACCOUNTING

select * from EC_EMPLOYEE_ACCOUNTING

where PAY_NUMBER = 'PAYNUMBER'

and EMPLOYEE_ID = 'EMP ID'

**ENTITY_TYPE = SALARY splits across ALL 4 GL as expected

Note: ENTITY_TYPE = UI_REBATE, UI, CPP have GL’s defined under a different module, this is as expected. 

(Payroll > Board > CPP, EIC, WSIB, EHT module)