Reset Pack List in G2

To reset a packlist in G2, we have to clear out the PAK_HDR_PACKLIST_PRINT_DATE variable in the PAK_HDR table. To do that, there are two options: you can reset the packlist directly in G2, OR you can use TOAD to edit the tables.

To reset the packlist through G2 interface: 

In Glovia go to screen PAK_HDR, enter the Mas_loc, the Packlist number, then press "enter". Then delete PAK_HDR_PACKLIST_PRINT_DATE and click "Save" .

To reset the packlist through TOAD:

NOTE: *** If packlist is for an itemized order and they want to reprint the itemized labels, 

after resetting, the packlist, make sure the itemized lines are not "shipped" yet. 

If it is, then you need to reset the itemized ship Qty to 0, then let them reprint

the itemized labels.  Once they are done, then re-update back the value to itemized ship qty

*/ 

/* Print itemized labels - Order is already shipped */ 

-- reset print date. 

select * from pak_hdr 

where ccn = 'HG0101' and mas_loc = '11' and packlist = lpad('2800645',15) 

-- clear out the paclist print date by setting it to null. Make sure to commit - if update is correct 

update pak_hdr 

set packlist_print_date = null 

where ccn = 'HG0101' and mas_loc = '11' and packlist = lpad('2800645',15) 

--

commit

/*** ONLY DO THIS PORTION IF THE ITEMIZED PACKLIST HAS SHIPPED AND THEY WANT TO REPRINT ITEMIZED LABELS ***/ 

-- check order status 

select * from so_hdr 

where sales_ccn = 'HG0101' and so = lpad('2893661',20) 

-- check itemized header record 

select * from c_soizh 

where sales_ccn = 'HG0101' and so = lpad('2893661',20) 

-- check itemized detail records 

select * from c_soizd 

where sales_ccn = 'HG0101' and so = lpad('2893661',20) 

and c_soizd_ord_qty <> c_soizd_ship_qty 

-- Reset the shipped itemized lines so WHSE can reprint the labels. 

update c_soizd 

set c_soizd_ship_qty = 0 

where sales_ccn = 'HG0101' and so = lpad('2893661',20) 

-- Update ship qty back after WHSE is done printing itemized labels. 

update c_soizd 

set c_soizd_ship_qty = c_soizd_ord_qty  

where sales_ccn = 'HG0101' and so = lpad('2893661',20)