Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Need assistance with Deduction fields used in Lawson DB

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Arun M
New Member
Posts: 1
New Member
4/18/2014 6:52 AM
    Hi Guys,

    I am working on a report for which I have to come up with an Access DB first. And the access DB has to be loaded with data from Lawson DB and attached spreadsheet is the data that I need to be pulling. I need help in identifying which tables I should be using the get the fields that are mentioned in the spreadsheet. Could someone help me out with this. Thanks a lot!! 

    Attachments
    Donna Wirt
    Basic Member
    Posts: 17
    Basic Member
    4/18/2014 11:14 AM
      I updated your spreadsheet but could not provide all tables.  Hope this helps.
      Attachments
      Kelly H
      Veteran Member
      Posts: 167
      Veteran Member
      4/18/2014 11:53 AM
        Arun- are you able to access the forms in Lawson or do you know which form that data is on in Lawson?

        if you can access the form put your cursor in the field you wish to identify. at the same time will give you the name of the table and the field in the bottom left corner. For example if I go to the first name field on HR11 - it will say EMP-First-Name when I do that. Employee table, field: first name.

        Otherwise if you just know the form # for that screen or have screenshots from the form, you can use the Lawson guru table/form dictionary to try and figure out what table may work.

        https://www.lawsonguru.co.../programs/index.html