I’m trying to clean up labor operations employees forgot to complete labor transactions on and have since clocked out so they can no longer complete the labor transaction. I’ve found the ‘E’ record in Time and Expense, and historically it was just a matter of clicking submit but I’m getting an error “A Valid Date is Required”. I’m not sure what date it is referring to so not sure where to look. Has anyone seen this before?
1 Like
I had a similar issue and went on a deep dive into this. The error is triggered when the LaborDtl.ClockInDate does not match the LaborDtl.PayrollDate. Specifically, it triggers if the following conditions are met:
- The LaborHed is not active – i.e. the employee is no longer logged in and you are making changes in T&E.
2a. If the LaborDtl.ClockInTime is greater than the ClockOutTime (you went over midnight for third shift), it checks if the PayrollDate is either the same as or one more than the ClockInDate – this allows you to either allocate third shift labor to the clock in day or clock out day.
OR
2b. If the LaborDtl.ClockIntime is less than the ClockOutTime (first or second shift), it checks if the PayrollDate is the same as the ClockInDate.
If condition 1 and either 2a or 2b are met, you get the error. We have BPMs on the Labor.Update method that check to make sure an employee is on today’s LaborHed before allowing them to start a new Production, Setup, or Indirect activity. If they haven’t clocked out on a previous day, they get an error and have to have their supervisor make sure everything is correct before they can proceed.
Is that period/date closed due to Earliest Apply Date?
You are getting the error because the Payroll Date and the Labor Date do not match. In this instance you have to do one of the following:
- You can change the Labor Date to equal the Payroll Date
- You can delete this record and re-enter it on the correct Labor Date.
8 Likes
We have the same thing but the payroll date is not equal to the labor date for the other entries for that person for that day and they approved.
When I try to change the labor date to be the payroll date I get the error Date of 2024-05-02 is less than the earliest apply date of 2024-06-01. Is that due to the fiscal period being closed perhaps?
That’s what I would assume.
It is not the fiscal period being closed. There is a menu for earliest applied date. This is set so transaction can’t be back dated. This allows financial reports to be run so the period can be closed.
The earliest applied date can be set company wide or for individual transaction types.
2 Likes
It’s not necessarily that the period is closed, but someone has changed the earliest apply date, probably because they do not want any transactions from an earlier month in June transactions.
3 Likes