Versions Compared

Version Old Version 1 New Version 2
Changes made by

Knowledge Assistant

Knowledge Assistant

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

The option for, Change Year on Accrual Date in Employee Accruals, was checked when the Accrual Update was processed, which updates the year on the Accrual Date based on Effective Date year defined during Accrual Update. 

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

Recommended to do in Test or Train first and review results:

  • Navigate to Payroll>Employee Maintenance>Employee Accruals.
  • Click Search and enter criteria for Employee Accrual records that will need to be updated.
    1. Ex, search on Employee Number, Active Status, Active checkbox, Type and/or Table. 
  • Click Accept.
  • Click Excel.
  • Use Export filter to select following fields:
    1. Employee Number
    2. Type
    3. Table
    4. Accrual Date
    5. Start Date
    6. End Date
    7. SOY Balance
    8. Used YTD
    9. Earned YTD
  • Click Accept. 
  • In exported Excel file, add a column for Action Flag and populate with U for Update for all lines. 
  • Edit Accrual Date for all employees.
  • Save as Excel or CSV file.
  • Return to Employee Accruals and click Import.
  • Click Custom Templates. 
  • Click Add Template.
  • Enter name for Template, click Browse to pull in saved file, and select checkboxes for First Line Contains Headers and Attempt Field Matching.
  • File Delimiter depends on file format.
    1. If using Excel file, leave set to None. 
    2. If using CSV file, use dropdown to select Other and enter Comma (,) in field to the right.
  • Click Upload.
  • Once Template has populated, use white dropdown arrows to select any missing column headers.
  • Click Save.
  • Return to Employee Accruals Import screen.
  • Click Define.
  • Select Template and File.
  • Check Skip First Line.
  • Click Accept. 
  • Review Proof for errors.
    • Return to Employee Accruals Import screen. Prompt will show Do you want to continue importing these records? Click Yes to complete the Import or No to cancel.

    It is not recommended to do the Accrual Balance Import (which is used to import new balances into the Header Record) to update Accrual Date in Employee Accruals. It can incorrectly adjust the Employee Accrual History.

    The options are:

    • Manually update each Employee Accrual record  to the correct Accrual Date.
    • Reach out to Payroll Support to see if there is a scripting option to set the Accrual Date to be equal to the Service date from Employee Master. 
    Panel
    borderColor#03396c
    titleColorWhite
    titleBGColor#03396c
    titleAdditional Information


    ...