Formatted Search query
We have the following formatted search defined in OITM under Item Desc (foreign language):
SELECT T1.DocNum AS 'Doc No', T1.CardCode AS 'BP Code', T1.CardName, T2.ItemCode, T2.OpenQty AS 'Open Qty', T2.WhsCode
FROM [dbo].[ORDR] T1 INNER JOIN [dbo].[RDR1] T2 ON T1.DocEntry = T2.DocEntry INNER JOIN OITM T3 ON T2.ItemCode = T3.ItemCode
WHERE T2.ItemCode = $[OITM.ItemCode] AND T2.OpenQty > 0
When run, we get a pop-up window with the relevant information. My question is, is there a way to make the T1.DocNum something which can be drilled down on?
G.Mckenzie & Co