GL90 Drill to payments

 3 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Margie Gyurisin
Veteran Member
Posts: 538
Veteran Member
    We are creating a new role for someone to be able to drill back to payment information from the GL90. We have been able to get the payments to appear, but they can not see employee names. We have given them PR51 form access and they can see names on that form but they can not select an employee from the search box???

    We have given them acces to all the tables that the PR51 references - EMPLOYEE, PRSYSTEM, PAYMASTR, PRTIME etc.

    Do we need to add some invoked program? If so, which one(s)?

    I have attached a screen shot to show you an example.

    Any help would be most appreciated.

    Thanks.
    Attachments
    Arvin Ojales
    Advanced Member
    Posts: 24
    Advanced Member
      That feld is coming from FULL-NAME from the EMPLOYEE file. Are you using LAUA or LS? If using LAUA and the 'Access' field in RM is set to 'N' this will prevent them to see other employee information except their own employee and direct report's (if manager) record. If you're using Lawson Security check all the security class rules (for EMPLOYEE table) that are attached to the user roles.

      Arvin Ojales
      Margie Gyurisin
      Veteran Member
      Posts: 538
      Veteran Member
        We are using LS9. We have granted access to all the "name" fields we can find in the EMPLOYEE table. We can not find the field name called FULL NAME in the employee table. My security admin is now going to grant full access to the table and then write rules on every field either granting or denying them to see if that helps. We are open to other ideas.

        Thank you for responding.
        John Henley
        Posts: 3353
          It's a derived field in the EMPLOYEE table. Couple of things you can look at: 1) Make sure the user has access to all the fields that make up the derived field (last name, first name, middle name, middle initial, prefixes, suffixes, etc.). 2) Look at the ELEMENTS used to define the FULL-NAME (an interesting topic in and of itself)...you'll have to dive into dbdef to see which ones are used: FULL-NAME, LAST-SUF, LAST-PRE-SUF, etc.
          Thanks for using the LawsonGuru.com forums!
          John