Formulas to retrieve payroll rates from rate tables

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Information

• You can have an Other, Regular, or Reimbursement pay types retrieve a rate from a Pay Rate Table
• You can either set up a new Pay Rate Table or use an existing table

Create a formula

Create the following formula. Modify it as needed to reflect your pay rate table. In this example, the formula looks at the Union Pay Rate table.

• Formula name: REG RATE TABLE LOOKUP
• Formula: LOOKUP(Rate [PR Pay Rate Table],"UNION",JOIN(Union ID [PR Time], Union Local [PR Time],Union Class[PR Time]))

Use this formula with a Regular Pay Type Pay ID

Select this formula in the Formula field. If you import time entries, you'll see the rate after processing this check. When you use Enter Checks or Enter Time, the rate will retrieve as you enter the time entries. 

Use this formula with an Other Pay Type Pay ID

Select the calculation method of Other Units. Select this formula in the Formula field. If you import time entries, you'll see the rate after processing this check. When you use Enter Checks or Enter Time, the rate will retrieve as you enter the time entries. 

Use this formula with a Reimbursement Pay Type Pay ID

Select the calculation method of Other Units. Select this formula in the Formula field. If you import time entries, you'll see the rate after processing this check. When you use Enter Checks or Enter Time, the rate will retrieve as you enter the time entries. 

How do I set up a pay rate table?