Solution: Setting up an Other pay with a formula that calculates a rate of pay

You can set up regular pay rates for employees in one or both of these ways:

• Setup, Employees, Pays
• Setup, Other tables, Pay rate tables

 

When you enter time, the steps in this solution allow you to retrieve the employee's normal regular rate as the rate for an Other pay type, for example a sick, vacation, holiday, per diem, or travel time pay.

1. Create a formula (Tools, Formulas) to find the rate. Where you set up your regular pay rates determines which formula you need to create.
   Note: You must modify these formulas to match your company setup or they will not work as expected. The variables (pay ID, rate table ID, and rate table criteria fields) must match yours exactly.

    

   Regular Pay rates location	Formula Name	Formula	Notes and variables
   Setup, Employees, [Pays]	Reg_Pay_Rate	IF (Pay Group [PR Check] = "SALARY" , LOOKUP (Amount [PR Employee Pay], Employee [PR Check], 1, "SAL" ) /80, LOOKUP (Amount [PR Employee Pay], Employee [PR Check], 1, "REG" ))	The pay type must be Regular, as desgnated by the 1. Variables: Pay group ID = SALARY Pay IDs - REG and SAL
   Setup, Other Tables, Pay Rate Tables	Reg_Rates_Table	LOOKUP (Rate [PR Pay Rate Table], "REG_RATES" , Employee [PR Time])	Use this formula when the pay rate table has only one criteria selected. Variables: Rate table ID = REG_RATES Rate table criteria = Employee
   Setup, Other Tables, Pay Rate Tables	Normal_Rate_Table	LOOKUP (Rate [PR Pay Rate Table], "NORMAL" , JOIN (Employee [PR Time], Department [PR Time]))	Use this formula when the pay rate table has multiple criteria selected. The LOOKUP formula requires a JOIN for the rate table keys. Variables: Rate table ID = NORMAL Rate table criteria = Employee and Department

    

2. Add the formula to the pay setup.
   1. From the Setup menu, select Pays.
   2. Click [List], select the pay ID (for the Other pay type), and then click [OK].
   3. Press the TAB key.
   4. Select the Pay Type of Other or Reimbursement, as applicable.
   5. Select the Calc Method of Other Units.
   6. Click in the Formula box, and then click List and Select the formula you created in step 1, and then click OK.
   7. In the Calc Method box, select Other Units.
      Note: If this is left as Formula, the rate does not process.
   8. Click Save, then Close.

   Note: Pay rates that use a formula as the basis calculate when you process the check.