• Sage300 GL Financial Report print to file error

    Sage300 v6.0 using RDP. only one user has problem. FR Preview is normal. When generate report by print destination as file. a blank error message open. the file select screen's capture is adnormal If ok, it will hanged. Any hints?
  • FR report showing zero balance rows after upgrading to Sage 2022 and excel 64bit

    Hi, Our current / prior income statement now shows zero balance rows after upgrading to Sage 2022 and excel 64bit. The report worked with the previous version of Sage and excel 32bit. "Z" is in column C. I have a formula in column J that calculates…
  • Financial Reporter by Account Group - No data showing

    Hi, I'm trying to create an income statement FR report but this time I would like to categorize by account group which I've never done. I've followed all the instructions in the FR manual but its still showing no financial data. Here is the breakdown…
  • Sage 300 2014/2018 with Microsoft Excel 2010 32 bit

    Is there a work around or fix available for FR Reporter not working or playing up for sage 2014/2018 versions with Excel 32 bit office 2010. Get the error below when executing reports "PrintReport: Error on opening the xla macro. Have received…
  • How ro pull an FR Reports where some column are based on a Transaction Optional Field Value?

    Hi, I need to make an FR report where I have these columns: YTD - Quarterly, Pretty easy so far. Now they have asked for some sections to only show amounts where a GL Optional Transaction field named XX has a Value in it. I know we can use FRPOST…
  • Sage 300 2018 Upgrade done but FR error when running Financial Designer

    Hi, If I tried to run Financial Designer I get this error cmdStart : Error on running Installed Addin And XLStart in xla macro. I put macro settings to enable all macros but not luck, Any idea? Thank you
  • Sage 300 2017.2 - Financial Reporter, Excel 2016 32 bit

    Hi, I am unable to run any report: I get a message box that says: Initialising FR Error (12): Fail in starting Print Financial Statements and when I push OK, another box, pops up: Error: PrintReport:Error on running StartGL9100 in macro …
  • Conditional Formatting

    Have a question about Excel conditionally formatting within the Financial Reporter. I have a FR report with different columns for each division......is it possible to format that column either red or green depending on if that division is showing a…
  • FR Print to Excel - Excel file opens at bottom and not the top

    When the report is printed to an Excel File and you open it, the file opens at the bottom of the report. This report is several pages long and is emailed to management and people dont like to have to scroll up to the top all the time. Can something be…
  • Sage 6.1 PU4 - Excel 2013 32 bit "cmd Start : Error on creating Excel object - Excel not licensed"

    Hi We have a client running 6.1 Sage ERP 300 with SP 4 installed. They are using Excel 2013 32 bit which PU2 says makes compatible but when we run we get an error saying it cant open excel as excel. I ran a repair on excel in control panel. Ran…
  • Two versions of Excel and Sage 300

    My customer is still on 6.0 and updated to Excel 2013. I know we can install Excel 2007 until he upgrades. Is there a way to force FR in 6.0 to use Excel 2007 since 2013 is not compatible?
  • Automate the running of multiple F/S on Accpac Online

    Hi All, I have a Customer on Accpac Online and they have over 30 separate F/S (Financial Statements) created in FR that they would like to automate the printing of. Outside or creating a Macro, does anyone have any suggestions or know of any 3rd parties…
  • FR Report Designer - no network drives shown in the File>>Open area

    Hi all, Strange FR behavior - when opening the FR Report Designer then going to the File>>Open area to select a report to modify, the only contents are the C drive of the workstation. If we close out of FR and launch Excel from the desktop I can see…