Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

MSCM Received Not Delivered

 5 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Me
Veteran Member
Posts: 96
Veteran Member
7/17/2017 4: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
    Veteran Member
    Posts: 39
    Veteran Member
    7/17/2017 5: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
      Me
      Veteran Member
      Posts: 96
      Veteran Member
      7/18/2017 4:24 PM
        Thank you Stephanie!  This got us to where we needed to be.
        ddickerson
        New Member
        Posts: 1
        New Member
        7/18/2017 4:46 PM
          Much appreciated!
          Kat V
          Veteran Member
          Posts: 1020
          Veteran Member
          7/19/2017 11:53 AM
            Also grabbing - Thank you!
            brupp
            Veteran Member
            Posts: 165
            Veteran Member
            7/20/2017 2:24 PM

              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.