Sage 100

 View Only

  • 1.  UDF Tied to the SY_Country Table

    Posted 07-29-2020 17:07
    Is it possible to create a UDF field which validates against the SY_Country table or do I have to create a specific UDT and populate accordingly?

    TIA

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


  • 2.  RE: UDF Tied to the SY_Country Table

    Posted 07-29-2020 17:25
    You can't use Sage tables for UDF validation.  (I think there is an Idea for that, years old... crickets chirping...).

    A script would work for just the validation part, but adding a UDT allows a lookup list.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: UDF Tied to the SY_Country Table

    Posted 07-30-2020 09:16
    With Kevin on this one.  I would lean towards a UDT,  I just export the countries and update the UDT.  Especially if they aren't adding countries you would be done.  If they are maintaining countries all the time then I would script it.

    ------------------------------
    Chris Mengerink
    Director
    DWD Technology Group
    Fort Wayne IN
    260-399-8653
    ------------------------------

    Original Message


  • 4.  RE: UDF Tied to the SY_Country Table

    Posted 07-31-2020 02:19
    I actually have a post somewhere with a script example to add lookups to fields. This allows the lookup to be used to return a validated value from the list but if you want to force validation if they key something directly into the field, you will need to script that.
    This completely bypasses the need for the UDT.
    See this thread and read from beginning to end.
    https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=c7862932-dd09-401b-af9a-d591fb40fe49&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bmad4654e3-a580-4be9-94cb-064288150c82

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 5.  RE: UDF Tied to the SY_Country Table

    Posted 07-31-2020 08:30
    AWESOME @David Speck II  Thanks
    ​

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

    Original Message


Related Content