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
  1. Sign into Train or Test environment.
  2. Navigate to Payroll>Employee Maintenance>Employee Accruals.
    1. Click Search and enter Employee Number and Type. 
    2. Make a note of Accrual Date, Start Date and End Dates.
  3. Click History.
    1. Click Search. Enter Employee Number and Type.
    2. Click Accept. 
  4. Click Excel.
  5. Click Select None on Export Filter, then select the following:
    1. Employee Number
    2. Type
    3. Table
    4. Job Class (if using Job Based Accruals)
    5. Start Date
    6. End Date
    7. Used
    8. Used Reason
    9. Earned 
    10. Earned Reason
  6. Open Enterprise ERP Production.
  7. Navigate to Payroll>Employee Maintenance>Employee Accruals.
    1. Click Search and enter Employee Number and Type. 
  8. Click Add and select the Vacation Type, table and enter dates from screenshot.
  9. Click History.
  10. Click Import to create a template and import into accrual history.
    1. Employee Accrual History Import Process
  11. If there is any history missing after the import is complete, manually add records to adjust Available balance as necessary.
    1. Navigate to Employee Accruals.
    2. Click History.
    3. Click Add.
    4. Enter record for Earned or Used time.
    5. 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.