on 11-12-2012 9:34 AM
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
Hi Wai,
Use this in your query:
WHERE t0.ItemCode = $[RDR1.ItemCode]
Good luck.
Best regards,
Pedro Magueija
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.