Does somebody have labor distribution report built that they are willing to share. We have crystal on lawson.

Thanks,
Ruma. :lala: :lala:

Ruma,
Yes we use Crystal to generate our labor mgmt reports. Of course there are no standards for labor mgmt reports. What we call labor mgmt may not be what another organization would call them.
I'm willing to share the rpt files.

I'll walk you through it in Crystal:

From the Crystal Report Wizard (the first thing you see when you add a new report in Crystal):

These instructions are based on reporting hours/wages by the department or job they worked in, not the employee's home department.

1) Connect to Lawson database
2) Select the following tables in this order: PRTIME (hours/wages on check), EMPLOYEE, DEPTCODE (department info), JOBCODE (job code info), PAYSUMGRP (pay codes on check)
3) For linking the tables:
- PRTIME.EMPLOYEE --> EMPLOYEE.EMPLOYEE
- PRTIME.DEPARTMENT --> DEPTCODE.DEPARTMENT
- PRTIME.PROCESS_LEVEL --> DEPTCODE.PROCESS_LEVEL
- PRTIME.JOB_CODE --> JOBCODE.JOB_CODE
- PRTIME.PAY_SUM_GRP --> PAYSUMGRP.PAY_SUM_GRP
4) For 'Fields', choose EMPLOYEE.LAST_NAME, EMPLOYEE.FIRST_NAME, PRTIME.HOURS, PRTIME.WAGE_AMOUNT
5) For 'Grouping', choose DEPTCODE.NAME, PAYSUMGRP.DESCRIPTION
6) For 'Summaries', choose PRTIME.HOURS (SUM) and PRTIME.WAGE_AMOUNT (SUM)
7) Skip everything else and click "Finish"

A basic labor distribution report will be displayed. Now arrange it to your liking.

Important Note: Depending on how long you have been live on Lawson, your PRTIME table may contain millions of records which could make the report take a long time to process and even bring your Lawson system down. Be sure to do this in the TEST database first or use stored procedures, indexes, etc. to miminize the impact of running this report.

There are a lot of areas that could cause the totals to be inaccurate including linking tables, record selections, distributed expenses vs. home expenses, etc. Be sure to double check the numbers before you distribute.

Also, this report includes all pay codes, even non-productive, and you may only want to display worked hours. Use the 'Select Expert' to select the PAYSUMGRP.DESCRIPTIONs that you want on the report. This report would also lump all hours/wages together forever. You will want to put in a specific date range such as the last pay period start and stop date.


Feel free to email me if you have any specific questions. Hope this helps get you started.

Aaron Frias
Norman Regional Hospital
afrias@nrh-ok.com