...
- 1. If you do not already have the report called Regular Pay Item Update in your Report Manager, follow the steps on the Using Report Definitions checklist to down load the Regular pay Item Update.rpd-json file to your desktop then upload into your Report Manager.
- 2. Run the Regular Pay Item Update report in Excel-FieldNames format with the Query Options for the deduction code you are updating.
- 3. Remove any employees that do not need to be updated.
- 4. Update the rate column with the new deduction amount.
- 5. Update the employeeDeductMaxAmount.deductMaxType column with the code type of SpecificDate (other options: Annual or Fiscal)
- 6. Update the employeeDeductMaxAmount.MaxAmount column with the total max amount to be deducted.
- 7. Update the employeeDeductMaxAmount.specificDate column with the date of the first pay date the deduction will be taken.
- 8. Remove all columns except for these 6 columns with these exact headings:
- employee.number
- configuration.code
- rate
- employeeDeductMaxAmount.deductMaxType
- employeeDeductMaxAmount.maxAmount
- employeeDeductMaxAmount.specificDate
- 9. Save the spreadsheet in .csv format.
- 10. Load the file using Utilities/Mass Load with the Importable Entities of: PayrollItem
...