PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/25/2020 3:26 PM by  Lawsonnubcake
Requisition anomoly
 12 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Lawsonnubcake
Senior Supply Chain Analyst
Private
Advanced Member
(51 points)
Advanced Member
Posts:21


Send Message:

--
02/12/2020 2:16 PM

    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
    Private
    Private
    Veteran Member
    (1053 points)
    Veteran Member
    Posts:367


    Send Message:

    --
    02/12/2020 3:06 PM

    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
    Application Analyst III - Lawson
    Sutter Health
    Basic Member
    (15 points)
    Basic Member
    Posts:5


    Send Message:

    --
    02/12/2020 3:36 PM
    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
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (51 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    02/12/2020 3:49 PM

    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
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (51 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    02/12/2020 4:32 PM

    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
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    02/13/2020 6:14 AM
    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
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (51 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    02/14/2020 12:08 PM

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

    brupp
    Mgr Supply Chain Systems
    UC Health
    Veteran Member
    (371 points)
    Veteran Member
    Posts:161


    Send Message:

    --
    02/14/2020 3:02 PM

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

    Lawsonnubcake
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (51 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    02/20/2020 1:39 PM

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

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2612 points)
    Veteran Member
    Posts:892


    Send Message:

    --
    02/21/2020 9:41 AM
    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
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (51 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    02/21/2020 5:44 PM

    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
    Private
    Private
    Veteran Member
    (3151 points)
    Veteran Member
    Posts:1111


    Send Message:

    --
    02/24/2020 3:41 PM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    Lawsonnubcake
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (51 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    02/25/2020 3:26 PM
    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.
    You are not authorized to post a reply.