Employee Accruals-Import to update Accrual Date

The Accrual Date for over 300 employees was updated in error during the Accrual Update process. User is looking for a way to update these all at once rather than individually.

• Enterprise ERP Payroll

• Employee Accruals

• Import/Export

• Custom Templates

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

1. Navigate to Payroll>Employee Maintenance>Employee Accruals.

2. 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. 

3. Click Accept.

4. Click Excel.

5. 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

6. Click Accept. 

7. In exported Excel file, add a column for Action Flag and populate with U for Update for all lines. 

8. Edit Accrual Date for all employees.

9. Save as Excel or CSV file.

10. Return to Employee Accruals and click Import.

11. Click Custom Templates. 

12. Click Add Template.

13. Enter name for Template, click Browse to pull in saved file, and select checkboxes for First Line Contains Headers and Attempt Field Matching.

14. 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.

15. Click Upload.

16. Once Template has populated, use white dropdown arrows to select any missing column headers.

17. Click Save.

18. Return to Employee Accruals Import screen.

19. Click Define.

20. Select Template and File.

21. Check Skip First Line.

22. Click Accept. 

23. Review Proof for errors.

24. 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.