PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/20/2017 10:24 AM by  brupp
MSCM Received Not Delivered
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Neil Allen
Supply Chain IS Analyst
Private
Veteran Member
(165 points)
Veteran Member
Posts:81


Send Message:

--
07/17/2017 12:30 PM
    I'm looking to see if anyone has a SQL script they'd be willing to share.  We're trying to put together one that provides everything that has been received but not delivered.  We're struggling with the MSCM tables and was hoping someone else has already put something similar together.
    StephanieD
    Systems Analyst
    Gundersen Lutheran
    Advanced Member
    (93 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    07/17/2017 1:35 PM
    select
    delt.creation_dt receipt_date,
    delt.rcv_user_id receiver,
    delt.receiver_no receipt,
    delt.delivery_ticket_id lawson_tracking,
    delu.tracking_no carrier_tracking,
    loc.location_code,
    loc.name deliver_to_location
    from mscm10.delivery_ticket delt,
    mscm10.delivery_unit delu,
    mscm10.location loc
    where delt.delivery_ticket_id = delu.delivery_ticket_id
    and delt.delivery_location_id = loc.location_id
    and delt.delivery_ticket_type = 'P'
    and delt.delivered = 'F'
    and delt.creation_dt >= sysdate -1
    and delt.delivery_location_id <> delt.recv_location_id
    Neil Allen
    Supply Chain IS Analyst
    Private
    Veteran Member
    (165 points)
    Veteran Member
    Posts:81


    Send Message:

    --
    07/18/2017 12:24 PM
    Thank you Stephanie!  This got us to where we needed to be.
    ddickerson
    Decision Support Systems Specialist
    The University of Kansas Hospital
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    07/18/2017 12:46 PM
    Much appreciated!
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    07/19/2017 7:53 AM
    Also grabbing - Thank you!
    brupp
    Sr. Data Analyst
    UC Health
    Veteran Member
    (303 points)
    Veteran Member
    Posts:127


    Send Message:

    --
    07/20/2017 10:24 AM

    Very helpful - thanks much!!

    Anyone willing to share sql for the error log?  Having trouble with output showing all items instead of just the ones with an insufficient SOH error.  We think we're missing a table.

    You are not authorized to post a reply.