Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 01, 2017 at 09:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Rajesh Khater

      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