Sage 100

I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…

SI has a function for "GLActual" that nets the debits and credits. Is it possible to add 2 different functions to get the debit and credit separately? the data exists in the actuals currently included sub report.

Can the reports "GL Transactions incl BegBalances" & "GL Transactions Incl Open Balances" be converted to Consolidation reports? Or, is there a way to set the company code and add the 8 companies as sub-reports?

Has anyone ever created a Comparative Financial Statements for multiple years other then just Actual and Prior using Sage Intelligence? Request is to be able to print Comparative Financial Statements that cover, for example, the last five years on…

How do I add a new connection to a sql server in the same network as Sage 100 cloud?

Sage Intelligence has been tested at high level and found that it works with Excel 2019. However, issues may arise from consistent Microsoft updates. In those cases we will determine cause and method for resolving. In one example, a Microsoft update…

Hello, I am new to Sage and the usage of ODBC. I am able to run through the step in Excel (Get Data -> From Other Source -> Microsoft Query -> Pick my database -> I choose "GL_TrialBalanceWrk" -> select all with no filters) everything runs smoothly and…

Is there a way to do a profit report per customer?

I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…

Want to learn a few tips on using Excel that relate to reporting with Sage Intelligence? Check out the tips available, all relating to reporting. https://goo.gl/LHYfbe You can sign up now to receive these tips in your email or bookmark the page or both…

If you're looking for an easy introduction to Accounting and Financial statements, take a look at the following set of videos provided by Khan Academy: www.khanacademy.org/.../accounting-and-financial-stateme Then if you'd like to see how this is…

A client has 84 companies in their Sage 100 Standard system, which was recently upgraded from v4.50 to v2016. The upgrade was installed on a new Server 2012 and workstations are new Windows 10 units, all exceeding current SPM specs. In Sage Intelligence…

I have a client experiencing some errors I have never seen... They are heavy Sage Intelligence users. We just upgraded to Sage 100c 2016 a few weeks ago and since then their Sage Intelligence has been more error prone than I would like... Here is…

HI There, When I was at Sage Summit I was told that I could find a list of Table Connectors on Sage City, does anyone know where to find this report? I'm trying to find what connectors match up so that I can run an A/P report with some general ledger…

Sage 100 2014 - Server 2008 I am finally finding acceptance in letting go of Frx. I had to go through all the steps of grief. LOL. I have used FRx since the 90s. But it's time to move on, obviously. I have watched both Youtube presentations of Renovo…

FRx reports can be efficiently converted to Sage 100 ERP Intelligence Reporting using the powerful functionality of the Sage Intelligence Report Designer. Sage Intelligence Product Specialist, Sandra Smith, will show you how to simply export existing…

We plan to upgrade the server for MAS90 before year end and move to the latest version of SAGE, would the MAS Intelligence reports carry over, or is there a new reporting package? The IT department has informed me that FRx will not be available on the…

I do not want to use the option "Print the option already printed" I know for sure that there should be a way to print in range without selecting that option. Thank you for your help.

Since the update to Sage 100 2013, staff are asking for FRx migrated reports. How and if that's possible remain a mystery to me. I've installed and licensed our 1 user Intelligence reporting and referred them to learning the product. Is there anything…

"When creating Executive Dashboards for financial reporting, how can I get the information I need from Sage Intelligence Reporting or BI queries" was a hot topic from the Sage City Live networking event at Sage Summit 2013. How are you using Sage Intelligence…