I am trying to do what I thought was a simple formatted search on a user defined field in the item master
I want to return a price based on the following query. The query returns a correct value if I enter an itemcode so I know the data is correct.
SELECT price from itm1 (nolock) where itemcode = $[oitm.itemcode] and itm1.pricelist = '1'
I also want to do the same thing with LastPurPrc from the oitm to another user defined field.
Can anyone help to what must be a simple thing?