Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Approver history in RQC

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Stick_man
New Member Send Private Message
Posts: 4
New Member
4/23/2019 3:47 PM

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
Veteran Member Send Private Message
Posts: 510
Veteran Member
4/24/2019 8: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
New Member Send Private Message
Posts: 4
New Member
4/24/2019 6: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
Veteran Member Send Private Message
Posts: 510
Veteran Member
4/25/2019 9: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
Veteran Member Send Private Message
Posts: 1020
Veteran Member
4/25/2019 12:41 PM
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.