Skip to Content
author's profile photo Former Member
Former Member

Formatted Search: How to get parameter from SO line

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 12, 2012 at 09:55 AM

    Hi Wai,

    Use this in your query:

    WHERE t0.ItemCode = $[RDR1.ItemCode]

    Good luck.

    Best regards,

    Pedro Magueija

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.