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)