PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/25/2019 8:41 AM by  Kat V
Approver history in RQC
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Stick_man
Data Integrity Manager
Private
New Member
(8 points)
New Member
Posts:4


Send Message:

--
04/23/2019 11:47 AM

    Does anyone know how to obtain Approver historical information. Specifically, if there is anywhere I can find an old req and who the approver was. The point being if an Approver approved a very large dollar requisition.

     

    I use MS addins. But I have some coding ability (even though I never coded in Lawson).

    JimY
    Private
    Private
    Veteran Member
    (1354 points)
    Veteran Member
    Posts:482


    Send Message:

    --
    04/24/2019 4:46 AM
    If you are using IPA to handle approvals you can use Sql to pull information from the PFIMETRICS and PFIWORKUNIT tables in the IPA database.
    Stick_man
    Data Integrity Manager
    Private
    New Member
    (8 points)
    New Member
    Posts:4


    Send Message:

    --
    04/24/2019 2:41 PM
    I almost can't believe you can't use a queries in MS addin to simply pull the approvers on a req. Or to obtain a list of reqs where approver is one of the fields.
    JimY
    Private
    Private
    Veteran Member
    (1354 points)
    Veteran Member
    Posts:482


    Send Message:

    --
    04/25/2019 5:04 AM
    Since we went to Version 10 we have had to pull that information from the Landmark side. Since MS Addins works with the LSF side you can not use it. You might be able to use Spread Sheet Designer, but I haven't used it much so I couldn't comment on how to do it.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2477 points)
    Veteran Member
    Posts:845


    Send Message:

    --
    04/25/2019 8:41 AM
    Add-Ins is an older product and is for the S3 module. To query from Landmark is Spreadsheet Designer but it works in a similar fashion to add-ins. That's how we get our req approval queries and uploads done for process flow.
    You are not authorized to post a reply.