Formatted search - price

[Former Member]

Hi all experts.

Can someone please provide me with a formatted search that fetches the price from the price field on item master data and selects it into a UDF on OITM.

Thanks.

Runar.

[Former Member · Accepted solution]

Create a UDF in the Item Master and assign the following 'Formatted Search Query' to the UDF:

SELECT T1.[PriceList], T2.[ListName],  
T1.[Currency], T1.[Price] FROM [dbo].[ITM1]  T1
 INNER JOIN  OPLN T2 ON T1.PriceList = T2.ListNum 
where T1.itemcode=$[oitm.itemcode]

[Former Member · Accepted solution]

Thanks.

This is exactly what I needed.

Runar