MSCM Received Not Delivered - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

Me

Veteran Member

Posts: 96

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

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

7/18/2017 4:24 PM

Thank you Stephanie! This got us to where we needed to be.

ddickerson

New Member

Posts: 1

7/18/2017 4:46 PM

Much appreciated!

Kat V

Veteran Member

Posts: 1020

7/19/2017 11:53 AM

Also grabbing - Thank you!

brupp

Veteran Member

Posts: 165

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.