Matthew Felzke
Data Warehousing for Manufacturing Companies using Dynamics AX

Photo taken from Shutterstock

This article will detail the effects of a commercial data warehouse for manufacturing and distribution organizations utilizing Microsoft Dynamics AX for their financials.

Data is the rightful buzzword for this era of business, perhaps especially for manufacturing and distribution organizations trying to meet their roadmap goals.  As data continues to grow in size and significance, data warehousing becomes a related task for modern business.  Even if you know a thing or two about data warehouses, you might have some questions or curiosities about them and how they relate to your manufacturing and/or distribution analytical processes.  Who manages a data warehouse? Are they like anything besides an OLAP cube?  At what point should a manufacturing and/or distribution corporation install one?  Cloud or on-premise?  How do we set up a data warehouse?  As a manufacturing or distribution Microsoft Dynamics AX customer, you likely have at least one of these questions.  This article will do the work of answering some of the more frequently asked questions, so you can more clearly see how data warehousing can be a solution for data management objectives with Microsoft Dynamics AX.

Continue reading

Hanna Kim
Excel- and Web-based Budgeting for Microsoft Dynamics GP

This article will focus on platform options when investing in a new budgeting tool.

budgetingfordynamicsgp

Look, it seems like I’ve talked about anything and everything about budgeting so I went directly to the source – a team of consultants. I asked them what the common problem they face with their clients when it comes to budgeting, and surprisingly, they all had the same answer. The majority of their clientele has never had a professional budgeting system, nor did they have a satisfactory budget model that reflected how their business operates. As mentioned in the budget tools for Microsoft GP users replacing Forecaster article, there are around 48,000 GP customers out of 200,000 Dynamics ERP users, and if your company is either one of the 2,000 companies using Forecaster as a budgeting tool or one of the 90% or more organizations who create their budget in homegrown Excel models, this article is for you. In this article, I will discuss Excel- and Web-based Budgeting for Dynamics GP. Continue reading

Hanna Kim
Excel-based Budgeting Tools versus Web-based Budgeting Tools (Budgeting Series)

This article focuses on the difference between Excel-based and Web-based budgeting tools.

Choosing the right budgeting tool is extremely important for a growing company. Many financial companies use homegrown Microsoft Excel models extensively in their budgeting, but there are some limitations that are inherent in the application. I admit Excel is a great tool for modeling and analysis, but it is not the best tool to use for budgeting. Software companies are developing commercial budgeting tools that are Excel-based and Web-based to stay familiar with the features and functionalities that most professionals are accustomed to. In this article, we will explore the advantages and the drawbacks of both Excel-based and Web-based budgeting tools that organizations experience. This article is the third installment of our series on budgeting: Excel-based Budgeting Tools Versus Web-based Budgeting Tools.

Continue reading

Hanna Kim
Budget Consolidation in Multi-Entity Organizations (Budgeting Series)

This article focuses on consolidating finances from multi-entity companies.

Photo taken from Shutterstock.

Photo taken from Shutterstock.

Nobody likes growing pains, but every company wants to grow. Growing pains are symptoms that an organization needs to make a transition. It is the nature of business. There is a way to alleviate these pains through automated consolidation of your company’s budget. Budget consolidation, just like financial consolidations, is growing in significance because of reasons such as globalization and the popularity of acquisitions and mergers. Nowadays, it is not uncommon for a mid-sized organization to own many legal entities in different locations. Although a business’ budget consolidation requirements may not be that complicated, creating a set of consolidated accounts can be time consuming and prone to many errors if done in Microsoft Excel spreadsheets. There are many financial consolidation tools and solutions that can also automate the consolidation of your budgets and they can replace or improve existing processes and systems. This article is the second installment of our series on budgeting: Budget Consolidation in Multi-Entity Organizations.

Continue reading

Matthew Felzke
Professional Services Reporting with Microsoft Dynamics SL

This article will discuss financial and operational reporting options for Professional Services organizations using Microsoft Dynamics SL, so you can invest in the right software for your team.

