Skip to Content
author's profile photo Former Member
Former Member

FMS to show project UDF in sales orders

Hi

We have added a UDF in the project setup page , it is referred to as U_Type under system information

I need an FMS to show this U_Type field value as per the project code entered in the sales order under accounting tab > BP Project

Thanks for your help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2013 at 07:56 PM

    Hi,

    You are nearly there....

    You just need to make a join on "UFD1" which contains the details (including the description) of the valid values defined for the UDF

    Try this.....

    SELECT T1.Descr FROM OPRJ T0

    INNER JOIN UFD1 T1 ON t0.u_ProjCat = t1.FldValue

    WHERE T0.[PrjCode] = $[$157.1.0] and t1.TableID = 'OPRJ'

    Hope that helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks everyone for your help

      i have just again replaced ProjCat with Type and i worked , below is the final query

      SELECT T1.Descr FROM OPRJ T0

      INNER JOIN UFD1 T1 ON t0.u_Type = t1.FldValue

      WHERE T0.[PrjCode] = $[$157.1.0] and t1.TableID = 'OPRJ'

  • Posted on Oct 25, 2012 at 01:07 AM

    Hi semaan..

    Can you explain little bit..

    udf under project code set up

    what value should store there is it again project code from sales order?

    Regards

    Kennedy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Kennedy T

      Hi Kennedy

      sorry for the late reply

      I have replaced "ProjCat" with "Type" in your query and it works now .

      The only problem is that the UDF has valid values for the field which is made of 2 columns Value and description

      The query is now returning what is in the Value column and I want it to return what is in the description one

      I have attached a small image to clarify this

      Thanks for your help

      Query.jpg (41.2 kB)
  • Posted on Oct 25, 2012 at 12:03 AM

    Hi,

    try this:

    select T0.[Project] from ORDR where U_Type = $[ordr.Project.0]

    To run this FMS, need to open the project setup form.

    Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2012 at 12:25 PM

    Hi,

    Try:

    SELECT T0.U_ProjCat FROM OPRJ T0 WHERE T0.PrjCode = $[$38.31.0]

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2013 at 09:51 AM

    Hi Semaan,

    Please confirm is this has solved your problem and close accordingly.

    Regards

    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.