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

    • 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 ...
    • 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 ...
    • 3. HRplus Release Notes 2020 01 03 18th Feb to 23rd Mar 2020

      RELEASE NOTES Release Number:   2020.01.03 (Year.Quarter.Month) Development Periods: 18th February to 23rd March 2020 Release Closed:   23rd March 2020 NOTE:  The numeric ID that is used to identify each item is of no significance to the client and ...
    • 7. HRplus Release Notes 2020 02 04 7th to 30th Apr 2020

      RELEASE NOTES Release Number:   2020.02.04 (Year.Quarter.Month) Development Periods: 7th to 30th April 2020 Release Closed:   30th April 2020 NOTE:  The numeric ID that is used to identify each item is of no significance to the client and is for the ...