cancel
Showing results for 
Search instead for 
Did you mean: 

UDF Value is not coming in the query report

Former Member
0 Kudos
58

Hi all,

i have designed query report based on AR Invoice which has some UDF .

all udf have FMS applied and all these udf has values.

when i run report some times udf values are coming in the report and somtimes not even if udf contains values.

if i open perticular invoice and again update that udf and again run report now udf value will come in the report.

every time i need to manualy update the udf even if that udf contain value.

how to avoide this problem.

Pls suggest solution.

Regards,

Chetan

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Chetan,

Try this,

-> Open the require document(module).

Assign this procedure and then ADD the document

and Run the Query Report.

1. Goto the UDF and Click (ShiftAltF2).

2. Select the SEARCH BY SAVED QUERY.

3. Assign the FMS Query in UDF.

4. Select the AUTO REFRESH WHEN FIELD CHENGES.

5. Select the Auto Refresh Field (for example CardCode (or) Remarks).

6. Check the Display Saved Values.

OR

-> Open the require document(module).

1. Goto the UDF and Click (ShiftAltF2).

2. When will you add the document at that time

you can Click the SHIFT + F2 and than ADD the document.

and than Run the Query Report.

Regards,

Madhan.

former_member204969
Active Contributor
0 Kudos

The system stores data into the UDF-s only when you activate the Add or Update button.

Setting the FMS to Refresh Regularly does not mean that the system in the background update these fields. It only means that when you open the form, it modify the value at the screen and you may save it activating the Update button.