Sage 100

 View Only

  • 1.  Workers comp code by employee

    Posted 02-01-2024 15:00

    Where in the new payroll data structure can you find the workers comp code by employee?  Or by paycheck?



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------


  • 2.  RE: Workers comp code by employee

    Posted 02-01-2024 15:39

    Payroll>Reports>Worker's Compensation Report. Print by Check Date Range provides the detail by employee pay check.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Workers comp code by employee

    Posted 02-01-2024 15:40

    Are you trying to set up the employee or report on wages by WC code?

    For employees, it is in the tax code field.  There is a field in PR data entry on the earnings line and the earnings information is written to the PR Employee History detail line (earnings).  Not sure where the WC report pulls from



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 4.  RE: Workers comp code by employee

    Posted 02-01-2024 15:45

    Data is in PR_PayrollHistoryWorkersCompDt



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 5.  RE: Workers comp code by employee

    Posted 02-01-2024 16:08

    The customer wants details of regular vs overtime pay which isn't available on that report so i am trying to create one from the check history report, and it seems to have everything needed except the WC code.

    I don't see it in the Employee table, or EmployeeEarningsHsit  or EmployeeHistory



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 6.  RE: Workers comp code by employee

    Posted 02-02-2024 08:48

    Here is the code for my WC Excel query,  There is a WC field in History detail

    SELECT PR_PayrollHistoryDetail.EmployeeKey, PR_PayrollHistoryDetail.CheckNo, PR_PayrollHistoryDetail.LineType, PR_PayrollHistoryDetail.EarningsCode, PR_PayrollHistoryDetail.WorkersCompCode, PR_PayrollHistoryDetail.Hours, PR_PayrollHistoryDetail.PayAmt, PR_PayrollHistoryHeader.CheckDate, PR_EmployeeListingWrk.FirstName, PR_EmployeeListingWrk.LastName
    FROM PR_EmployeeListingWrk PR_EmployeeListingWrk, PR_PayrollHistoryDetail PR_PayrollHistoryDetail, PR_PayrollHistoryHeader PR_PayrollHistoryHeader
    WHERE PR_PayrollHistoryDetail.EmployeeKey = PR_PayrollHistoryHeader.EmployeeKey AND PR_PayrollHistoryDetail.CheckNo = PR_PayrollHistoryHeader.CheckNo AND PR_EmployeeListingWrk.EmployeeKey = PR_PayrollHistoryDetail.EmployeeKey AND PR_EmployeeListingWrk.EmployeeKey = PR_PayrollHistoryHeader.EmployeeKey AND ((PR_PayrollHistoryDetail.LineType='E') AND (PR_PayrollHistoryHeader.CheckDate>=? And PR_PayrollHistoryHeader.CheckDate<=?))



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------

    Original Message


  • 7.  RE: Workers comp code by employee

    Posted 02-02-2024 16:51

    Paycheck = PR_PayrollHistoryDetail

    Employee = PR_EmployeeTaxFilingStatus (where the TaxGroup is the state your employees are filing in)



    ------------------------------
    Chris St. Amand
    Arizona Accounting & Information Systems
    ------------------------------



  • 8.  RE: Workers comp code by employee

    Posted 02-05-2024 18:11

    Thanks @Jeff Schwenk and @Chris St. Amand!  Report is working.



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------

    Original Message


Related Content