Get the Packing Slip Number from the Serial Number

jennifer-foster

I am trying to remember how to get the Packing Slip Number in form script when searching by Serial Number.  I am thinking the SLMatltracks is used and then the Pick List Number, but I cannot remember the sequence or fields.  Does anyone know how to do this?

0911060553270289.pdf

jennifer-foster

I found the answer.  Reference below for anyone else that may need this:

IF @PckCall = 'CO-SHIP' AND @IncludeSerialNumbers = 1
BEGIN
INSERT INTO @ReportSet (
pack_num, pack_date, whse, co_num, cust_num, weight, qty_packages
, ship_code, ship_code_desc, drop_num, drop_seq, cast_drop_seq
, office_addr, office_contact, office_phone, ship_contact, ship_addr
, bill_contact, bill_addr, contact
, lcr_num, credit_hold, cust_po, co_line, co_release, cast_co_release
, item, item_desc, item_overview, serial_num
, u_m, qty_ordered, qty_packed, qty_ordered_conv, qty_packed_conv
, cust_item, feat_str
, co_note_flag, co_rowpointer, coitem_note_flag, coitem_rowpointer
, co_bln_note_flag, co_bln_rowpointer
, qty_unit_format, places_qty_unit
)
SELECT
pack_num, pack_date, rs.whse, co_num, rs.cust_num, weight, qty_packages
, ship_code, ship_code_desc, drop_num, drop_seq, cast_drop_seq
, office_addr, office_contact, office_phone, ship_contact, ship_addr
, bill_contact, bill_addr, contact
, lcr_num, credit_hold, cust_po, co_line, co_release, cast_co_release
, rs.item, item_desc, item_overview, serial.ser_num
, rs.u_m, qty_ordered, qty_packed, qty_ordered_conv, qty_packed_conv
, cust_item, rs.feat_str
, co_note_flag, co_rowpointer, coitem_note_flag, coitem_rowpointer
, co_bln_note_flag, co_bln_rowpointer
, qty_unit_format, places_qty_unit
FROM @ReportSet AS rs
LEFT JOIN item ON item.item = rs.item AND item.serial_tracked = 1
INNER JOIN matltrack ON matltrack.track_link = rs.pack_num
AND matltrack.ref_num = rs.co_num
AND matltrack.ref_line_suf = rs.co_line
AND matltrack.ref_release = rs.co_release
INNER JOIN serial ON serial.stat = 'O' AND serial.item = rs.item
INNER JOIN ser_track ON ser_track.ser_num = serial.ser_num
AND ser_track.track_num = matltrack.track_num
END