Order Status Report to Inform Sales of Orders that did not Sync with WMS
Order Status Report to Inform Sales of Orders that did not Sync with WMS — Orders in GP but not in WMS — Replace the XXX for a.docid for the different order types withi
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
Blank Phone Number in Pickhead & Tote Master
Blank Phone Number in PickHead — run this to find all orders without a phone number assigned select ship_telno, * from PICKHEAD where ship_telno = ‘ ‘ —
Blank Tote Label in Shipping
Blank Tote Label in Shipping — code to fix a blank tote in shipping caused by scanning error — run this script to idenifty the blank tote select * from TOTEDETL where t
Hot Replenish Error
Hot Replenish Error — code to fix hot replen error — run this script to find the product with an error select * from REPLENIS where product = ‘ ‘ — co
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 default