Proper Syntax using UDF in FMS

[Former Member]

I am sure this is a quick question.

I need to use a User Defined FIeld that is in the Marketing Document Header in a Formated Search

to be used in the Marketing Doument Details

The formated search I created will capture the data if I assigne it to another UDF in the Document header

example: Select $[$U_ODEPT.0.0] attached to a field in the UDF header section will give me the proper result.

When I attach the same FMS to a field in the Market Documet Details I get an internal error 3006

Any sugetions as to what I am doing wrong the syntax in my formatted search?

Thanks in advance!!!

[a_a · Accepted solution]

1. To get detail information about the cause of the problem you should run the formatted search query manually while the window referring to the formatted search is open. Remember - do not save the query run in this way.

2. Also please check that the refresh regularly field is not checked at row level- it is better to use auto refresh when exiting an altered row column.

3. Further, the syntax is either $[$Field Index.Field Column.Number/Currency/Date/0] or $[Tablename.Fieldname]. Try using the Field Index number of U_ODepartment instead of the the field name i your query.

Try these three solutions - you may solve the error.

Ajay

Edited by: Ajay Audich on Apr 4, 2009 7:58 PM

[Former Member]

Post your FMS query here and mention the field you try to assign this FMS.

Thanks,

Gordon