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. ...

    • HRplus Time Workflow

      HRplus Time Workflow Overview The workflow in HRplus Time refers to the approval of Timesheets and allows you to: • set up a maximum of ten (10) sequential approval stages (Levels 1 to 10) and a minimum of two (2) (Levels 1 to 2). • link EACH of ...

    • HRplus Time (Setup - Time Constants)

      ‌Time and Attendance Updates: What's New? This article provides a summary of recent updates to the HRplus Time and Attendance modules, focusing on key enhancements. These updates include new features, fixes and improvements designed to improve both ...

    • HRplus Time (Setup - Timekeeping Workflow)

      ‌Setup - Timekeeping Workflow ‌HRplus Time Workflow Overview The workflow in HRplus Time refers to the approval of Timesheets and allows you to: set up a maximum of ten (10) sequential approval stages (Levels 1 to 10) and a minimum of two (2) (Levels ...

    • 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 ...