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
SKU Purchase Report by Customer
— SKU Purchase Report by Customer — Note: this report will display the posted date of the invoice, the invoice number, item number (SKU), item description and the exten
Customer Profitability / Cost to Serve Report
— Customer Profitability / Cost to Serve Report — Variables Below … — Set the XXXX in year(docdate) to the desired reporting year — Set the XX month(d
Display Running Gross Sales Numbers for a Period
— Display Running Gross Sales Numbers for a Period — Variables Below … — Replace the XX in month(glpostdt) to the period number you desire — Replace t
Display Customers that Purchased the Same Month they are Created in GP
— Display Customers that Purchased the Same Month they are Created in GP — Variable Below … — Change the XXXX in @Year = to the desired year — Change