Posts

The information you are reading is more than 2 years old and may be outdated. Read new blogs.
Report Design Managing Running and Publishing Reports

This article will discuss the necessity of powerful financial consolidation tools for Microsoft Dynamics GP customers who manage parent company portfolios, while exploring key features and functionalities.

Plenty of Microsoft Dynamics GP customers are managing the financials of a parent company, with multiple subsidiaries.  Combining organizational information from more than one company, sometimes with diverse currencies, can be tedious without a modern financial report writer and consolidations solution.  Data continues to grow in size – and in significance, regarding decision-making for the future of a company.  Executive teams are thus shopping around for an easy-to-use tool for the regular hurdle of aggregating data into unified financial statements.  If you’re a Dynamics GP user who is charged with consolidating subsidiary company data, this article will highlight the few options you have that combine power, modernity, and business user friendliness.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

This article will explore the flexibility and familiarity of easy-to-use, modern Excel-powered financial report writers, so you can get a head start in upgrading your data management and analysis processes.

Financial reporting is arguably the premier tool in the world of Business Intelligence (BI).  For SAP Business One (SAP B1) users, this process can be repetitive, tedious, limiting, and mind-numbing, depending on the software you rely on to put together financial statements.  Data management and analysis is a big task that only gets bigger every year as types and amounts of information continue to grow.  The larger the amount of data and the more diverse the types, the richer the analytics that can inform stronger decisions and strategies for the future of your company.  In this article, I’m going to discuss the power, flexibility and business user friendliness of today’s best Excel-based financial report writers for SAP B1 customers.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

This article will explore the options you have for powerful, ultra-modern financial reporting functionality to accelerate your Microsoft Dynamics NAV experience.

As arguably the most popular facet of Business Intelligence, financial reporting continues to evolve for the modern business world.  Microsoft Dynamics NAV users are probably aware that, like most accounting systems, NAV offers a built-in report designer, simply called Report Designer.  While some organizations can effectively analyze the data they manage and analyze to make decisions by using Report Designer, the tool is limited in its efficacy for most companies of a healthy size.  This article will discuss and zoom in on the options you have for powerful, modern financial reporting for Dynamics NAV, with a specific focus on key feature and functionality considerations you should evaluate before investing in a solution.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

This article will discuss your financial reporting options, so you can have a head start in picking the best report writer that enhances your Dynamics SL experience for you and your team.

A modern, dynamic financial report writer is nearly a necessity for any organization that intends to stay competitive in the marketplace, navigating economic shifts and developing their brand by making data-driven decisions.  This article will discuss financial reporting solutions, with a focus on their features and functionalities, so you can have a head start in finding the right report writer for your Microsoft Dynamics SL experience.

Third party financial reporting solutions grab company financials from your accounting system or other data sources, whether that is directly from Microsoft Dynamics SL with a live integration or from an online analytical processing (OLAP) cube or a data warehouse.  Like most enterprise resource planning (ERP) systems, Dynamics SL has its own reporting function and most SL customers seem to be using Crystal Reports, although a lot of companies are relying on independent software vendor (ISV) report writers because of their power and their flexibility that the built-in tools don’t always offer.  With many third party software, you can craft and reuse report templates that are customized to meet your data analysis needs and answer decision-makers’ questions about trends and trajectories of your company for future plans.  In my experience, it appears that a lot of companies stick with pieces of the Microsoft Business Intelligence (BI) stack or “free” products when moving beyond the built-in Report Writer, but financial reporting is too important these days to default to any certain product just because everyone else usually does.  You should assess the importance of data source integration options, Excel, web, and/or proprietary platforms, and how easy the product is to use, among other aspects.

How you integrate your company data should be at the top of your list to evaluate when investing in a financial reporting tool for SL.  You need to consider which method will best fit your team’s plans for the solution, whether you go live from Dynamics SL or a higher performance integration, pulling information from a data store.  With a live integration, you get up-to-the-minute data analysis right from SL.  And you won’t have to ensure that company data has recently been replicated to a database to get real time reporting.

A data store is its own investment – whether you go with an OLAP cube, data mart or data warehouse.  However, if your company has more Dynamics SL users and are planning to sometimes simultaneously run substantial data queries, it could slow down SL’s server.  Additionally, some data stores can hold different types of data all in one place.

In regard to ISV products for Dynamics SL, BI360 and F9 both can boast live integrations to Dynamics SL and other accounting systems, which is relatively unique in that most rely on data stores to generate reports.  Beyond data integration options, another vital element that should help you shape your decision involves the solution’s platform.

In the finance world, most professionals have been using Excel since undergrad days.  However, some third party manufacturers produce non-Excel reporting solutions, asserting that Excel is a pain in terms of linking and securely managing spreadsheets.  You have to assess how big of an Excel fan you and your team are and decide whether to implement a familiar Excel add-in product or go with a proprietary platform.  Both BI360 and F9 are Excel add-in ribbons that simply enhance the spreadsheet application by zooming in on security, accounting logic, and shared ownership.  With a modern Excel add-in, the familiarity is going to allow you to hit the ground running with formatting.  Excel may arguably be the standard bearer for data analysis and management, but the present and future seems to be solidly in the Cloud.

Cloud computing, or web-based technology, is hosted by a vendor and provides secure access to your data anywhere you can connect to the internet.  When it comes to financial reporting, reports can be generated and run online, inviting collaboration and offering drill-down abilities.  Generally speaking, pure 3rd party Cloud report writers tend to only pull company data from OLAP cubes or data warehouses, so live integrations are not an option, which is different than hybrid web-based, Excel-powered reporting tools.

