Queries/Reporting

You cannot currently build a query that shows if an assignment is part of an approved timesheet. We currently have staff that do assignments but dont send them for approval. The timesheet and assignment can still be approved but when reporting the...

When certain numerical data is exported to Excel from Queries, it comes out as a text file e.g. length of service dates and dates/days of birth (e.g. when looking at age). This means that when you try to sort on Excel it does it alphabetical rathe...

The finance team need to be able to print the expense sheet in PDF format for each employee's expenses from clicking the Approved button. Currently they cannot see the whole page unless you scroll down to see all the expense entries, so if you scr...

Create an automated ripple that creates a list of all the employees who show up in a query. One task with the entire list, not multiple tasks with one name. For example - a task saying "update the logbook for x, y, z", when x, y, z are the names w...

Please could there be an option created to only bring back the most recent record on a logbook query. This would make it so much easier to report on something like someones pension record in the logbook section, only bringing back the most recent ...

Add the ability to query on events on a Sunday / weekends / public holidays (according to the public holiday template), not just in the payroll plugin.

It would be cool if you could select a catergory of queries and then have a 'run all' button or if you were able to select a group of queries that you wanted to download at the same time. eg go into Staff List category, select all the queries in t...

I needed a list of employees based in each of our office locations as at a historic date. There's no way of doing this under the current query filter options so it would be great for this to be added.

We would like a report that combines the ATS applicant and employee information. This will enable us to track vacancies filled with the correct information, and remove the need to pull reports then manually consolidate them in Excel. For example a...

Managers receive email notification for time sheets and then approve and make comments. It would be really useful if we could report on comments made by managers re timesheets as currently no one can see it apart from admin or manager.