Update Payroll Expense Joining on Employee Roster Article

Update Payroll Expense Joining on Employee Roster Article

update payrollexp

set Field1='FICA', Field2='Medicare', Field3='FUTA', Field8=substring(b.DivisionCode,8,2), Field4=b.Meta3, Field5=b.Meta1, Field7=b.Meta2,

annualsalary=b.JobTitleDesc

from payrollexp a

join employees b on a.EmployeeID=b.EmployeeID



    • Related Articles

    • Employee Roster Tutorial

      PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Purpose: In this form, you will enter your employee roster for each company. Other Related Tutorials & Page Links: * Step by Step Tutorials-Payroll Expense ...

    • Employee Roster Article

          Tutorial Link Print, Export to Excel, Print to PDF, Auto-fit Columns, Filter, Copy and Paste, and Attachments functionality is available.  The following "Right-Click" Menu and Short-Cut Keys: Employees must first be entered in the roster before ...

    • Payroll Assignments Article

      On this screen non-hourly employees/group of employees (as defined on the  Employee Roster) are selected, assigned their salaries (and salary increases), their Budget Account number/s and relevant employer salary expenses (as defined on the Payroll ...

    • Payroll Expense Definitions Article

         Tutorial Link Purpose: The Payroll Expense Definitions window enables you to define employer payroll-related expenses. This feature of the system is optional. Note: A change in Payroll Expense Definitions needs to  “Recalc Payroll Trx” in order to ...

    • Duplicate Payroll Article

          Tutorial Link Purpose: This functionality duplicates core and selected Payroll screens from one BudgetID and paste it into the corresponding screens of the target BudgetID. Note: The core screens of Payroll Expense Definitions, PR Assignments ...