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.
Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet.
I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…
Hi,
I want to create a Business Intelligence Report by using Report Manager & Connector.
In this report, I want to get rows from table APPYM of all Companies database.
But first, I need to know which database is actually a company database for Sage…
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…
I currently have a a SAGE 300 2016 Update 4 (on windows 2008 R2) + SQL 2012
I have a new server built on the side that i wish to run SAGE 300 2018 -on Windows 2016 Server Standard + SQL 2017.
I don't see SQL 2017 supported anywhere... is that true…
Hi, I am trying to determine why my GL and AP control accounts dont balance.
Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer.
To this end, I would like to build a query in sql…
