Query to Catch Wrong Packsize Entry into WMS

Query to Catch Wrong Packsize Entry into WMS

— query to catch wrong packsize entry into WMS
— variables are pack size and warehouse location
— packsize is defaulted to 1
— replace the ‘XXX’ for packsize for the packsize you are searching for
— warehouse maps to site location in GP
— replace the ‘XXX’ for the site location in GP

 select product, zone, binlabel, quantity, packsize, warehouse, user_id, datecreate  from BINLOCAT

where packsize <> ‘XXX’ and warehouse = ‘XXX’

order by product