Employee Saved Search Reports
The Employee Reports SuiteApp requires SuitePeople HR. It allows access to employee reports that appear as NetSuite saved searches. When customized, the saved searches can be found in a unique Reports menu location. For more information, see SuitePeople Overview
Currently, the Employee Reports SuiteApp supports only US and UK English languages.
Prerequisites
Ensure the required features are enabled to install the Employee Reports SuiteApp (bundle ID 167330). Go to Setup > Company > Setup Tasks > Enable Features.
-
On the Employees subtab, under HR Information System, check each of the boxes for Compensation Tracking, Job Management, and Termination Reason Tracking.
-
On the SuiteCloud subtab, under SuiteScript, check the Server SuiteScript box.
Installation
To install Employee Reports, go to Customization > SuiteBundler > Search & Install Bundles.
Use the following information to search for the SuiteApp:
-
Bundle Name — Employee Reports
-
Bundle ID — 167330
Employee Reports is a managed bundle and is automatically updated. See Installing a Bundle for more information.
Accessing Employee Saved Search Reports
The saved searches installed with the SuiteApp are private. An Administrator must customize the saved searches to define the roles that can access saved searches and their location in the Reports menu. For more information, see Customizing Employee Reports.
Access the following saved searches through their own menu options at Reports > Employees/HR:
|
Saved Search |
Required Feature |
|---|---|
|
Compensation Tracking |
|
|
Compensation Tracking |
|
|
Job Management Compensation Tracking |
|
|
– |
|
|
– |
|
|
– |
|
|
– |
|
|
Compensation Tracking |
|
|
– |
|
|
– |
|
|
– |
|
|
Job Management |
|
|
Compensation Tracking |
|
|
– |
|
|
– |
|
|
– |
|
|
– |
|
|
Termination Reason Tracking |
|
|
– |
|
|
– |
Print and export the saved search results. Exporting is available to Excel, CSV, and PDF. The print and export buttons are at the top of the results list. For more information, see Exporting Search Results.
Use saved search email to share complete search results with other users. See Saved Search Email and Saved Searches.
When any of the Employee Reports saved search returns a single result, NetSuite opens the record if the user has permission to view it. To return search results as a list with only one record in the results, go to Set Preferences > Analytics > Search. Check the Show List When Only One Result box, and then save.
Average Salary by Ethnicity Saved Search
This search lists the average annual base wages of active employees by ethnic group. Results are sorted by ethnic group, average base wage, and employee count. In the results list, click each of the ethnicity name to view more details.
Average Salary by Gender Saved Search
This search lists the average annual base wages of active employees by gender group. Results are sorted by gender group, average base wage, and employee count. In the results list, click each of the gender name to view more details.
Average Salary by Job Saved Search
This search lists the average annual base wages of active employees by job group. Results are sorted by job group, average base wage, and employee count. In the results list, click each of the job name to view more details.
Employee Birthday Report Saved Search
This search lists all active employees with their birth date, age, and other employee details. Results are sorted by birth date and then alphabetically by employee name.
Employee Birthdays by Month Saved Search
This search lists the number of active employees born in each calendar month. In the results list, click the name of each calendar month to view more details.
Employee Roster Saved Search
This search lists all active employees in ascending alphabetical order by last name. Results includes job, supervisor, class, department, location, subsidiary, and country details for each employee. The employee name is linked to the employee record.
Employees by Age Range Saved Search
This search lists the number of active employees by age range. In the results list, click the name of each age range group to view more details.
Employees by Base Wage Type Saved Search
This search lists the number of active employees by base wage type. In the results list, click the name of each base wage type to view more details.
Employees by Ethnicity Saved Search
This search lists the number of active employees by ethnic group. In the results list, click the name of each ethnic group to view more details.
Employees by Gender Saved Search
This search lists all active employees sorted by gender and hire date.
Employees by Hire Date Saved Search
This search lists all active employees by hire date, from the most recent to the least recent date of hire.
Employees by Job Saved Search
This search lists the number of active employees by job. In the results list, click the name of each job to view more details.
Employees With Incomplete Compensation Data Saved Search
This search lists active employees who are missing at least one of the following information in their employee record:
-
base wage
-
base wage type
-
compensation currency
In the results list, the employee name is linked to the employee record.
Employees Without Supervisors Saved Search
This search lists active employees without a supervisor on record. In the results list, the employee name is linked to the employee record.
New Hires (Last 90 Days) Saved Search
This search lists active employees hired within the last 90 days. Results are sorted by hire date, from the most recent to the least recent date of hire. Results are sorted by hire date, from the most recent to the least recent date of hire.
New Hires by Ethnicity (last 12 months) Saved Search
This search lists the number of active employees from each ethnic group who have been hired within the last 12 months. In the results list, click the name of each ethnic group to view more details. In the detailed report, results are sorted by hire date, from the most recent to the least recent date of hire.
New Hires by Gender (last 12 months) Saved Search
This search lists the number of active employees from each gender group who have been hired within the last 12 months. In the results list, click the name of each gender group to view more details. In the detailed report, results are sorted by hire date, from the most recent to the least recent date of hire.
Termination Reasons (Trends) Saved Search
This search lists reasons cited by inactive employees for terminating their employment, and the number of times each reason is cited. In the results list, click the name of each termination reason to view more details.
Upcoming New Hires Saved Search
This search lists employees with hire dates that after the current date. Results are sorted by hire date, job, and location.
Upcoming Terminations Saved Search
This search lists active employees with termination or release dates that are after the current date. Results are sorted by termination date, job, and location.