Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

v10 - Requisition Release Date

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
RobJC
Basic Member
Posts: 8
Basic Member
5/5/2017 6:23 PM

    Is there a table that tracks all of the requisition release dates? When I view the REHEADER and REQLINE tables I only see the latest and greatest. We use custom workflows for our procurement, and there are times when requisitions are released and returned for edits. Then re-released for approvals. I think I may have found something in the PFIWORKUNIT table, but I wanted to get a different perspective on this issue. Thank you.

    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    5/9/2017 8:49 PM
      Not that I know of, in v10 there is a lawson.rqaudit table, you may try there. You can see it in query wizard.

      For what it's worth, our IPA creates a comment when the workunit is created with the workunit number. We can tell when something's been unreleased and re-released by that comment trail. It would have multiple workunits.