/
Accidently deleted Employee Accrual Table

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.





Related content

Employees vacation accrual not being earned in payroll
Employees vacation accrual not being earned in payroll
More like this
Missing accrual history for an employee after completing a payroll
Missing accrual history for an employee after completing a payroll
More like this
Employee Accrual History Import Process
Employee Accrual History Import Process
More like this
Search for accrual history after updating an accrual table
Search for accrual history after updating an accrual table
More like this
Employee Accrual History Import to Move Records from one Accrual to Another
Employee Accrual History Import to Move Records from one Accrual to Another
More like this
Accrual Eligibility and Original Hire Date
Accrual Eligibility and Original Hire Date
More like this