Crystal Report/ add WC and WC Desc

SOLVED

I'm trying to add the WC and WC Desc to my crystal report and can't find where those fields are. Any help?

Parents
  • +1
    verified answer

    If you want the default WCC Group or Worker's Compensation Code from the employee's Employee Payroll Page > Class/Schd tab, use the table upempl for US payroll or cpempl for Canadian payroll.  The fields are wcc and wccgroup.  For the description you can use a case statement or link to another table for the setup of the code.  I'm not sure what the table for setup is off the top of my head.

    If you want WCC Group or WC code that was processed from payroll, there are different tables you can use depending on the stage of the payroll.  For example, if you want history of WC information from payrolls that have been posted, use table upchkd (US Payroll) or cpchkd (Canadian Payroll).  There are multiple fields that start with wc.  You can right click on the field and browse data before inserting it on your report to make sure it is the field that you want.

Reply
  • +1
    verified answer

    If you want the default WCC Group or Worker's Compensation Code from the employee's Employee Payroll Page > Class/Schd tab, use the table upempl for US payroll or cpempl for Canadian payroll.  The fields are wcc and wccgroup.  For the description you can use a case statement or link to another table for the setup of the code.  I'm not sure what the table for setup is off the top of my head.

    If you want WCC Group or WC code that was processed from payroll, there are different tables you can use depending on the stage of the payroll.  For example, if you want history of WC information from payrolls that have been posted, use table upchkd (US Payroll) or cpchkd (Canadian Payroll).  There are multiple fields that start with wc.  You can right click on the field and browse data before inserting it on your report to make sure it is the field that you want.

Children
No Data