Skip to Content
avatar image
Former Member

FMS

there is one column at row level project code i want his vale in udf this is fms that is working at row level but when i put it on udf it is showing internal error Select $[$38.31.0]

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 02:08 PM

    How do you get row level data to UDF in title? Which row do you want? Please explain.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 06:56 AM

    Hello Ajit,

    use this

    SELECT $[RDR1.Project]

    • here RDR1 means sales order chield table

    Thanks & Regards

    Manvendra Singh Niranjna

    Edited by: Manvendra Singh Niranjan on Sep 21, 2010 12:26 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      if you want to pick this result in title level UDF then it will show you error,then you should use of SBO_SP_TransactionNotification in sql proceduer

      Thanks & regards

      Manvendra

      Edited by: Manvendra Singh Niranjan on Sep 21, 2010 1:13 PM

  • Sep 21, 2010 at 10:41 AM

    Hi Ajit Pal Singh Toor

    Try this code in character field,

    SELECT $[$38.31.0]
    NOTE:-
    **Auto Refresh When Field Changes* is MUST*

    Edited by: Prasanna s on Sep 21, 2010 4:12 PM

    Edited by: Prasanna s on Sep 21, 2010 4:13 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2010 at 04:23 AM

    Hi Ajit..............

    Are your projects BP Specific?

    If yes then no need to apply FMS. You cant just set the Projects at BP Master level.

    So whenever you select the BP it will fetch that particular Project in Header as well as row level.....

    If not then you have another field for project code at header level and I think its in Accounting tab of the Marketing Document...

    Hope this works........

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded