Matt Felzke
Dashboards for SAP Business One

There are plenty of functionality and flexibility aspects to consider when selecting a powerful, business user friendly dashboard solution for your SAP Business One experience.  This article will explore your options, so you know what to look for in the best data visualization solution for you and your team.

Dashboards are the number one solution in the Business Intelligence (BI) marketplace: old news?  Not quite. Gartner’s 2013 study on Financial Executive International CFO Technology reported that dashboards, scorecards, and performance management solutions are CFOs’ number one priority.  The fast pace of today’s business world insists that you and your team have easy-to-use, flexible access to data that drives key decision-making.  Data visualizations of company information, like dashboards, are the answer to that need. Continue reading

Matt Felzke
Comparison of Budgeting Tools for Dynamics GP

Using the framework of key features to shop for, like ease of use, budget workflow, and security, this article will compare budgeting and forecasting options for Microsoft Dynamics GP.

Budgeting requires multiple departments entities bringing transactional data together, as well as research, to forecast what will financially manifest in the coming year, regarding revenue, expenses, and other important items. For Microsoft Dynamics GP users, there is an abundance of options for budgeting and forecasting, including manual, homegrown spreadsheets, GP budgeting input, an accelerated Excel add-in tool, or proprietary interfaced software. In this article, I’m going to zoom in on your budgeting software options for Dynamics GP, so you can get a better understanding of the best route for you and your team.

Since you are looking for a solution that business users can utilize, I always think it’s smart to lay out the most important features to look for in a product.  Even if you are the only who will be using the budgeting tool with Dynamics GP, it should be first and foremost easy to use.  I cannot think of one person who gets excited to put together a budget, so the task should be as easy as possible, regarding the user friendliness for non-IT professionals.  In particular, you should be looking for a solution that streamlines the process with accounting and business logic and reusable budgeting templates, amongst other functionalities.  Given the collaborative nature of budgeting, streamlining is a must.

Continue reading

Matt Felzke
Best Budgeting Solutions for Microsoft Dynamics SL

Third party budgeting options for Dynamics SL are empowering CFOs and budget managers to effectively and dynamically plan for organizational and departmental growth, through secure and simple collaboration.  This article will discuss elements to consider when shopping for the best budgeting tool for your team.

I think it is safe to say that budgeting for a business is a task most would prefer to avoid.  Maybe this has something to do with the tedious nature of the tools available to budget managers.  Excel spreadsheets that are formatted into a budget might be okay for household planning, perhaps for a smaller company’s budget, due to the relatively small set of data, but growing corporations using Microsoft Dynamics SL are taking notice of the benefits of a third party budgeting solution to enhance their accounting and finance objectives.  Some of today’s more modern solutions streamline the process of budgeting by empowering contributors through secure collaboration.  Planning and managing profit and loss, employee budgets, project budgets, and other areas of a business is a necessary task so that corporation leaders can operate within their financial means, ensuring progress.

Continue reading

Matt Felzke
Automated Budgeting and Reporting for Microsoft Dynamics NAV

Automation is the functionality that makes all modern BI features that much more valuable.  This article will discuss automated budgeting and reporting for Dynamics NAV as a way to more efficiently analyze company data, so you can get to the other tasks on your plate.

Articles about reporting and budgeting for Microsoft Dynamics NAV are all over the place – in print, on LinkedIn, in search results.  In fact, I have written about reporting and budgeting, specifically for Dynamics NAV, on this blog before.  I would imagine that someone who reads these articles might have a subconscious response to the authors: “Maybe you think that generating reports and putting together budgets – and reading about them – is all I do for a living.”  If this is the case, I understand the sentiment.

Continue reading

Matt Felzke
Best Report Writers for Sage 500

If you use Sage 500, it is beneficial for you to know the features and functions of today’s financial reporting and consolidation tools offered by third party manufacturers so that you can pick the right tool to help you meet company needs and goals for Business Intelligence analysis and reporting with Sage 500.

