PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/17/2009 10:52 AM by  Phil Simon
Creating a report from MS Access
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Bridgette
New Member
(5 points)
New Member
Posts:3


Send Message:

--
01/31/2009 8:05 AM
    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.
    Carolyn Lee
    Private
    Private
    Veteran Member
    (151 points)
    Veteran Member
    Posts:53


    Send Message:

    --
    02/11/2009 1:29 PM
    hi, i'd begin by going to the data dictionary to find out what the pr291 references (tech-> data dictionary-> forms) or download off lawson. looks like you'll need to link a few tables to get what you need. the work locat code is in PAEMPLOYEE so link that too. but i think it'll be easier to build via crystal than access.
    Phil Simon
    Private
    Private
    Veteran Member
    (325 points)
    Veteran Member
    Posts:135


    Send Message:

    --
    03/17/2009 10:52 AM

    This one sounds straightforward in either application.  Don't forget the Add-ins/control-shift-o trick to figure out tables and fields if you're new. 

    Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
    You are not authorized to post a reply.