Sage 100

 View Only

  • 1.  Error 20 sy_reportui.pvc line 848 v2023

    Posted 09-22-2025 21:59

    Client attempted to run AP aging report and this error displays immediately,  Restoring the sy_reportoption.m4t table worked previously (but that had other issues).  Now it is back and a restore is not working.  Error displays for all users running the aging report in ONE company.  Report runs without issue in other companies.  No exact matches for this message on the KB

    TIA



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

    Improving bottom lines for over 25 years!
    ------------------------------


  • 2.  RE: Error 20 sy_reportui.pvc line 848 v2023

    Posted 09-23-2025 08:58
      |   view attached

    Backup and try the "alternate method" below per the article attached to this post.

    • Alternate method for those familiar with the Data File Display and Maintenance utility:
      1. Access Library Master, Utilities menu, Data File Display and Maintenance
      2. Open the SY_Company.m4t file
      3. Search for the record for the company code where the error occurs.
      4. Note the Company Key field for the 10-digit company key for that company code
      5. Open the SY_ReportOption.m4t file
      6. Search for records associated with the module (e.g. S/O), company key, report or form name (e.g. SO_INVOICEPRINTING_UI), and report setting (also known as form code name, e.g. STANDARD or NEWINVOICE) that has the error.
      7. Delete the specified record(s) located.
        1. Note: If the error only happens for one user,
      8. Try printing again


    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Attachment(s)

    pdf
    Error 20 SY_ReportUi.pvc 919.pdf   558 KB 1 version


  • 3.  RE: Error 20 sy_reportui.pvc line 848 v2023

    Posted 09-23-2025 09:52

    Thanks, but no cigar.  Did not work either.



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

    Improving bottom lines for over 25 years!
    ------------------------------

    Original Message


  • 4.  RE: Error 20 sy_reportui.pvc line 848 v2023

    Posted 09-23-2025 10:02

    Since the error is in reportUI, you may want to look at the report screen....

    Just a thought.

    Jeff



    ------------------------------
    Jeff Fiddelman
    DSD Business Systems
    ------------------------------



  • 5.  RE: Error 20 sy_reportui.pvc line 848 v2023

    Posted 09-23-2025 10:33

    @Jeff Fiddelman - Which table is that?



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

    Improving bottom lines for over 25 years!
    ------------------------------

    Original Message


  • 6.  RE: Error 20 sy_reportui.pvc line 848 v2023

    Posted 09-23-2025 10:35

    Not so much a table as looking to see if there is anything wrong/funky with the screen for that report in that company.  Perhaps reset the screen, etc.

    JF



    ------------------------------
    Jeff Fiddelman
    DSD Business Systems
    ------------------------------

    Original Message


  • 7.  RE: Error 20 sy_reportui.pvc line 848 v2023

    Posted 09-23-2025 10:49
    Edited by Alnoor Cassim 09-23-2025 10:50

    Jeff - DFDM Sy_ReportOption, find the correct AR_AGEDINVOICEREPORT_UI record corresponding to the company key / report setting then look a Field 5 OptionsString$. There's something "invalid" in there. If you copy / paste that OptonsString$ value into your reply, we might be able to tell what's wrong. Here is my own from ABC where I created a report setting called CONDENSED and checked the Condensed box in the report screen.



    ------------------------------
    Alnoor Cassim
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 8.  RE: Error 20 sy_reportui.pvc line 848 v2023

    Posted 09-24-2025 21:54

    @Alnoor Cassim - Thanks

    SORTREPORTBY$="V";ML_DATEDESC$="";ML_AGINGDATE$="";CB_EXCLUDEFUTURETRANS$="Y";DB_AGEINVOICESBY$="I";CB_PRINTSUMMARY$="N";DB_AGINGOPTION$="A";CB_PRINTCOMPANYCODES$="Y";DB_INVOICESTOPRINT$="O";DB_INCLUDEELECTRONICPAY$="Y";CB_CONDENSEDPRINT$="Y";DB_568APPROVALSTATUSINCLUDE$="A";CB_568PRINTAPPROVALSTATUS$="Y";<RT>



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

    Improving bottom lines for over 25 years!
    ------------------------------

    Original Message


Related Content