Report for all open requisitions

Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member

    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
    Veteran Member
    Posts: 510
    Veteran Member
      You could run a query against the table POINTERFAC. Select those with an ORIGIN_CD of RQ.
      Kat V
      Veteran Member
      Posts: 1020
      Veteran Member
        PO234 is the canned "Show me everything in PO23".
        JonA
        Veteran Member
        Posts: 1162
        Veteran Member
          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 - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          ---