In today’s data-driven business world, a modern financial reporting tool is a requisite for any company that wants to continue being competitive in the marketplace.  In this article, I will discuss the plethora of options and available functionality offered by independent software vendors (ISVs), so you can navigate the market to pick the best reporting solution for your data analysis needs and goals, powered by business intelligence (BI) analysis, all while enhancing Sage 500.

Continue reading

Matt Felzke
Five Options for Replacing FRx…and Management Reporter is Only One of Them!

Finding a replacement for the retired FRx report writer can be frustrating and overwhelming, but for good reason.  This article will discuss five financial reporting tools as a way to explore the today’s solutions to meet your company’s modern BI needs.

Some people might think the topic of FRx’s retirement is old news – and they would not be wrong.  However, for several years, finance teams around the globe have relied on Microsoft’s free financial report writer, so the transition to a new tool has been slow and in some cases, resistant.  There is an ecosystem of third party products that support professionals by hopefully making Microsoft Dynamics a best-of-breed solution by offering what the accounting system cannot.  Additionally, as the years fly by, technology and the independent software vendors (ISVs) that manufacture Business Intelligence (BI) products continue to evolve at record speeds to meet customer demands for intuitive, powerful, business user friendly solutions.

Continue reading

Matt Felzke
Mobile Reporting and Dashboards for SAP Business One

In today’s increasingly global business world, there’s a growing demand for flexibility, secure collaboration, and accessibility when generating financial reports and dashboards.  This article will discuss mobile reporting and dashboards in the context of meeting modern professionals’ BI needs.

I was recently talking to a CFO of an international company who lived and worked from the headquarters in Seattle, Washington about the limitations and related frustrations he was facing in trying to run his company.  In the past few years, he has been traveling a lot, sometimes internationally, because of a reorganization and the growth of his company.  His team is using SAP Business One and Crystal Reports, but he is currently in the market for a new Business Intelligence (BI) solution that will empower him and his finance team to easily collaborate, report, and generate data visualizations whether they are in the office, in one of their international offices, or even somewhere like an airport restaurant.  Sound familiar?

Continue reading

Matt Felzke
Convert FRx Reports to Management Reporter or Look for Alternative Options?

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.

Continue reading

Matt Felzke
Dashboards for Microsoft Dynamics NAV

When it comes to Business Intelligence, Dashboards are the Most Valued Player these days. This article will explore the features and options, so  you can pick the best Dynamics NAV dashboard solutions for your company’s goals.

Hopefully, you’re aware by this point: dashboards are leading the Business Intelligence (BI) tool marketplace in terms of demand.  Results from 2013’s Financial Executive International CFO Technology study by Gartner proved that dashboards, scorecards, and performance management solutions are the top priority for CFOs.  Today’s fast-paced business demands require that decision-making be user friendly and accessible for all levels of the company – and dashboards or scorecards make company performance analysis straightforward.  More specifically, dashboards are business intelligence visualizations of company data.  Dashboards are scorecards, graphs, and charts that utilize key performance indicators (KPIs) to demonstrate your organization’s trends, successes, and challenges – either collectively, departmentally, or focused on a project.

Continue reading

Matt Felzke
Reporting and Document Management for Microsoft Dynamics, Sage X3 and other ERPs

As document management, reporting and business intelligence comes together, a new era of holistic data and text management begins.  This article will explore the world of content intelligence with a focus on the new product category offerings.

In 2007, Gerry Brown, now a Senior Analyst of Customer Engagement & Marketing Technology for Ovum in London, created the term, “content intelligence,” an aggregation of Business Intelligence (BI) and content or document management for improved insight and decision-making power.   What had been two disparate processes and sets of data became one as a customer driven term.  The concept was simple – professionals would like to be able to not only search for their scanned, virtual documents, but to analyze financial reports and drill down to the text and content that lies outside of already input data in Enterprise Resource Planning (ERP) systems like Microsoft Dynamics and Sage.  The concept was more than just another buzz word; it combined and streamlined two different analyses into a singular, more holistic approach to corporate performance management, and it is really starting to build momentum.

Continue reading