Accidently deleted Employee Accrual Table
Description of Issue
User accidentally deleted out an employee's vacation accrual table and history is gone.Â
Context
- Enterprise ERP
- Employee Accruals
- Employee Accrual History
- EERP TrainÂ
- EERP Test
Cause
Resolution
- Sign into Train or Test environment.
- Navigate to Payroll>Employee Maintenance>Employee Accruals.
- Click Search and enter Employee Number and Type.Â
- Make a note of Accrual Date, Start Date and End Dates.
- Click History.
- Click Search. Enter Employee Number and Type.
- Click Accept.Â
- Click Excel.
- Click Select None on Export Filter, then select the following:
- Employee Number
- Type
- Table
- Job Class (if using Job Based Accruals)
- Start Date
- End Date
- Used
- Used Reason
- EarnedÂ
- Earned Reason
- Open Enterprise ERP Production.
- Navigate to Payroll>Employee Maintenance>Employee Accruals.
- Click Search and enter Employee Number and Type.Â
- Click Add and select the Vacation Type, table and enter dates from screenshot.
- Click History.
- Click Import to create a template and import into accrual history.
- If there is any history missing after the import is complete, manually add records to adjust Available balance as necessary.
- Navigate to Employee Accruals.
- Click History.
- Click Add.
- Enter record for Earned or Used time.
- Click Accept.
Additional Information
Importing into employee accrual history you cannot import the Munis assigned codes such as 8,10. Those codes in the import will need to be changed to 1 or 2 Accrual Earned or Accrual Used.
This solution will only work if Test or Train have not been refreshed since the delete was performed. If there is no non-prod environment that has not been refreshed since that time, please contact Payroll Support for further assistance.