cancel
Showing results for 
Search instead for 
Did you mean: 

Formatted Search: How to get parameter from SO line

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

pedro_magueija
Active Contributor
0 Kudos

Hi Wai,

Use this in your query:

WHERE t0.ItemCode = $[RDR1.ItemCode]

Good luck.

Best regards,

Pedro Magueija

Former Member
0 Kudos

Hey Pedro,

I've modified my query and I am able to get the correct list.

Thank you,

Wai Leng

Answers (0)