[BCB:5:Third-party support:ECB]

The formulas provided below are examples using default information. Modify these formulas to match your company setup or they won't work as expected. The variables (pay ID, rate table ID, and rate table criteria fields) must match yours exactly. If you need assistance with modification, contact your Sage Consultant.

Set 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

This solution allows you to retrieve the employee's normal regular rate as the rate for an Other pay type when you enter time. For example a sick, vacation, holiday, per diem, or travel time pay. Pay rates that use a formula as the basis calculate when you process the check.

1. Create a formula (Tools, Formulas) to find the rate.

    

   Regular Pay rates location	Formula Name	Formula	Notes and variables
   Setup, Employees, [Pays] (use if you don't have Pay Rate Tables)	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 designated by the 1. Variables: Salary Hours = 80 Pay group ID = SALARY Pay IDs = REG and SAL
   Setup, Other Tables, Pay Rate Tables (use if you have Pay Rate Tables)	Normal_Rate_Table	Max(Reg_Pay_Rate [Public Formulas], LOOKUP (Rate [PR Pay Rate Table], "NORMAL", JOIN (Employee [PR Time], Department [PR Time])))	Set up the formula for Regular Pay rates above.  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   See more information about looking up Rate Table rates.

    

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.
   7. Select the formula you created in step 1, and then click OK.
   8. In the Calc Method box, select Other Units. If you leave this as Formula, the rate doesn’t process.
   9. Click Save, then Close.