Update UDF through Transaction notification

[Former Member]

Hi All,

On Sales Order, we have a udf at row level RDR1.U_ExpExpDate.

I want to update the value in this udf based on values from 2 udf's.

udf1: RDR1.U_Warranty  This udf has valid values 1,2 and 3

udf2: RDR1.U_Months Based on the value in udf1, the value in udf2 gets populated as 12, 24 and 36 through fms

udf3: Based on the value in udf2 and docdue date of sales ordr, i would like to udpate the value in U_ExpExpdate with

DATEADD(mm,CONVERT (INT,T1.U_Months),T0.DocDueDate)

T1 = rdr1

T0= ORDR

Please advise.

[Johan_H]

Hi,

Why would you want to do that in the Transaction Notification stored procedure ?

All you need to do is create a simple FMS in the U_ExpExpdate field, with refresh regularly when the U_Warranty field changes (for example).

Regards,

Johan