Sage 100

Sage 100 Premium 2022, customer has a UDF with a dropdown list currently set as List validation, but they now want to add more choices than the list can hold (900 character limit).  I created and populated a UDT, but the UI does not give you a way to change the validation from List to UDT.  Since it is Premium, I tried (in a test system) editing CM_UDF so that ValidationType = F and the ValidationValue is the UDT name, but in Custom Office this field still shows as List (which is now blank)..

Is there a way to change the validation type?  OR another database field to be edited?

------------------------------
Phil McIntosh
Friendly Systems, Inc.
------------------------------

I did this back in the day.  I would expect it still work.

YMMV

Modifying an existing UDF to use a UDT for validation in V4.X

1)  Create test UDF that uses the UDT.

2)  Make copy of ...\mas_system\cm_udf.m4t

2)  Using DFDM, open ...\mas_system\cm_udf.m4t.

3)  Print the listing of UDF's

4)  Locate the current UDF and the test one created above.

5)  Make note of the differences in fields.  I noted fields 6, 16, 17, 18, and 19.

6)  Change the original UDF record to match the test UDF.

7)  Return to customizer to review original UDF settings.

8)  Test original UDF on a panel.

9)  Delete test udf and copy of cm_udf.m4t if satisfied.

 

Jeff Schwenk  3/9/08

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

Thanks Jeff!  The not so obvious one was to change dropdown to multiline.

------------------------------
Phil McIntosh
Friendly Systems, Inc.
------------------------------

Original Message:
Sent: 01-22-2024 12:12
From: Jeff Schwenk
Subject: Convert UDF dropdown validation from List to UDT

I did this back in the day.  I would expect it still work.

YMMV

Modifying an existing UDF to use a UDT for validation in V4.X

1)  Create test UDF that uses the UDT.

2)  Make copy of ...\mas_system\cm_udf.m4t

2)  Using DFDM, open ...\mas_system\cm_udf.m4t.

3)  Print the listing of UDF's

4)  Locate the current UDF and the test one created above.

5)  Make note of the differences in fields.  I noted fields 6, 16, 17, 18, and 19.

6)  Change the original UDF record to match the test UDF.

7)  Return to customizer to review original UDF settings.

8)  Test original UDF on a panel.

9)  Delete test udf and copy of cm_udf.m4t if satisfied.

 

Jeff Schwenk  3/9/08

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------