Error: Column 'earn_code' in table 'TK_PostTemp3' cannot be NULL

Error: Column 'earn_code' in table 'TK_PostTemp3' cannot be NULL





This error occurs when a Shift is not linked to a payment rule, an employee is not linked to a shift, or an employee is scheduled to be off but has registered times for the day and was not rescheduled on their correct shift.

To Troubleshoot/Rectify:

1.) Check the Payment Rule Shift Link Report (HRplusTime>>Reports>>Payment Rules Reports>>Payment Rules Shift Link) Link the shifts if necessary.
2.)Check the Employee not linked to shifts Pivot (HRplusTime>>Reports>>Pivots>>Employees not linked to shifts) Link the employee if necessary
3. Review timesheets/scheduling to see if any employee's off day has registered punches and schedule them on the shift for which they have clocked.

    • Related Articles

    • Post Attendance Log to Time sheet Error: Cycle Number cannot be Null EmpTimeClocktimeSheet cannot be null

      ERROR POSIBLE SOLUTION 1. An employee is being put into a pay group for which no pay cycles are generated for the cycle that is being posted. Create the pay cycles for that pay group and then try to post the time sheets to the cycle changes again. 2. ...

    • How to Add a Timesheet Reason

      You may add a Timesheets reason by navigating to HRplus Time>>Timesheets>>Timesheet Reasons>>New Record. There you may enter the: Company to which this reason will be linked Condition to which you would like this new reason linked Reason Code: A Code ...

    • SSO Error Unable to log in.

      Solution The secret key configured in HRplus does not match the secret key on Azure, please look at the azure SSO setup guide to see how to generate the key (Attached)

    • 08. HRplus Release Note 21 June to 22 July 2019

      Release Notes Release Number:        2019.02.06 (Year.Quarter.Month) Development Period:  21st June 2019 to 22nd July 2019 Release Closed:          22nd July 2019 ​ NOTE:  The numeric ID that is used to identify each item is of no significance to the ...

    • 09. HRplus Release Notes 22 July to 9 August 2019

      Release Notes Release Number:        2019.03.07 (Year.Quarter.Month) Development Period:  22nd July 2019 to 9th August 2019 Release Closed:          9th August 2019 ​ NOTE:  The numeric ID that is used to identify each item is of no significance to ...