Troubleshooting OT Shift Rate GL Issues

ISSUE: Whenever a board inputs a timesheet in portal using an Overtime Code, upon saving and checking EC_WEB_TS_TRANS table it is automatically showing wrong GL. System displays default Position GL instead of retaining the SHIFT CODE GL. 

 

Staffing > Position & Assignment

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

where EMPLOYEE_ID = 'xxxx'

and POSITION_END_DATE is null

POSITION1 GL = xxxxxxxxx6706

POSITION2 GL = xxxxxxxxx6700

Position ID 1 = 139 

Position ID 2 = 140

 

OPC > Position Control

select POSITION_ID, EMP_GROUP_CODE, POSITION_APPROVED_FTE, JOB_CODE, LOCATION_CODE, POSITION_EFFECT_DATE, POSITION_TERM_DATE, SALARY_CATEGORY_CODE, GL_ACCOUNT_CODE_1, REPORTING_POSITION_ID from EC_POSITIONS

where POSITION_ID = '139'

POSITION1 GL = OPC1 GL

 

OPC > Position Control

select POSITION_ID, EMP_GROUP_CODE, POSITION_APPROVED_FTE, JOB_CODE, LOCATION_CODE, POSITION_EFFECT_DATE, POSITION_TERM_DATE, SALARY_CATEGORY_CODE, GL_ACCOUNT_CODE_1, REPORTING_POSITION_ID from EC_POSITIONS

where POSITION_ID = '140'

POSITION2 GL = OPC2 GL

 

Payroll > Group Data > OT and Shift Rates

select OVERTIME_CODE, EMP_GROUP_CODE, OVERTIME_START_DATE, OVERTIME_END_DATE, EXPENSE_ACCOUNT_CODE from EC_OVERTIME_RATES

where OVERTIME_CODE = 'O/T'

and EMP_GROUP_CODE = 'xxxxx'

and OVERTIME_END_DATE is null

SHIFT CODE GL = xxxxxxxx04400

 

K212 Timesheet Entry:

Payroll > Pay Inputs > Timesheets > Hourly Rate > EMP_GROUP + Pay Number + EID > Find

Enter Timesheet > Ensure there is an entry where Earning Code = Overtime Code > Save

Batch Post and Reverse > ‘BATCH’ > P > Save

Process > Completed > Timesheet Post Report

Note: Ensure “Account” report field = OT Shift Rate GL

 

Portal Timesheet Entry:

Portal > Timesheet Entry > Save

Note: Once the user changed the Earning Code from REGPAY to ‘OT’ Overtime Code, note the GL does not automatically update following the Earning Code change. 

Additional note: This will be fixed in an upcoming patch, but it is always worth double checking. 


Portal > Timesheets

select EMPLOYEE_ID, EMP_GROUP_CODE, PAY_NUMBER, WORK_DATE, DAYS_WORKED, OVERTIME_CODE, GL_ACCOUNT_CODE from EC_WEB_TS_TRANS

where EMP_GROUP_CODE = 'xxxxx'

order by WORK_DATE desc

 

Table shows wrong GL because the GL does not automatically update to the Over Time GL from the pre-populated REGPAY Position GL.