Because of today’s global business world and the realities of around the clock operations, companies are working collaboratively around the world.  Web reporting is the answer to the business end user needing flexible access to their decision-informing data.  Adaptive Insights and Host Analytics are pure Cloud platforms, while a solution like BI360 is a hybrid Excel-powered, web platform, which means that you can design and run reports in Excel through the add-in ribbon functionality, in the web portal, or via a mobile application for smartphones and/or tablets.  The internet is popular for the flexibility and mobility, but it is important that it is still easy to use for you and your team to build a financial report, especially since you could be on the go.  If a “solution” is not business user friendly, you’re not going to be able to analyze data in the specific way your company needs, negating a true return on your investment.

Relatedly, the mobile device we are all living in has ensured that the future of financial reporting and other BI activities will begin happening more and more on our smartphones and tablets.  Functionalities on our touch screens are developing, but there are a few options to view and drill down into financial reports of your Dynamics SL data. Mobile BI currently offers reporting and dashboard functionality, and this area of BI will likely develop at a rapid pace.

The idea of access to our data with just the tap of our favorite touch screens can sound pretty enticing, perhaps especially to the road warrior.  However, since this is not a fully developed reporting tool (mainly due to the size of the screen and the newness of the product category), you should seek a financial reporting solution that meets your team’s specific needs before a mobile application is a make-or-break feature – at least, for now.   Our relationship with mobile devices, as a society, will ensure that these BI applications will continue to roll out, and in the meantime, the third-party vendors who already have them have a healthy head start.

There is plenty to consider when looking for the right financial reporting solution for your company, and this article was just to get you started.  Solver, Inc. is happy to answer questions and generally review BI360’s easy-to-use Excel, web, and mobile platforms for real-time or data warehouse integrated analysis and collaboration, with the option of email distribution of reports, as the best report writer for Dynamic SL.

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

It is imperative to have a head start in understanding the features and functionalities of financial report writers for Microsoft Dynamics GP, so you can adequately modernize and streamline your reporting processes.

In today’s business world, a modern financial reporting tool is vital in order to use the increasingly large amounts of data to make informed decisions about the future of your company.  However, the number of options for professionals can be overwhelming, especially on top of the growing list of responsibilities we have to complete to remain competitive.  This article will explore and discuss features and functionalities for your consideration when looking to upgrade your report writing tool for Microsoft Dynamics GP.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.
The information you are reading is more than 2 years old and may be outdated. Read new blogs.

Now that Microsoft has retired FRx, report conversions have become a checklist item for replacing the retired financial report writer.  This article will discuss FRx report conversions and the third party reporting tools offering FRx upgrades.

The era of FRx is over – and has officially been over for a little while.  On this blog, I have written about how to replace the Microsoft financial report writer – and the costs associated with that task.  But now, as companies are moving away from FRx, replacing it with Microsoft’s successor, Management Reporter (MR), or even already replacing MR, there is a demand for converting the financial reports created in FRx to the selected new solution.  Logically, some software manufacturers anticipated this and produced a conversion tool, ensuring that the transition in reporting is more automated.  However, as some companies may still be procrastinating with replacing FRx, there is probably a general confusion about options to make this upgrade.  In this article, I’m going to discuss the routes for FRx conversion, so that if you haven’t participated in this important task or have moved on, but still holding on to FRx because you don’t know how to convert your old reports, you will be aware of your options.

Let’s first tackle MR since I know a lot of people went to Microsoft’s replacement, probably by default.  If you are in this boat, you might already know that MR comes with automatic conversions of FRx reports.  MR is the follow up to FRx, and the two products are very similar, with perhaps the main exception being an updated main user menu and some minor feature enhancements (and loss of certain features), so this conversion is not necessarily rocket science.  However, the real frustration with MR is the all too familiar limited features and functionalities.  It is still a proprietary interface, so the familiarity of Excel is not there.  The conversions assist this update, but MR is arguably not much of an upgrade with only providing basic GL reporting, but you can feel pretty confident that your FRx reports will come with you using this financial report writer.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

As a Dynamics NAV user, you should know the functionalities and key features of modern financial reporting tools available on the market today so that you can select the best tool to enhance Dynamics NAV and meet your Business Intelligence needs by generating sophisticated analytical reports.

In today’s business culture, a powerful financial reporting solution is vital for any organization that is dedicated to developing into a competitive, well established corporation.  This article will explore the variety of options and available features, so that you can select the best financial reporting tool to meet your company or finance team’s needs and goals using Microsoft Dynamics NAV as the core data source.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

After decades of providing a simple Excel-based report writer, F9 might be seeing a resurgence of sorts.  But before you rush out to snag this product to replace FRx or Management Reporter, let’s put it to a basic features test.

Originally released in the late 1980s, F9 was initially developed as a DOS add-in and was soon built for Microsoft Windows.  It is a simple Excel add-in financial report writer, and I have heard from a handful of partners that its popularity might be picking up lately.  If you go to their web site like I did, you will see that they position Excel’s popularity as their key sales pitch.  And they’re right on the money.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.
solver-planning-icon

The motivation to replace FRx may already be there, but the cost of doing so is a mystery.  This article will lay out all of the figures to consider when thinking about replacing FRx, Microsoft’s now-retired report writer.

Reporting within FRx just doesn’t cut it for business today, not only because Microsoft officially retired the product a couple years ago.  Reporting software is available to truly accelerate Excel and deliver drill-down, drill-to, beyond the General Ledger reporting features.  Organization-wide, departmental, or even ad-hoc reporting are important capabilities today as the growth and maturity of a company relies on its ability to analyze transactional data.
Read more