Adding custom filters to the Authorization search criteria

Default search criteria is displayed in the Authorization drop-down list on the selection parameters page, which filter the selected timesheets based on their authorization status. This lets users search for timesheets with custom criteria. If you have SQL knowledge, you can add custom filters to this list.

  1. Select Maintenance > Payroll Settings > Advanced Payroll Settings > Timesheet Filters.
  2. Click Create New Entry.
  3. Specify this information:
    Name
    Specify the name of the filter. This is the label that is displayed in the Authorization drop-down list on the selection parameters page.
    Description
    Specify a brief description of the search criteria.
    SQL
    Specify the SQL code for this filter. The code is appended with an AND on the end of the timesheet SQL Select statement that retrieves the records for the timesheet.
    Use on Weekly
    Select the check box to allow the Weekly Timesheet to use the search criteria.
  4. Click Save.