Skip to Content
avatar image
Former Member

Formatted search - price

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 11:21 AM

    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]
    

    Add comment
    10|10000 characters needed characters exceeded