Sage 100

 View Only

  • 1.  Missing record in Lookup UP for Custom UDT Table

    Posted 07-03-2023 10:08

    Upgraded client to v2022 over the weekend, one of there Lookups for a User Defined Table, is missing in the v2022 upgraded version from SY1Q01.soa.  I have run lookup conversion.  Is there a "method" to add that back in through Data File Display and Maintenance?  Using a knowledgebase article (71811); I tried this via syzcon command without success.  any advice? 

    PRINT %SYS_SS'CreateTable("SO_UDT_TRACKING_STATUS","COMPANY:E02"   It returns a Syntax Error referencing Company Code. 



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: Missing record in Lookup UP for Custom UDT Table

    Posted 07-03-2023 10:11

    Have you tried editing the UDT? If you add a dummy field to the end or something the update might force the lookup to get recreated.

     

     

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     






  • 3.  RE: Missing record in Lookup UP for Custom UDT Table

    Posted 07-03-2023 10:12

    Oh, that is a great idea.  I will do that around Noon when I can get them out for a few minutes. 



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 4.  RE: Missing record in Lookup UP for Custom UDT Table

    Posted 07-03-2023 14:18

    that worked @David Overholt  After adding a new "field" to the table, I went into LM-> Main -> User Lookup Wizard; found the File Name and created a ###-### Custom Lookup.  FYI @Tina Leonard 



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 5.  RE: Missing record in Lookup UP for Custom UDT Table

    Posted 07-03-2023 17:11

    Madeline that worked perfectly. Thank you. 



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

    Original Message


  • 6.  RE: Missing record in Lookup UP for Custom UDT Table

    Posted 07-03-2023 14:26

    This can be moved out of Urgent.  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 7.  RE: Missing record in Lookup UP for Custom UDT Table

    Posted 07-04-2023 08:49


    Sent from my iPad



    Original Message


Related Content