Skip to Content
Mar 29, 2008 at 04:50 PM

help with FMS


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?