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

[mervz02]

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]

[SonTran · Accepted solution]

Hi,

Try this query and assign to your FMS:

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

Hope this helps,

Son Tran

[LoHa]

Hi,

what is not working your querie or the trigger?
For the query you can try this

SELECT DATEDIFF(DAY,$[$U_CounterDate.0.0],$[$10.0.0] + 10 )

If you want to test it.
Save the query, open the invoice window and then go through the menu to the query. The variables will be filled with the values from the form.

you could post a picture of your settings if it don't work....
Ah and at least, where is the UDF you are looking in with your query and where is the UDF that should be filled?

regards Lothar