Skip to Content
avatar image
Former Member

Formatted search - price/pricelist

Hi.

I have the followin query:

SELECT T2.[Price] 
FROM [dbo].[OPLN]  T1 INNER JOIN ITM1 T2 ON T1.ListNum = T2.PriceList 
WHERE T2.[ItemCode] = 'A99' 
and  T1.[ListName] = $[OPLN.ListName]

This gives me an error when running it as a formatted search on the item master data. My intention is to filter the price by both item code and by the current price list name in the item master data.

Regards, 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 01:02 PM

    Which field on the Item Master?

    Add comment
    10|10000 characters needed characters exceeded