We have used Vivid reports for several years. Vivid Reports uses an Excel interface, can consolidate all your GP databases and drills down into GP Transaction Details.Vivid Reports: BI & CPM Software Solutions
Hi @Joy JiangSome excellent suggestions have been made.Here's my take:
Jet Reports is an Excel Integrated tool for financial Reporting (income statements, Balance Sheets, etc). They provide a FREE tool for financial reporting (Microsoft pushed them as a "replacement" for MR a couple of years ago). This free version is a "no consolidation" tool so works only with single databases at a time. They have other versions that are at a cost that can do more complex reporting - up to an Enterprise version that has a datawarehouse, etc. They can report on even sub-ledger data (not just financial data)https://www.jetreports.com/jet-express/jet-express-for-gp/Solver (BI360) is another highly acclaimed tool with the same functionality as Jet and they are awesome as well. They can report on even sub-ledger data (not just financial data)https://www.solverglobal.com/ActivReporter is another awesome and low-cost tool that is excel integrated - they focus ONLY on Financial data, but. OMG they are great!https://nqativ.com/activreporterSSRS and SmartLists are not awesome for financial reporting tools, but if you have a talented developer on staff these can also be utilized.There are many, many other tools out there. I would recommend you do some research first to find the right fit!