• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

building a unemployment multiple worksite report in MS Access

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Bridgette
New Member
Posts: 0
New Member
1/31/2009 12:56 PM
Hi

I am new to using Lawson and have not been trained on the software. I am used to using Peoplesoft. I have access to the back tables to run queries in MS Access.

That ebing said,  I was told by Lawson support that there is not a report that will produce this report.  The report need to include a breakdown of the unemployment report breaking it down by worksite location which is the location code located on the HR11 Assignment tab.

The report need to reflect by company, by location the employee count by the 12 (that untilemately equal to the over 3 month employee count thats on the unemployment report. and the taxable wages it reflect.

The information is similar to the PR291 detail but it need to include the location address to put on the form.

Does anyone know if there is an MS Access template I should use or the tables that i can you to get this result.

I am not a Lawson Guru so if you know what i can do please explain in lame terms.

Thanks for your responding to my post.
John Henley
Posts: 3359
1/31/2009 1:56 PM
Hi Bridgette,

Welcome to the Lawson community.

There are a couple of ways you could approach this report:

1. Since you have table access, you can get this data from PAYMASTR (one record per employee/payment)/PRTIME (wage details for each payment)/PRWEEKS (weeks worked by emply/quarter/work state). The location info is in PCODES/PCODESDTL with TYPE=LO. I won't go into the details about how to join it all together. This can be done either with Access or Crystal.

2. Another approach I have used with clients when a Lawson report has most data is to use Crystal reports combined with the Lawson OLEDB (assuming the client has those tools). Using the Lawson OLEDB, the PR291 report is the primary data source for the report and is joined to the PCODES/PCODESDTL table to get the extra data.

John
Thanks for using the LawsonGuru.com forums!
John
Bridgette
New Member
Posts: 0
New Member
1/31/2009 7:25 PM
Thanks. I will try that today with MS Access and see what happens.

Thanks,
Bridgette K Hughes
Medstar Health, Inc. CBO
Tax Analyst
Phone: 410-933-2333
Fax: 410-933-2618



forums-s3-hr-payroll@lawsonguru.com
01/31/2009 10:02 AM

To
bridgette.k.hughes@medstar.net
cc

Subject
Re: building a unemployment multiple worksite report in MS Access
[00005836:00006212]







S3 HR/Payroll/Benefits Forum Notification
A message was posted to a thread you were tracking.
John Henley Posted:01/31/2009 09:56 AM
Subject: Re: building a unemployment multiple worksite report in MS Access


Hi Bridgette,

Welcome to the Lawson community.

There are a couple of ways you could approach this report:

1. Since you have table access, you can get this data from PAYMASTR (one
record per employee/payment)/PRTIME (wage details for each
payment)/PRWEEKS (weeks worked by emply/quarter/work state). The location
info is in PCODES/PCODESDTL with TYPE=LO. I won't go into the details
about how to join it all together. This can be done either with Access or
Crystal.

2. Another approach I have used with clients when a Lawson report has most
data is to use Crystal reports combined with the Lawson OLEDB (assuming
the client has those tools). Using the Lawson OLEDB, the PR291 report is
the primary data source for the report and is joined to the
PCODES/PCODESDTL table to get the extra data.

John

You may reply to this thread via e-mail; please do not remove the message
tracking number from the subject line, and do not include this message in
your reply. To view the complete thread and reply via your browser, please
visit:
https://www.lawsonguru.co...fc/6212/Default.aspx


You were sent this email because you opted to receive email notifications
when someone posted and/or responded to a message on this forum.
To unsubscribe to this thread please visit your user profile page and
change your subscription options.

Thank you,
LawsonGuru.com


CONFIDENTIAL: The information contained in this communication,
including its attachments may contain confidential information and
is intended only for the individual (s) or entity (ies) to whom it
is addressed . The information contained in this communication may
also be protected by legal privilege , federal law or other
applicable law. If you are not the intended recipient of this
communication , you are hereby notified that any distribution,
dissemination or duplication of this communication is strictly
prohibited. If you have received this communication in error please
immediately delete and destroy all copies of this message and
please immediately notify us of the error by separate communication
. Thank you.
Attachments