Sage 100

 View Only

  • 1.  Error 20 SWQUERY line 0504 - custom office UDF/UDT

    Posted 05-28-2023 13:50

    Recently upgraded from v2017.4 to v2022.2 Sage 100 Standard with OM
    UDF/UDT exist in AR, IM, and SO all are failing when you do the lookup. I have created new UDF/UDT after the upgrade and the same error is received.
    I have replaced all SY1 and Providex and reinstalled per KB 20379
    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=20379&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=5939&cmd=displayKC&dialogID=407526&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true
    I increased the size of all UDF's with UDT  to force the rebuild
    I ran the sy_activation for all modules
    Nothing has resolve this issue, any suggestions would be greatly appreciated!!





    ------------------------------
    Lisa Dion
    Vrakas/Blum Computer Consulting, Inc. ldion@v-bcc.com
    ------------------------------


  • 2.  RE: Error 20 SWQUERY line 0504 - custom office UDF/UDT

    Posted 07-03-2023 12:37

    Did you get a resolution on this? I'm having the same issue and I'm really trying not to reinstall as they have OM and it was not an easy migration/conversion.



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



  • 3.  RE: Error 20 SWQUERY line 0504 - custom office UDF/UDT

    Posted 07-03-2023 14:20
      |   view attached

    Yes, most of it still have one issue. I started a case with Sage, they had me replace the SWQUERY in MAS90 \ SOA, then run the sy_activation for SO, AR. However, I did notice in AR Invoice History Header all the previous data in the UDFs was blank. I exported that data from v2017 and imported into v2022. I still have one UDT/UDF in item maintenance that is not working, different error than above.



    ------------------------------
    Lisa Dion
    Vrakas/Blum Computer Consulting, Inc. ldion@v-bcc.com
    ------------------------------

    Attachment(s)

    docx
    Error 81.docx   79 KB 1 version
    Original Message


  • 4.  RE: Error 20 SWQUERY line 0504 - custom office UDF/UDT

    Posted 07-20-2023 13:30

    Turns out this is a defect in the V2022  OpMgmt programs.  I reached out to Scanco and they provide an updated swquery program that resolved the issue.  My case was    81542. 

    Hopefully this helps.



    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------



  • 5.  RE: Error 20 SWQUERY line 0504 - custom office UDF/UDT

    Posted 07-20-2023 15:40

    Thanks @Jim Woodhead I will reach out to Scanco.



    ------------------------------
    Lisa Dion
    Vrakas/Blum Computer Consulting, Inc. ldion@v-bcc.com
    ------------------------------

    Original Message


  • 6.  RE: Error 20 SWQUERY line 0504 - custom office UDF/UDT

    Posted 12-18-2023 18:39

    Hi Jim, I have an install with this error 0504 as well.  I just replaced the SWQUERY with the file that Scanco gave me and it fixed the error however now when we want to do a custom lookup in SO entry we do not get any SY tables to choose from. Did you every run across that issue after replacing SWQuery? Thank you.



    ------------------------------
    Dana Halpin
    Vrakas/Blum Computer Consulting, Inc.
    ------------------------------

    Original Message


  • 7.  RE: Error 20 SWQUERY line 0504 - custom office UDF/UDT

    Posted 12-19-2023 08:44

    Sage suggested I replace the SY_ExportLink file in MAS_System and that fixed the SY tables missing from a SO custom lookup.



    ------------------------------
    Dana Halpin
    Vrakas/Blum Computer Consulting, Inc.
    ------------------------------

    Original Message


Related Content