Why can’t I extract zero hour timesheets that were in the COMPLETED status in Unanet?
The time export is derived from the
person_time_data table. If you have no entries on that table, the main export SQL statement will not pick up any entries, and that timesheet does not get included in the export.
In Unanet, attempting to extract a timesheet with zero hours that has been SUBMITTED and COMPLETED leaves the timesheet in the COMPLETED status.
An option is to navigate to Admin > Setup > Time Periods. Edit a time period and selection the check box for ADMIN ONLY ACCESS to close out time periods, ensuring that no one can add hours to historic timesheets.