NOTE: An External Troubleshooting article also exists and directs customers to call Vertex. This article contains the internal solution to fix the error.
While attempting to build a payroll batch, the following error appears:
“Error: Creation of payroll record for Employee #XXXX-Emp Name, 11/17/1858, Job/Acct#, Step # failed with message:
Error calculating earnings: The Pay Code assigned to this step does not have a calculation method set. You can correct this in the Pay Code lookup, where you set up the step.
The payroll batch cannot complete the build and must be aborted.”
This error occurs due to an adjustment that was only partially completed. To fix the problem, you must find and delete the incomplete adjustment record. However, the problem record will not be visible in Adjustment Pay. As a result, the solution requires use of DB Explorer (see Additional Comments if the caller does not have DB Explorer installed).
- Record the employee number from the error message.
- Abort the payroll build.
- Open DB Explorer.
- Click the + sign beside Pathway.
- Provide the SYSDBA password (usually masterkey) and click OK.
- Click the Enter SQL tab in DB Explorer.
- Directly under the Enter SQL tab, in the large entry space, insert the following SQL statement:
select * from employee where emp_number='<employee number from error message>’
- Click the Execute Query button (lightning bolt) on the right side of the window.
- The query should retrieve one record, which will appear in the lower part of the DB Explorer window. Make a note of the employee_ID value for the record.
- Delete the SQL query in the upper part of the window.
- Insert the following SQL statement:
select * from time_records where employee_id='<employee ID>’ and time_payroll_record_type_id = ‘1002’
- Execute the query.
- All pending adjustments for the employee will be displayed.
- If there is more than one adjustment record, compare these records with those showing in the Adjustment Pay subject to determine which record is missing from this subject. This could require significant investigation, as there is no overt indication on the records of which is causing the problem. Additional steps and suggestions will be provided as they become available.
- Once you have determined which record is causing the problem:
- In DB Explorer, Use the Options menu to select Query…
- Check ‘Request live queries’.
- Click OK.
- Rerun the query.
- Click the record you want to delete.
- Click the minus sign at the top right of DB Explorer.
- Click OK to the Confirmation message.
- Close DB Explorer.
- Redo adjustments in Client Payroll Manager as needed.
Attempt to rebuild the payroll.