Skip to content
logo Knowledgebase

How do I create a formula which retrieves the rate of pay on a Pay Rate Table?

Created on  | Last modified on 

Description

Cause

Resolution

CAUTION: Sage Customer Support does not assist with issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please get in touch with your Sage business partner, network administrator, or accountant for assistance. Please refer to our Scope of Support document for details.

You can have an Other Pay Type Pay or a Regular Pay Type Pay retrieve a rate of pay from a Pay Rate Table.

You can either setup a new Pay Rate Table or use an existing Pay Rate Table.

Create the following formula, in this example the formula is looking at the Union Pay Rate table.

REG RATE TABLE LOOKUP:

LOOKUP(Rate [PR Pay Rate Table],"UNION",JOIN(Union ID [PR Time], Union Local [PR Time],Union Class[PR Time] ))

If you would use this formula on a Regular Pay Type Pay ID, select this formula on the Formula field. When entering units to this Regular Pay, you'll see the rate after processing this check.

If you would use this formula on an Other Pay Type Pay ID, select the calculation method of Other Units. On the formula field select this formula from the list. You'll see the rate after processing this check.

DocLink: How do I set up a pay rate table?

Chat with support