Skip to Content
0
Former Member
Nov 12, 2012 at 09:34 AM

Formatted Search: How to get parameter from SO line

37 Views

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