Sage 100

 View Only
  • 1.  Post-upgrade, Report Manager is no longer showing

    Posted 03-09-2018 10:42
    Post-upgrade, Report Manager is no longer showing me the Custom Reports that each module had created before the upgrade. If you go into the module->Custom Reports menu, you can still see each report and run it, but it's not there in LIB Mast->Setup->Report Manger.... KB article says to run SY_Menu_UI and reset ... Tried that & it didn't work. It says if that doesn't work, remove each report from SY_Menu & re-create. I'd do that if it was one or two... there are over 50 reports & I'd REALLY like to avoid doing this.. Can anyone tell me what table feeds that Report Manager UI? Is there any way to add them back somehow? Any thoughts or suggestions would be greatly appreciated!!


  • 2.  RE: Post-upgrade, Report Manager is no longer showing

    Posted 03-09-2018 10:46
    Any particular version?


  • 3.  RE: Post-upgrade, Report Manager is no longer showing

    Posted 03-09-2018 10:54
    They are in SY_Menu.m4t can you see them in there?


  • 4.  RE: Post-upgrade, Report Manager is no longer showing

    Posted 03-09-2018 10:55
    Here are some tech notes from the way back machine. but it seems to be going the opposite way that you want. **Try at your own risk....**. **First thought** Example: Found that we had duplicate reports on the menu and would not go away. Best Support gave us the following information that worked for us: Found that we had to edit a file. BAckup in the mas_system folder the sy_menu.m4t go into DFDM and select the sy_menu.m4t file find the duplicate menu items and delete them. then we must refresh/Compile the menus: From the MAS 90 Business Desktop select File / Run. Type SYZCON and click OK. At the -> prompt, enter the following and press Enter after each line. ->menus=new(""sy_menu_svc"",%sys_ss) ->? menus'compilemenu() Note - The compile menu will return a 1 for success and a 0 for failure ->drop object menus ->bye . Version 4.20 and later: 1.On the Sage MAS 90 or 200 File menu, click Run. 2.To start the Menu Maintenance program, enter SY_MENU_UI 3.Click OK. 4.Click Accept. Note: In version 4.20, the progress bar does not open immediately after clicking Accept. 5.Close the Menu Maintenance window. 6.Exiting and restarting Sage MAS 90 or 200 may be required **Or this one...** How to remove reports from Custom Report that have been deleted through Report Manager Resolution ID: 438688 Entry Type: Informational Product: Sage MAS 90 ERP, Sage MAS 200 ERP Application: Library Master Version Reported: 4.0 Subject: How to remove reports from Custom Reports that have already been deleted through Report Manager. Possible Resolution: Delete the records from Data File Display and Maintenance, and recompile the menus. 1.Open Library Master / Utilities / Data File Display and Maintenance. 2.In the 'Filename' field, enter ""SY_MENU"" (without quotes). 3.Browse to the record that references the report that needs to be removed, and click the 'Delete' button. 4.In the 'Filename' field, enter ""SY_TASK"" (without quotes). 5.Browse to the record that references the report that needs to be removed, and click the 'Delete' button. 6.In the 'Filename' field, enter ""SY1RPM"" (without quotes). 7.Browse to the record that references the report that needs to be removed, and click the 'Delete' button. 8.SY1RPP ALSO 9.In the 'Filename' field, enter ""SY1FRM"" (without quotes). 10.Browse to the record that references the report that needs to be removed, and click the 'Delete' button. 11.Recompile the menus. a.From the Business Desktop, select File / Run. b.Type ""SYZCON"" (without quotes) and click 'OK'. c.At the --> prompt, enter the following and press ENTER after each line: menus=new(""sy_menu_svc"",%sys_ss) ? menus'compilemenu() drop object menus bye Note: The compile menu returns a 1 for success and a 0 for failure. Version 4.20 and later: 1.On the Sage MAS 90 or 200 File menu, click Run. 2.To start the Menu Maintenance program, enter SY_MENU_UI 3.Click OK. 4.Click Accept. Note: In version 4.20, the progress bar does not open immediately after clicking Accept. 5.Close the Menu Maintenance window. 6.Exiting and restarting Sage MAS 90 or 200 may be required


  • 5.  RE: Post-upgrade, Report Manager is no longer showing

    Posted 03-09-2018 11:08
    version 2018 PU1 PREMIUM... Can see them in SY_Menu table. SYZCON Compile Menu didn't fix, nor did the SY_Menu_UI task.


  • 6.  RE: Post-upgrade, Report Manager is no longer showing

    Posted 03-09-2018 11:14
    I just did a test migration to v2018.1 Premium yesterday and can see the custom reports in Report Manager... so not a consistent program bug for sure.


  • 7.  RE: Post-upgrade, Report Manager is no longer showing

    Posted 03-09-2018 11:20
    Agreed, we did a test upgrade for this client on another server & didn't have this issue either. I'm just lucky this time around I guess. LOL