SELECT DISTINCT ItemCode FROM qcf_orderDetail select * from qmd_stockingGuide where 1=1 AND sku IN () OR stockingStatus IN ('Y','S') order by product, sku SELECT ordhd.OrderNumber, ordhd.OrderDate, mfr.ManufacturerCode, mfr.ManufacturerName, dst.DistributorCode, dst.DistributorName, ordhd.ManufacturerID, ordhd.DistributorID, itm.ItemID, itm.ItemCode, itm.Description, lin.Quantity FROM #ERPDatabaseName#.OrderHeaders ordhd INNER JOIN #ERPDatabaseName#.OrderLines lin ON lin.OrderHeaderID = ordhd.OrderHeaderID INNER JOIN #ERPDatabaseName#.Items itm ON itm.ItemID = lin.Itemid INNER JOIN #ERPDatabaseName#.Manufacturers mfr ON mfr.ManufacturerID = ordhd.ManufacturerID INNER JOIN #ERPDatabaseName#.Distributors dst ON dst.DistributorID = ordhd.DistributorID WHERE 1=1 AND mfr.ManufacturerCode IN () AND dst.Distributorcode IN () AND ordhd.orderdate >= AND ordhd.orderdate <= ORDER BY ordhd.OrderDate DESC, itm.ItemCode SELECT ItemID, ItemCode, Max(OrderDate) LastOrderDate FROM qmd_OrderLines GROUP BY ItemCode, ItemID SELECT Quantity as LastOrderQuantity FROM qmd_OrderLines WHERE OrderDate >= AND OrderDate <= AND ItemCode = ORDER BY OrderDate DESC SELECT SUM(Quantity) as Qty12M FROM qmd_OrderLines WHERE ItemCode = SELECT DISTINCT skuId, sku, skuDesc, prodId, product, productDesc, stockingStatus, packSizeDesc, discontinued, customerSku, Qty12M, LastOrderDate, LastOrderQuantity FROM qmd_stockingGuide ORDER BY product, sku

Set All Status
SKU Status	SKU	Pack	Dst. SKU	12 Mth Qty	Last Ordered	Last Qty
&##160;#htmleditformat( product )# - #htmleditformat( productDesc )#(#lsnumberformat( _skuCount )# skus)
--->	#htmleditformat( sku )# - #htmleditformat( skuDesc )# - #skuId#	#htmleditformat( packSizeDesc )#	disabled="disabled" >	#numberformat(Qty12M, "999,999" )#	#DateFormat(LastOrderDate, "mmm-dd-yyyy")#	#noZero(lsnumberformat( LastOrderQuantity ))#
No SKUs matching the search criteria above were found.

Total Skus: #qmd_stockingGuide.recordCount#

NOTE: Discontinued Sku's are displayed in Red