In the modern business culture, perhaps especially for Professional Services organizations, a powerful, user friendly report writer is essential to staying competitive in your sector, navigating the ebbs and flows of the economy through smarter decision-making, so you’re continuing to evolve as a business and a brand.  In this article, I’ll lay out some of your options for today’s quality financial and operational reporting solutions, zooming in on features and functionalities, so you can make the best investment to expand your Microsoft Dynamics SL analytics as a Professional Services organization.

Continue reading

Matthew Felzke
Retail Consolidations for Microsoft Dynamics NAV

This article lays out your options for modern financial consolidations solutions to take Microsoft Dynamics NAV processes to the next level for retail organizations.

There are plenty of Microsoft Dynamics NAV retail users who are managing a parent company’s financial portfolio with one or more subsidiaries.  Combining transactional and operational information from a number of entities, at times with multiple currencies, can be a challenge without a modern financial consolidations tool.  As the size and significance of data continues to grow, organizational decision-makers nearly require a software that can assist in consolidating data into a unified set of financial statements.  If you’re relying on Dynamics NAV for your retail business, this article will aim to lay out your options for a business user friendly, powerful consolidations solution.

Continue reading

Matthew Felzke
Is Forecasting Becoming More Important than Budgeting?

This article will discuss the difference between forecasting and budgeting, specifically in the context of which process might be more important to modern business planning.

Recently, I was talking to a finance professional who oversees accounting processes and helps his organization make decisions about the future in regard to budgeting and forecasting.  He posited that forecasting might be more important to running a business today than traditional budgeting – and it made me think.  I’m always writing about the constantly evolving world of technology and the fast pace of today’s business culture, so shifting away from a traditional way of accomplishing data management and analysis tasks sparked my interest.  Thus, this article will explore the differences between budgeting and forecasting to hopefully arrive at a better understanding of what is more impactful and productive to business today.

Continue reading

Matthew Felzke
Professional Services Budgeting for Dynamics AX

This article discusses budgeting and forecasting solutions for Professional Services teams, zooming in on the top feature and functionalities for Dynamics AX users.

Budgeting can be challenging, regardless of your industry, but fortunately, it is getting more dynamic and user friendly with today’s solutions to upgrade your Microsoft Dynamics AX tasks.  For Professional Services organizations, planning is just as important, but is unique to the nature of the sector – and this is true for most industries, regarding particular budgeting demands.  Plenty of companies are still utilizing Excel for homegrown budget processes, but today’s budgeting demands are more sophisticated than what the spreadsheet application can deliver.  If you’re seeking an independent software vendor (ISV) budgeting tool that enables you to pull historical data from Dynamics AX, as well as payroll and other company- or industry-specific data sources for an aggregated financial plan that is the result of collaboration, this article is a must-read.

Continue reading

Matthew Felzke
Data Warehousing with Dynamics GP for Professional Sports Teams

Data warehousing is a powerful way for Professional Sports Teams using Microsoft Dynamics GP to manage diverse data types and produce richer financial reports.

Nowadays, the amount of data you are working with can be massive, maybe especially for professional sports teams.  Since data correlates directly to advertising, performance, profit, and so on, data warehousing can assist professional sports teams in staying on budget and on track with owners, players, administrative staff and the finance team.  Maybe you’re not that familiar with a data warehouse solution, so you have several questions.  This article will aim to offer answers that speak to your questions, so you can better understand how data warehousing can expand professional sports team data management and analytics from Microsoft Dynamics GP and additional data sources.

Continue reading

Matthew Felzke
Retail Consolidations with Microsoft Dynamics AX

This article will discuss your options for the best financial consolidations solution to expand your Microsoft Dynamics AX experience as a retail company.

There is a population of retail Microsoft Dynamics AX users who are overseeing the financials for a parent organization’s multiple subsidiaries.  Aggregating operational and transactional data from multiple entities, sometimes with more than one currency, can be challenging without one of today’s financial consolidations solutions.  As the amount and importance of data steadily grows, corporate decision-makers can’t avoid needing a solution that can help consolidate information into a singular set of financial reports.  If you are using Dynamics AX as a retail company, this article will hopefully help you familiarize yourself with options for an easy-to-use, dynamic consolidation software.

Continue reading