Sage 100

 View Only
Expand all | Collapse all

Is there a limit to the number of entries in a UDT?

  • 1.  Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 09:37
    Or a size limit? 
    TIA

    I posted this yesterday as a Question to be answered but then can't see it under Discussion Posts. Is this something new? What am I missing?



    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------


  • 2.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 10:03
    Edited by Wayne Schulz 06-24-2021 10:07
    It's there but I don't see it because I use a shortcut that apparently only shows new discussion posts ( across all groups that I have access to). I'm not sure what the difference is between discussion and questions other than they apparently show separately.

    I like to have one spot to see all new activity. I'm not sure there is such a spot that shows new questions and discussions.


    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 3.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 10:13
    Well, I am seeing this post.  Maybe it is the same one???  Perhaps a HL expert can clarify?

    Regarding the limit for UDT size, I suppose there isn't until there is.  Back in the early days (4.5 or 2019), a client had over 1,000.  Clicking on the magnifying glass became an exercise in patience.  But it kept working.  Can you say "EverReady Turtle"?

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



  • 4.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 10:39
    No, I created a new post and did not select the Question option. I have no idea where my original question posted!

    So we're using a UDT as a log and it could become quite huge, thus the size limit question.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------



  • 5.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 10:46

    (I think I'll stick with Discussion type posts...).

    UDT maintenance is horrible with large record sets, but we've used UDT's for large row counts without issue.  Purging old data is a problem though (must be scripted).  If it is just logging, perhaps consider the Activity Log.  Sage improved that interface recently.

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



  • 6.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 11:37
    Thanks @Kevin Moyes but can you script something to post to the Activity Log? Customer wants to track changes to SO ship dates - who, when, why? ​

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------



  • 7.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 11:40
    Yes, very easily with absolutely no permission problems (which can happen with UDT's).
    The who and when is already part of the Activity Log... just construct the values you want to save (sMsg) then:

    oSession.WriteLog "M", sMsg



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



  • 8.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 12:22
    Maybe this DSD Enhancement to audit Sales Order changes would be an option - https://dsdinc.com/enhancements/marketplace/products/soat-sales-order-audit-tracking

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 9.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 12:47
    Thanks @Wayne Schulz. Will have to take a look at this.


    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------



  • 10.  RE: Is there a limit to the number of entries in a UDT?

    Posted 06-24-2021 13:23
    @Wayne Schulz do you know if tracks changes to UDF's as well?​

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------