Formatted search - price/pricelist
I have the followin query:
SELECT T2.[Price] FROM [dbo].[OPLN] T1 INNER JOIN ITM1 T2 ON T1.ListNum = T2.PriceList WHERE T2.[ItemCode] = 'A99' and T1.[ListName] = $[OPLN.ListName]
This gives me an error when running it as a formatted search on the item master data. My intention is to filter the price by both item code and by the current price list name in the item master data.