Sage 100

 View Only

  • 1.  UDF Control Type

    Posted 11-03-2020 13:13
    Does anyone know of a way to change the control type of an existing UDF. Currently we have a drop box, but are wanting to change to a Multi-line so we can use a UDT for validation.

    I know that I export out the data, delete the UDF, recreate and then re-import, but was looking to see if anyone else had other ideas?

    Thank you,

    Michael

    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    Birmingham, AL
    ------------------------------


  • 2.  RE: UDF Control Type

    Posted 11-03-2020 19:50
    Back in the day of v4.x, I wrote up the following

    Modifying a existing UDF to use a UDT for validation in V4.X - 3/9/08

     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 (screen shot) 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.

    YMMV as things may have changed in the past 12 years.  Back then, I did it by experimenting a bit by creating a new UDF, then find the tables that changed based on date.  It appears that cm_udf is still in play.

    Post back and let us know how it goes.



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: UDF Control Type

    Posted 11-04-2020 15:44

    That worked. Thank you,

    Michael

     

     

    Michael H . Davis, CPA.CITP, MCSE

    Senior Consultant

    michael.davis@warrenaverett.com

    (O) 205.313.4700  

    (D) 205.313.4734  (F) 205.592.9991

    1900 International Park Dr, Suite 400, Birmingham, AL 35243

     

    To contact our Support Team, call 844.712.6223 or email software@warrenaverett.com.

    __________________________________________________________________

    In response to the COVID-19 pandemic, we have moved to a remote working environment. While our physical office locations are minimally staffed, Warren Averett continues to serve your accounting and consulting needs.

    Please note that Warren Averett is not an Agent under the Paycheck Protection Program loan program ("PPP"). Warren Averett does not provide loan packaging services or guarantee qualification under the PPP or any loan administered by the U.S. Small Business Administration 7(a) loan program.

    For ongoing insights and updates visit our COVID-19 Resource Page .

     




    Original Message


  • 4.  RE: UDF Control Type

    Posted 11-04-2020 16:49
    Thanks for the update.  Good to know it still works.  I actually have a client running a couple UDF's for 15 years that are list drop downs.  Been wanting to change them to UDT validations but have never gotten around to it.  Perhaps I have a good reason to now.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content