"Choose From List" for Cost Center in a UDO form

[rajesh_khater]

Hi,

I have created 2 UDO forms for Master Data and Master Data - Rows.

In Master Data rows form, I have fields for Cost Center Code and Cost Center Name, where I want to display the Choose From List window showing the Cost Centers in Dimension 3 only.

How can I display only those Cost Centers belonging to Dimension 3, and how can I link the Cost Center Name field to the Cost Center Code field, so that the name is auto filled when the Code is selected from the Choose From List?

Thanks.

[Former Member]

Hi,

You need to make 2 FMS Queries as follows

--FMS for CC Code
SELECT PrcCode [CC Code]
FROM dbo.OPRC
WHERE DimCode = 3


--FMS for CC Name  
SELECT 
PrcName [CC Name]
FROM dbo.OPRC
WHERE PrcCode = $[@UDONAME.CCCodeUDFName]

Apply both FMS accordingly make sure while applying FMS on CC Name refresh it on base of CC Code UDF.

Thanks

Engr. Taseeb Saeed

[rajesh_khater]

Hi,

Thanks for the FMS query based approach.

But I wanted to know the solution for adding Choose From List using the Screen Painter for the UDO form.

Thanks.

[Former Member]

Hello,

You can achieve this by following step

• Start to Screen Painter Add On
• Open the UDO on which you want to make CFL.
• Select the relevant UDF.
• Set the “ChooseFromListAutoFill” property to true
• Add a new CFL , go to collection tab press new button give CFL name in unique id like EmpCFL, enter object type to like for employee give 171 and for UDO give its name @UDONAME.
• Link the text box to newly ceated CFL, for this give newly created CFL name 'EMPCFL' in chooseFromListUID .
• Set the returned field from the CFL, paste the field name in chooseFromListAlias like 'empID'

Thanks

Engr.Taseeb Saeed