FMS

[former_member355302]

Dear Expert,

We have 3 UDF and we just want to sum of (UDF1+UDF2) in third UDF3 But we can change any of them(UDF1 or UDF2) and get the desird output in UDF3.

How we can achieve.

Please give me response as soon as possible.

Thanks

Ashish Agrawal

[Former Member]

Dear Ashish,

You may only refresh FMS by one field. Your goal is not achievable automatically. A workaround is to refresh based on a frequent changed UDF. Or you can always update two UDF and make the last UDF to refresh.

Thanks,

Gordon

[Former Member]

Hi Ashish......

FMS is quite easy. But you can apply refresh only on one UDF.....

For FMS please refer......

Select (Select $[TableName.U_UDF1.0])+(Select $[TableName.U_UDF2.0])

Regards,

Rahul

[former_member355302]

but we have to refresh UDF3 Value when ever UDF1 and UDF2 will Change.

UDF1 and UDF2 have to be filled manually.

Thanks'

[Former Member]

Hi Ashish,

SELECT ($[ORDR.U_1.number] + $[ORDR.U_2.number])

Make referesh regular on Document Number

When you Add document after UDF 3 update Sum automatically.

Change Table name as per your requirement

Thanks,

Srujal Patel

[Former Member]

Please tell on which document u want to add these UDF and whether these UDF take the value from any other field or only value filled by user manually.

Thanks

Sam

[Former Member]

Make Three UDF on Marketing Document of Type (Amount). and put this FMS which will help you a lot.

SELECT $[ORDR.U_UDF1.number] + $[ORDR.U_UDF2.number]

Thanks Sam