Sage 100

 View Only

  • 1.  Custom Reports don't show up in Report Manager

    Posted 07-28-2021 14:22

    Sage 100 Premium v2019. We recently migrated customer's Sage and SQL to new servers.  Their custom reports show up under the module in the menu, but do not show up in Report Manager.  I found the Sage KB ID 50506 which says to reset the Sy_Menu, but all the responses I've seen here and in Sage City have reported that didn't fix the issue. I tried to edit the menu, not make any changes and accept it to refresh it, but didn't change Report Manager.  Wanted to see if anyone else has seen this or was able to figure out a solution to the issue (other than adding the reports back to the menu in Report Manager).  Thanks,



    ------------------------------
    Chris Love
    Accounting Systems, Inc. (ASI)
    ------------------------------


  • 2.  RE: Custom Reports don't show up in Report Manager

    Posted 07-28-2021 16:17
    Sounds like either corrupt or missing records in the SY_ReportSetting table.  A record for a custom report in this table should look something like this.

    ModuleCode CompanyKey ReportID ReportSetting DefaultReport Description SettingOptionsType PrintReportSettings PrinterName SortReportBy PageBreak Collated ThreeHolePunch MultiPart TemplateDesc Line1Message Line2Message UseOfficeTemplate OfficeTemplateName NumberOfCopies PaperOrientation PaperSize PaperSource PrinterDuplex DateCreated TimeCreated UserCreatedKey DateUpdated TimeUpdated UserUpdatedKey WorkstationName ReportPreviewZoom
    I/M 0000000000 ItemImageCUSTOM.RPT STANDARD N Item Image NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 0


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: Custom Reports don't show up in Report Manager

    Posted 07-29-2021 08:55
    Have you checked to make sure its not a Business Insights Reporter created type vs one added via the Report Manager?

    ------------------------------
    Bruce Kern
    SWK Technologies Inc.
    ------------------------------



  • 4.  RE: Custom Reports don't show up in Report Manager

    Posted 07-29-2021 09:03
    Yes, they are custom .rpts that were added at one point in time and after our server move they no longer appear in the report manager.

    ------------------------------
    Chris Love
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


Related Content