Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
We have a database for Company A with 10 branches and another database for Company B with 6 branches.
Both using the same COA with Segment-1 as GL Code and Segment-2 as Branches.
We need an Income Statement to show the comparison of branches in one…
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…
We have Sage 300 2019 PU1 installed on two Windows 2019 servers that publish Sage 300 apps in a collection. We push out the applications to their Start Menu via Group Policy. Our users have dual 4k monitors and initially we ran into issues with Sage 300…
I would appricate if some one can help me in resolving the issue we are facing.
Navigate to ‘General Ledger’ -> ‘Financial Reporter’ and then click on ‘Print Financial Statements’ (Step-1).
Select the statement name ‘Balsum01.xls’ and then select…
For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter.
Does anybody built a report on this using…
Hi,
Does someone written and willing to share a SQL statement that is an equivalent of FRAMTA("BALP") from the Financial Reporter?
I am trying to figure out how our GL Inventory account is calculated.
I read one of the discussions to run trial balance…
Hello,
I want to create separate income statements for each segment and save it all on one workbook using Financial Reporter. I understand that you can print the income statements divided by segments as separate workbooks but I do not want to spend…
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.…
Was just doing a new installation of Sage 2018 on Windows 10 machine and kept getting this error. (error 30 if trying to start statement designer and error 3 if trying to print financial statement) Tried all the usual fixes and nothing worked. Even had…
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
…
Hi,
A client has been printing an FR Report for many months now but then she suddently started to receive an error message this week:
"Initializing FR Error (12) : Fail in starting Print Financial Statements"
I tried a few of the usual MS-Excel…
Good day,
I have a problem with my FRView and I am desperate for help.
FRView does not function properly on one of my Servers. The specifications are:
Server 2012 R2
8 Virtual CPUs
16GB RAM
200GB virtual HDD
When an FRView report is…
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…
Learn about report creation and how to visualize your data better with this FREE, five-part video series.
In Starting Out with Sally , you discovered how to make sense of the numbers behind your business, as Sally led you through practical ways to improve…
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…
Client is currently revisiting their chart of accounts as it is making report writing impossible. They are also moving to sage intelligence but I had a quick query.
They are trying to insert
”3135~3135-46~48-"~399,3371-46,3420-46:3420-48,3545-46:3545…
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.
Last week’s blog post, we took a look at some of the Financial Reporter (FR) templates found in G/L Statement Designer to determine which ones were right for you. This week, we want to take a look at some of the issues that you may encounter while in…
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…
