Formated Search using value from a UDF

[Former Member]

I am trying to load a value into a UDF from a formated search assigned to another UDF, U_ROUTE.

My challenge is to capture the value entered in the UDF U_TRIP to use in a Formated search attached to another UDF, U_ROUTE

Here is the piece of the formated search attached to UDF U_ROUTE that is giving me trouble

Select $[$-139.U_TRIP.0.0]

-139 = Form name

U_TRIP is the Value entered in the UDF that the Formated search is NOT attached to

When I attach this formated search to the UDF U_ROUTE, I am not getting the data that was

entered in the "U_TRIP" User defined Field

I am assuming that I am referencing the UDF U_TRIP in my select statement

Thanks in Advance

Dana

[former_member583013 · Accepted solution]

Dana,

Could you clarify the following.

Are the 2 UDF's defined for use on the Sales Order Header level?

What are their types and are there any pre-defined set of values?

Your FMS syntax is incorrect.. It should be $\[$U_Trip.0.0]

[Former Member · Accepted solution]

Suda

Thanks again!!! That Almost solved the problem.

And to answer your questions:

1) Yes both UDFs are defined for use in th eSales Order Header

2) U_TRIP has 3 Valid Values 1,2 & P

3) U_ROUTE is an Alpha Numeric field with a lenght of 10

My issue now is when I make a change to the field U_TRIP, the Formated search attached to the

U_ROUTE is not loading any value into the field.

When I press <SHIFT> <F2> in the U_ROUTE field, the field fires and I get the data I am looking for loaded into the field.

The Formated Search is set up to Auto Refresh when the U_TRIP field changes

Any ideas?

I really appreciate your help!! Again!!!

[former_member583013 · Accepted solution]

Dana,

This has been an issue with UDF's...the first time you change the value in U_TRIP...the FMS on U_ROUTE does not get the change event but if you try to change the U_TRIP one more time the FMS would refresh.

I have seen a few post recently where users have experienced a similar issue.

I am not sure how this could possibly be resolved. Will let you know if I find out

Suda