Skip to content
logo Knowledgebase

Formulas to retrieve payroll rates from rate tables

Created on  | Last modified on 

Summary

How do I create a formula which retrieves the rate of pay on a Pay Rate Table in Sage 300 CRE Payroll?

Cause

 

Resolution

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 or a Regular pay type 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. When entering units to this Regular Pay, you'll see the rate after processing this check.

Use this formula with an Other Pay Type Pay ID

Select the calculation method of Other Units. In the formula field, select this formula from the list. You'll see the rate after processing this check.

 

Need more help?

Chat now

 

 

Related Solutions

How do I set up a pay rate table?