Short Pick Report to Inform Sales of Orders with Short Pick SKU’s

Short Pick Report to Inform Sales of Orders with Short Pick SKU’s

— SHORT PICKED ITEMS
— Query to create a SKU shortage report
— Displays salesperson BATCH attached to the order
— Displays shipper USERID who shorted the item on the order
— Displays the staging location
— Replace the ‘XXX’ for c.stage_loc with your location for orders with short picks
— This report assumes two things:
— #1 is it only shows orders that have started being picked (b.is_started = ‘1’)
— #2 the order has been picked and staged

select b.DATE_CREAT [Order Date], b.BATCH_REF [CSR], b.cust_num [Customer Number], b.ship_name [Customer Name], b.ship_code [Carrier], b.ship_servc [Type of Shipping], b.ship_prov [State], a.PACKSLIP, a.PRODUCT[Item Number], a.DESCRIPT [Item Description], a.QTY_TOPICK [QTY Ordered],a.QTY_PICKED [QTY Picked], b.USERID [Puller], c.STAGE_LOC [Stage Location]

from PICKDETL A

inner join PICKHEAD B on

a.PACKSLIP = b.PACKSLIP

inner join TOTMASTR C on

a.PACKSLIP = c.PACKSLIP

where a.QTY_PICKED < a.QTY_TOPICK

and b.is_started = ‘1’

and c.stage_loc = ‘ XXX’