All Position in a Process Level

Sort:
You are not authorized to post a reply.
Author
Messages


upasana











Basic Member



Posts: 20




Basic Member



    Hello,

    Could anyone please help me in writing a query to provide positions with their respective Job Codes in a Process Level using Lawson AddIns. I need this information for various clients.

    Thanks in Advance
    Upasana Mehra


    Woozy











    Veteran Member



    Posts: 709




    Veteran Member



      Just for clarification, are you just wanting to get a list of the positions sorted by the paposition.process-level (i.e. default process-level for the position), or are you wanting a list of positions that are assigned to employees, sorted by employee.process-level (actual employee process-levels)?

      If the former, then this should get you close:

      http://server:port/servlet/Router/Data/Erp?KEYUSAGE=PARAM&MAX=600&OUT=CSV&NOHEADER=TRUE&DELIM=%09&INDEX=POSSET1&NEXT=TRUE&PROD=prodline&FIELD=POSITION%3BJOB-CODE%3BPROCESS-LEVEL&FILE=PAPOSITION&KEY=1

      If the latter, then I think you'd want to do something like this:

       

      http://server:port/servlet/Router/Data/Erp?PROD=prodline&FILE=EMPLOYEE&INDEX=EMPSET1&KEY=1&FIELD=POSITION;JOB%2DCODE;PROCESS%2DLEVEL&OUT=CSV&DELIM=%09&NOHEADER=TRUE&NEXT=TRUE&MAX=600

       

      If you are looking for the later, but with only unique positions within each process-level, then I don't think you can do this with add-ins, though it should be easy enough to filter within Excel.  Of course, there are other folks who might have suggestions about this.

      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      You are not authorized to post a reply.