Requisition anomoly

Author
Messages
Lawsonnubcake
Advanced Member
Posts: 25
Advanced Member

    Users statement is listed below...

    "REQ ******* was placed and never populated to a PO for company ****. Now this REQ is closed, but we have no information on why this would of closed. Please review req ******* and inform us why this didn't process"

    I have researched the obvious areas, RQ10, RQ44, RQC to recreate the req. in test environment. Does anyone know how a req would be released, never make it to a PO, and then the req get closed?

    Ragu Raghavan
    Veteran Member
    Posts: 468
    Veteran Member

      Is it possible somebody Rejected the req? What value does the field reqheader.status have?
      0 = Unreleased
      1 = Released
      5 = In Process
      9 = Processed
      8 = Rejected

      Jay S
      Basic Member
      Posts: 6
      Basic Member
        Check the Requisition line (via RQ10) for a PO Worksheet Cancellation Audit Record. This would mean that a user cancelled the line in PO23.
        I've also seen a Requisition close if it *did* make it to PO but the PO line was edited (changing item/description for a special type line).
        Lawsonnubcake
        Advanced Member
        Posts: 25
        Advanced Member

          Sorry I'm not seeing a field within the Header that points to the numbers you posted. What I do see everywhere I Drill Around is below...

          Requesting Location: 5111 MICROBIOLOGY
          Transaction Type: Issues
          Status: Processed Closed Flag: Yes
          Creation Date: 01/21/2020 Time: 10051300 Operator ID: rquser
          Released Date: 01/21/2020 Time: 10081600 Operator ID: rquser
          Processed/Rejected Date: 01/21/2020 Time: 10081600 Operator ID: rquser
          Return Notes:
          Approval Type: No approval required
          Approval Code:
          Header Source: RQC

          Lawsonnubcake
          Advanced Member
          Posts: 25
          Advanced Member

            Also, we don't utilize an approval process so this req would've shot straight to PO23 - which never happened, and the req closed.

            JimY
            Veteran Member
            Posts: 510
            Veteran Member
              Were the items inventory items that would have been issued from your Warehouse? If so then a PO wouldn't have been created. The req would have been processed through WH130 most likely.
              Lawsonnubcake
              Advanced Member
              Posts: 25
              Advanced Member

                Sorry, I should've stated that this is a special req.

                brupp
                Veteran Member
                Posts: 165
                Veteran Member

                  Did they enter a vendor?  Not sure if you have this required in RQ04 or not.

                  Lawsonnubcake
                  Advanced Member
                  Posts: 25
                  Advanced Member

                    Yes a vendor was set in the req. Also rq04 for the requester is flagged to require vendor.

                    Kat V
                    Veteran Member
                    Posts: 1020
                    Veteran Member
                      It's likely too late - but do you still have the PO100.err report? That might show if it was "still there" - at least letting you know that it made it to PO23 at one point.

                      (I just had to cancel 3 lines off of PO23 and no where on RQ10 Item or Item Drill Around can I find a PO Worksheet Cancellation Audit record. What version of Lawson is this on?)

                      Lawsonnubcake
                      Advanced Member
                      Posts: 25
                      Advanced Member

                        That's a good thought with the PO100.err. We will be looking to see if that still exists from January and if not we're about to throw in the towel. Couple weeks ago I had an Infor ticket open for a similar incident and they threw in the towel after a week and a half.

                        Lawson version 10.0.9.0

                        JonA
                        Veteran Member
                        Posts: 1162
                        Veteran Member
                          We see this on occasion where the req closes and there's no PO line and no worksheet cancel quantity. A couple times I've been able to determine that the item was added to a PO and then the buyer made changes to the item number which severed the link back to the req. But most of the time I was unable to determine what happened.
                          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                          Lawsonnubcake
                          Advanced Member
                          Posts: 25
                          Advanced Member
                            So the PO100.err isn't available for the date in question. I think it's time that Rocky throw the towel to save Apollo. Thank you all for the suggestions and thoughts on where to look.
                            ---