Skip to Content
0

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

Jan 31, 2017 at 02:42 AM

131

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Taseeb Saeed Feb 01, 2017 at 09:06 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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

0