PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/09/2017 4:49 PM by  Kat V
v10 - Requisition Release Date
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
RobJC
Applications Support
RUSD
Basic Member
(14 points)
Basic Member
Posts:8


Send Message:

--
05/05/2017 2: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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    05/09/2017 4: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.
    You are not authorized to post a reply.