Sage 100

 View Only
  • 1.  UDT not showing in user-defined field and table maintenance

    Posted 03-08-2024 15:16

    When opening User-Defined Field and Table Maintenance, I see 1 UDT listed under SY Module but none of the other tables.

    On the UDT Maintenance I can see 5 UDT tables to maintain. 

    When I run the reports in Custom Office, I can see the table in the report. 

    When I create the table, I can see it in the list but if I exit out of User-Defined Field and Table Maintenance and reopen it's not listed. 

    If I create a new table and enter in the same name, it appears with all of my fields in it. 

    I've added to the menu, thinking I could work around this, but I actually want to use this for a UDF within AR Cash Receipts detail. I'm not able to choose the new UDT that I created and that is on the menu to maintain. 

    I found an old Sage City discussion, but so far nothing works. Any thoughts or suggestions?



    ------------------------------
    Tina Meacham
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: UDT not showing in user-defined field and table maintenance

    Posted 03-08-2024 15:32

    I believe only the global UDT's (all modules) will appear in sy_.  If it was set up as a module UDT, then it will appear under the module folder



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



  • 3.  RE: UDT not showing in user-defined field and table maintenance

    Posted 03-18-2024 13:44

    Hi Jeff - I think I should have written that better...Only one UDT shows up in all of the tables. So if a UDT was created in SO, it's not showing up. The only UDT showing in the list is the one in SY Global all others do not show up. 



    ------------------------------
    Tina Meacham
    RKL eSolutions, LLC
    ------------------------------



  • 4.  RE: UDT not showing in user-defined field and table maintenance

    Posted 03-18-2024 14:09

    If something is missing from the menu, after adding it, that could be Role permissions.

    If the UDT you created does not show in Custom Office anywhere, open a Sage case.  That is not normal.



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



  • 5.  RE: UDT not showing in user-defined field and table maintenance

    Posted 03-18-2024 17:29

    I checked on Role Permissions. They have JobOps but I'll try Sage next. 



    ------------------------------
    Tina Meacham
    RKL eSolutions, LLC
    ------------------------------