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

FMS

My client have requirement he have one column in sale order at row level name as excise he want when he put any value like 2 in excise column it will multiply with unit price .example unit price 2000 excise 2 when he enter 2. then unit price with be 4000

plz tell me FMS for this

i have this FMS but it is not working

SELECT ($[$-38.81.number]*$[$-38.11.number])

Edited by: Ajit Pal Singh Toor on Jul 5, 2010 9:45 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 05, 2010 at 09:40 AM

    HI Ajit,

    you may try this:

    SELECT $[$38.14.number] * $[RDR1.U_UDF.number]

    Thanks,

    Joseph

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 05, 2010 at 09:28 AM

    Hi,

    Try This,

    SELECT $[$38.14.number] * $[$38.U_excise.number]

    Thanks

    Ashutosh T

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ajit,

      Try this, its very simple.

      ->> Create 2 UDF in Marketing Row Level.

      ex.

      UDF 1 -> U_excise

      UDF 2 -> Total Value(Unit PriceU_excise)*

      ->> Assign the below FMS in UDF 2 and AutoRefresh of U_excise UDF field.

      SELECT $[$38.14.NUMBER] * $[$38.U_excise.NUMBER]
      

      OR

      SELECT $[RDR1.PriceBefDi.NUMBER] * $[RDR1.U_excise.NUMBER]
      

      Regards,

      Madhan.

  • Posted on Jul 05, 2010 at 09:32 AM

    Pick udf value like this

    $[$ 38.Udfname.Number]

    Regards

    Deepak Tyagi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 05, 2010 at 11:01 AM

    Hi,

    Try this

     SELECT ($[$38.UDF-name.Number]) * ($[$38.14.Number]) 

    Edited by: Deepak Tyagi on Jul 5, 2010 1:01 PM

    Edited by: Deepak Tyagi on Jul 5, 2010 1:02 PM

    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.