Sage 100

 View Only

  • 1.  Searching for a backdoor to edit font size and format in the GL Financial Reports

    Posted 12-14-2021 17:51
    This is a long shot, but I need to ask.

    Upgrading a client from 2017 Advanced to 2021 Advanced.

    In the current 2017 version, when printing GL Financial reports, the font size of the GL Account number is smaller and bold. The GL account number is large, and it would seem that the font size in this case was changed in order to have it display completely.

    When I print the GL Financials in 2021, all fields and formatting is the same size, and the full GL account cannot be seen.

    These are canned reports, not accessible to crystal reports, plus the Library Master > Setup > Report Format Maintenance allows minimal formatting options.

    Is there a backdoor to get to these canned reports, does that require access to the source code? Is this something that a master developer can do?

    Thanks

    ------------------------------
    John Kerr
    Net at Work
    ------------------------------


  • 2.  RE: Searching for a backdoor to edit font size and format in the GL Financial Reports

    Posted 12-14-2021 18:06
    There are several Crystal .rpt files that you can modify.  However, you have to keep in mind that when you make changes, those changes will flow through to all financials that use that particular .rpt file.

    Look under the Reports folder.  You'll see 3 different GL_BalanceSheet reports, 9 different FinancialReport reports, 4 different GL_Trend reports and 4 different GL_TrialBalance reports.

    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------



  • 3.  RE: Searching for a backdoor to edit font size and format in the GL Financial Reports

    Posted 12-14-2021 20:21
    Wow, @John Kerr, you really have people using the v3.7x reports?  You might be SOL but maybe @Beth Bowers or @Therese Logeais might be able to pull the rabbit out of your hat....  If not, you might have to set them up on FRx.....
    ​​​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: Searching for a backdoor to edit font size and format in the GL Financial Reports

    Posted 12-15-2021 08:35
    Thank you, @Jeff Schwenk, for pointing out that @Therese Logeais and I have been around forever...​​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------

    Original Message


  • 5.  RE: Searching for a backdoor to edit font size and format in the GL Financial Reports

    Posted 12-15-2021 10:15
    Ruh Roh!  Someone is a bit sensitive......  Here I was saying that you both had magical (a la Hermione Granger) powers but oddly it conjured up a great cartoon memory....

    Hey Rocky! Watch Bullwinkle Pull A Rabbit Out Of His Hat! - YouTube


    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 6.  RE: Searching for a backdoor to edit font size and format in the GL Financial Reports

    Posted 12-16-2021 09:25


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

    Original Message


  • 7.  RE: Searching for a backdoor to edit font size and format in the GL Financial Reports

    Posted 12-21-2021 20:56
    @Mary Jo Krueger Many thanks Mary. I had completely forgotten about those balance sheet, trend and financial reports. I found that all the font customizations were in the 9 financial reports in the source version and was able to replicate them and then schedule their go live.

    Thank you , thank you thank you.​

    ------------------------------
    John Kerr
    Net at Work
    ------------------------------

    Original Message


Related Content