Skip to Content

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 29, 2008 at 08:54 PM

    Keith Taylor

    I would wonder why you would need to use a formatted search and user field to get the price of an Item which is already available when you select the Pricelist from the dropdown.

    Please let me know if you have a different reason?


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 29, 2008 at 08:11 PM

    This query could work as an FS, but you could not set it auto refresh when the price in the price list changes. You have no such possibility.

    You could activate it only according to the last purchase price.

    What is you purpose for the FS?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.