I have a SQL statement like the below, that i want to incorporate into a Grid FORM:
SELECT
T.ITEMID AS [PRODUCT ID],
T.NAMEALIAS AS [SEARCH NAME],
T1.NAME AS [PRODUCT NAME],
CASE
WHEN L.WMSLOCATIONID IN ('HISTORY', 'CROSSDOCK', 'PACKING') THEN 0
WHEN D .INVENTSTATUSID <> 'AVAILABLE' THEN 0
ELSE S.AVAILPHYSICAL
END AS [AVAILABLE PHYSICAL],
M.PRICE AS [PRICE PER ITEM],
W.MULTIPLEQTY AS [PACK SIZE]
FROM INVENTTABLE AS T LEFT OUTER JOIN
INVENTSUM AS S ON T.ITEMID = S.ITEMID LEFT OUTER JOIN
INVENTDIM AS D ON S.INVENTDIMID = D.INVENTDIMID LEFT OUTER JOIN
WMSLOCATION AS L ON D.INVENTLOCATIONID = L.INVENTLOCATIONID AND D.WMSLOCATIONID = L.WMSLOCATIONID LEFT OUTER JOIN
INVENTTABLEMODULE AS M ON T.ITEMID = M.ITEMID AND M.MODULETYPE = 2 LEFT OUTER JOIN
INVENTITEMSALESSETUP AS W ON T.ITEMID = W.ITEMID AND W.INVENTDIMID = 'ALLBLANK' LEFT OUTER JOIN
ECORESPRODUCT AS E1 ON T.PRODUCT = E1.RECID LEFT OUTER JOIN
ECORESPRODUCTTRANSLATION AS T1 ON T1.PRODUCT = E1.RECID
WHERE (L.INVENTLOCATIONID IS NOT NULL)
