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