Hey all,
I am trying to create a formatted search with query, which carry out the price list for particular item.
SELECT T0.[ItemCode], T1.[ListName], T0.[Price] FROM ITM1 T0 INNER JOIN OPLN T1 ON T0.PriceList = T1.ListNum
I've created the query above to pull out the item price for each price list. After I select item in SO, I would like to get the list and select the needed price from the list. The problem is, I just to get the list for the particular item only.
I am not sure how to get the parameter from select item in SO, anyone can advice on this?
Thank you.
Wai Leng