• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 1
New Member
7/18/2017 4:46 PM
Much appreciated!
Kat V
Veteran Member Send Private Message
Posts: 1020
Veteran Member
7/19/2017 11:53 AM
Also grabbing - Thank you!
brupp
Veteran Member Send Private Message
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.