NH ERS - Earnable Salary is 0 for Hourly Employees
Description of Issue
Hourly employees are not pulling Earnable Salary
Context
- Payroll
- New Hampshire
- NH ERS Report
Cause
Earnable Salary comes from the Annual Pay field on the base pay record in Employee Job/Salary for any Job Class code found in earnings history for the reporting period.
Hourly employees affected have a Calc Code 01 on base pay, which doesn't calculate an Annual Pay amount, or allow you to manually key one.
Resolution
Recommended using the Export/Import functionality in the NH ERS Period Record screen to manually calculate an Earnable Salary amount for these employees.Â
- From the NH ERS Period Record screen, select Search
- Enter the Pay Period ID and/or Pay Date to bring back all records for the current reporting period
- Select Accept
- Select Export Data to export the data to Excel
- In Excel, Sort by Earnable SalaryÂ
- When Earnable Salary = $0, enter an Excel Formula to calculate Base Salary * 26
- Highlight all fields with the Formula
- Select Copy
- Select Paste Values
- Select Save
- Return to NH ERS Period Record screen
- Select Import Data
- Select Define
- Select the file you saved in Step 10
- Select Accept
- Select Import to bring the new Earnable Salary amounts into the Period Record
- Create the submission file
Additional Information