Troubleshooting: "Field value required. ... HOLIDAYTF..."

Note. There are other errors that begin with "Field value required." This article addresses those involving HOLIDAYTF.

Occurrance:
Typically, this error is encountered when you are attempting to freeze pay data.

Cause:
A Department has been deleted that was assigned to one or more Events in the current Pay Period for the Pay Group you are trying to freeze.

Resolution:
Find the Event(s) and reassign to a Department that still exists.

One way to find them is to look through the Events in Bundle-Track. An Event that has been directly assigned (not left to the Employee's Home Department) will list the Department Code. But if that Department has been deleted, the Event will list 'Dept.' without stating the Department Code.

Another way is to run the following query to identify the records, and then use Bundle-Track to correct them.

select EmpMas.EmpMasLab as EmployeeCode, 
WrkDat as WorkDate
from EveCur, EmpMas 
where EveCur.EmpMasKey=EmpMas.EmpMasKey 
and EveCur.ModKey is not null 
and EveCur.ModKey not in (select ModKey from Mod) 
order by EmpMas.EmpMasLab, WrkDat

Prevention:
To avoid this problem, we urge you to never delete Departments; rename them instead to indicate that they are retired (perhaps by putting an 'X' before their name). If you never delete a Department again, you should never encounter this problem again.

If you really want to delete a Department, wait to delete it until it has been unused for longer than your 'Keep Production Detail for _ Periods' setting.

We welcome your comments at support@bundle-track.com.

If you would like our live assistance, you may hire us at our professional services rate.