cancel
Showing results for 
Search instead for 
Did you mean: 

Why my User Defined Field does not refresh when other field changes

mervz02
Explorer
0 Kudos
120

Hi Experts i create a UDF and a Query which compute number of days between two date using DATEDIFF and i want to show it to UDF Field, i setup it using FMS when AR Invoice due date field is change it will automatically compute to the UDF field the total Difference of my Posting Date and Due Date, but apparently it does not refresh at all. here is a sample of my code.

DATEDIFF(DAY,U_CounterDate,T0.DocDate + 10 ) FROM OINV T0 WHERE T0.[DocNum] = $[OINV.DocNum]
View Entire Topic
SonTran
Active Contributor

Hi,

Try this query and assign to your FMS:

select datediff(day,$[$10.0.Date],$[$12.0.Date])

Hope this helps,

Son Tran