Sage 300

Is Creating a Budget in General Ledger a useful tool or is it better to create the budgets in Excel and export the data from GL?

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?

Hi all, its 2023, can we generate the Financial report with Microsoft Excel 365 now? I remembered last time, it only works on Office 2010. Thank you

We have a customer that is having an issue on 1 workstation only with the financial reporter. It will not generate in preview, but they can print to file. The same statement works from other workstations. It is Sage 300 2021 with the latest Produce…

Hi, One of our client upgraded their Microsoft Office version to Office 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit. Does it compatible with Sage 300 2022 PU2? They need to run FR, but encounters the following errors: Description: PrintReport…

balance sheet does not balance, primarily problem with Net income accts not totaling correctly. No errors, just out of balance. installed 64bit addin correctly. Again, when running in designer no issues, running under print Financial statement icon…

Hello, I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs…

Hi there, I would like to create a budget report breakdown by month in columns side by side, what FR formula should I use for each column? Thanks, Zia

Hi I am creating a trial balance report to breakdown all the month balance for current year and prior year in one report. Our year end closing is on 30 June of each year. The information show correctly for all the months of the current year with…

We tested this feature a couple of weeks ago (financial reports) and it worked fine, we could run all financial reports. Now, after we went live, it stops working with the "Error in running connectcomaddin" in macro. I got it to work 2 days ago and…

Hi Above the FR was working fine with comparison for Current Year & Last Year in Column H & J. But we want to add in the balance for each branch - J001, J002, J003 & J004. which using the segment 2 before the Current year. So I have tested with…

Hi all, I am making custom financial report. How do I check if an account is Rollup, Both, Member, or No as in COA Screen? Is there any function to display Parent-Child Relationship? Thank you.

Hi All, I am making a new Financial Report. After 1st FR View, all the columns and rows lets say column A-E, row 1 to 5, are showing. Then I add more columns (F-H) and row (6-10), the new columns and rows are not showing after FR View. IT even remove…

I've built an FR report. Its very straightforward, I have each individual account listed in column A but grouped together into line items. For example Column A ACCOUNT, ACCOUNT, ACCOUNT, ACCOUNT ACCOUNT, ACCOUNT ACCOUNT, ACCOUNT, ACCOUNT ISSUE 1 I…

I have a report that is pulling info for each my end of years. the .L1, etc works for every year when I use it with BALP, but it only works to L9 when using it with FRFISCAL. My formula is =@FRFISCAL("END","L9"). When I change the 9 to 10 I get the fiscal…

Client wants to exclude certain departments from their financial report and the departments are not sequential. I am trying to exclude them using a formula in Column B. (ACSEGVAL02 != "110") OR (ACSEGVAL02 != "200") It seems that FR does not like…

Sage 300 Financial Reporter - Income statement is not populating but balance sheet does. Has anyone else seen this and how do we fix?

Sage2018 SP2 new server. office 2010, when you launch statement designer comes up with error "cmdStart : Error on opening the xla macro.", if you click close says "cannot run macro RemoveAutoStartFiles" excel macros are enabled and VBA enabled too.…

Sage 300 2018 When the Financial Reporter Balance Sheet is run and the user has their language set to Spanish, the results are different then if the user has English as their language. I tested using same user but only changing their language. The…

Client moving to new software per new owners in a couple of months, so do not wish to upgrade Sage 300. Sage 300 v 2012 local install, data on server. Workstation crashed, wiped and reinstalled. External IT firm installed Office 365 with 32 bit Excel…

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 …

Accpac 2016, PU1, Excel 2016 32 bit. Excel add-on for financial report writer IS added to Excel. Excel is part of Office 365 on the workstation.. When you run the print financial statements function, Excel comes up and it appears to run through all…

Sage 300 v2016 GL Financial Reporter (FR) Is there a way to specify a range of Fiscal Periods that spans between two fiscal years when generating an Income Summary in FR? I have a bank asking an Income Summary from 7/1/2015 through 06/30/16. Coming…

Greetings, I have heard that Financial Reporter will not be supported in Sage 300 2017. Does anyone have any information on that? Thanks,

Hi We just upgraded our clients to Sage 300 ERP 2014 using Citrix. When they print the Financial Report and wanted to save the file, user is unable to see other drive (local drives of individual PC). Any help is much appreciated.