FMS which brings up a list
I have a question concerning a QUERY a FMS and a UDF.
I created a UDF in the AR Marketing Documents, it has a FMS which goes and looks at the Business Partner and should present the user the selection of the Contacts only for that BP.
My QUERY only returns the first Contact in the list,
SELECT T0.[Name] FROM OCPR T0 WHERE T0.[CardCode] =$[$4.0.0]
What do I have to change so that the user can pick from a list in the UDF?
Gordon Du replied
Your UDF should be setup under Market Documents Title part. The field property should follow Suda's instruction.
When your mouse is on that UDF under any market documents view user fields, using ShiftAltF2 to bring up FMS defintion. Select Search by saved query. Double clicks on the blank row to bring up the query manager to choice your query.
It should work, I have tested it. Before assigning query to your UDF FMS, you can check the query result when you bring up the marketing document screen. Do not save the query at this testing time.