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: 3
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: 3353
    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: 3
      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