Payroll Earnings Report Showing Departments Employees Worked In

Hello,

I am trying to figure out how to create a custom Payroll earnings report to show the Department field, hours, and dollars from Payroll Data Entry.  The stock Earnings report does not appear to report this information, only the department defined in the Employee Number.  Is there a stock report that provides this information?  We are required to report hours worked and wages paid for each employee based on the department they worked in, which may or may not be the department defined in their Employee Number.  We use the Department field in Payroll Data Entry to designate the department an employee worked in for a given number of hours in a pay period.  Some employees may work in multiple departments in a single pay period and each department is entered as a separate Earnings line.  Please see below.

Your help would be greatly appreciated.

Thank you,

Brian

  • 0

    If this is not the correct approach, is there a different approach that provides similar results?  I am looking for a report that lists every department an employee worked in along with their hours and wages for a pay period.  Maybe scripting, using the services of a Master Developer, or purchasing an existing enhancement would be possible options?

    Thank you,

    Brian

  • 0

    If you are wanting the information when it is still in data entry, you can have multiple forms of the payroll data entry audit report.  I would suggest creating a new form and have that just include the information you need.

    If you are not familiar with crystal reports your reseller should be able to show you how to get it installed and add the form for customization.

  • 0

    Thank you for this information.  I am somewhat familiar with Crystal Reports.  If possible, we would like to pull the information for an entire quarter or even an entire year.  Can this information be pulled from a history data able?

  • 0

    You can do the same thing where you add custom forms to any of the reports.

    I'm not 100% sure if the department is included in the history report but it should be easy to add either by adding linking to the table or using custom office to add it to the work table the report uses.

  • 0 in reply to Bvulliamy

    Thank you for your help.  I will take this information and see what we can do.