Open navigation

Formulas: Troubleshooting During Payroll

Do you have a formula that is not producing the expected results? Payroll Administrators can now see the details of their formula calculations when processing pay runs for each employee, including the value of each variable and the results of each line.

Before You Start Using Show Formula Details

We recommend selecting one employee to process pay when using Show Formula Details. Running pay for multiple employees may decrease performance, depending on the number of formulas in your company and the complexity of formulas. It will also produce an extremely long results listing.

Prior to using Show Formula Details, please identify:

  • An employee that does not have the expected results from the formula.

  • The Earning or Deduction/Benefit Code with the formula that is not producing the desired results.

  • The Payment Date and the Pay Ending Date.

How to Show Formula Details

Step 1: Open Process Pay Run in the Avanti Desktop Application.
By default, this can be found in Canadian Payroll >> Payroll Processing.

Step 2: Select Process One Employee.

Step 3: Enter the employee number in Employee.

Step 4: Select the Payment Date and Pay Period Ending.

Step 5: Select Show Formula Details, then select OK.

Step 6: The variable values and the result of each formula line will display in the Progress section. When reviewing the details, we recommend printing Process Pay Run to be able to view the results more easily.

Print

Step 1: Without closing Process Pay Run, select Print.

Step 2: Select Print Preview to display the Results.

Additional Information
If Print Preview is not displayed, select any available Printer on the Printer Setup tab. Now Print Preview will show.

Step 3: Locate the Earning or Deduction/Benefit Code with the formula that is not producing the expected results.

Step 4: Compare each line and variable in the formula to identify the issue, then update the formula or employee information as needed.

  • The value for each variable in each line will display.

  • The value of each line used in the formula will display.

Additional Information
We recommend having the formula open when reviewing the formula results, for easier comparison.

Still having formula issues? We’re here to help! Please contact Client Care, for additional assistance.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.