PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/14/2018 6:34 AM by  JonA
Report for all open requisitions
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Bev Edwards
Systems Analyst
CTG
Veteran Member
(708 points)
Veteran Member
Posts:354


Send Message:

--
06/08/2018 3:19 PM

    Is there a canned report that shows all open requisitions that have not been released to PO23?

     

    We ran a query for all reqs (specified date), with a status of '9', but there are reqs in the data that are showing closed in Lawson.

    JimY
    Private
    Private
    Veteran Member
    (1194 points)
    Veteran Member
    Posts:428


    Send Message:

    --
    06/11/2018 5:09 AM
    You could run a query against the table POINTERFAC. Select those with an ORIGIN_CD of RQ.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2199 points)
    Veteran Member
    Posts:749


    Send Message:

    --
    06/12/2018 10:47 AM
    PO234 is the canned "Show me everything in PO23".
    JonA
    Private
    Private
    Veteran Member
    (2960 points)
    Veteran Member
    Posts:1042


    Send Message:

    --
    06/14/2018 6:34 AM
    Bev, once the req has been released the non-inventory lines are immediately in PO23 unless you have an approval process in place and those reqs/lines are waiting on approval. Is that what you're looking for? Reqs with a status of Needs Approval will have R_STATUS = 1.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.