FMS

[Former Member]

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

[Former Member · Accepted solution]

HI Ajit,

you may try this:

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

Thanks,

Joseph

[former_member196081]

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

[former_member196081]

Pick udf value like this

$[$ 38.Udfname.Number]

Regards

Deepak Tyagi

[ashutosh_tomar]

Hi,

Try This,

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

Thanks

Ashutosh T

[Former Member]

Thanx for reply but

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

its giving error " internal error"

[ashutosh_tomar]

Check your UDF name in this case.

Thanks

Ashutosh T

[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.