Sage 100

 View Only
  • 1.  Report Settings

    Posted 10-09-2019 14:43
    Does anyone know of a way to set the reporting settings for all companies and all users?
    My client has over 100+ of GL and AP companies and would like to set the "Print Comments"  to Full and "Print Condensed" On for all the companies on the GL Detail Report.

    I know that I can create new report setting for each company and these settings will save. However, they are consistently adding new companies.
    The form and layout does not need to change, just the option to full comments and in condensed mode.

    Any ideas?
    Thank you
    Michael

    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    Birmingham, AL
    ------------------------------


  • 2.  RE: Report Settings

    Posted 10-10-2019 08:55
    If you're on Premium, you can create a view or stored procedure that you could run every evening to force every SY_ReportOption.ReportID = GL_DETAILREPORT_UI's OptionString to have CB_SUMMARIZEDETAIL$="N" and CB_CONDENSEDPRINT$="Y".  

    If you're on Std/Adv, maybe you could write a BOI script to accomplish the same, but I'm not too sure.

    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------