We're currently using ADP Enterprise 3.0 Autolink. One of the regular payroll audit reports is the ALPAY010 - Active Hourly Employees with No Hours. I'm trying to write this in ReportSmith because I have multiple paygroups (and the Enterprise report only generates one paygroup at a time) as well as I'd like to be able to export the data. I've thought about a Master/Detail report because I want all active hourly employees (JOB table) and any hours for that employee (AL_PDE_HRS_ERN). Any thoughts as to how to write a selection criteria for only those that don't have any hours either because no data was entered in for them (nul hours) or only dollars passed over for them (0 hours)?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.