Skip to main content

What's New in Budgeting in the New Microsoft Dynamics AX

by Rahul Mohta
Independent Advisor, Real Dynamics,

Attending the Dynamics Technical Conference is all worth the investment. You not only see the new capabilities but also the ability to interact closely with the experts from Microsoft who built the product.

I am personally interested in budgeting planning and control as it forms a strong analytics base for any organization in the world. And budget planning is not limited to only users who use Microsoft Dynamics AX; it can be used as an independent workload along with any ERP or customers on other versions of Dynamics AX.

Microsoft Dynamics AX introduces several key improvements to budgeting functionality. Let's explore those in more detail.

Excel Integration

For any budgeting system to be successful in user adoption, integration with Excel is crucial. Enhancements in Excel integration provide a huge improvements in user experience and productivity of people involved in the budgeting process. Here are some specific benefits of the updated approach: 

  • Layouts make Excel templates useful year after year. In other words, you do not have to build all the templates every year and it reduces the need for testing prior to every budget cycle.
  • Templates eliminate chances of user error, and improvements in the process of designing the template also means less chances for the errors. 
  • Calculated columns instead of matrix fields. This will make Excel templates much faster as aggregated data is pulled into Excel than all the individual rows.
  • Option to choose from alternate templates in Excel. Users have option to define multiple excel templates for given budget planning process and stage. 

Productivity Improvements for Budgeting in AX

Budgeting is now a more integral element of financial management in Dynamics AX. Here are some ...

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Rahul Mohta

Rahul Mohta is a value advisor for Microsoft Dynamics 365. He has solid techno-functional experience in Microsoft Dynamics 365 for Finance and Operations for Dynamics platform evaluation, end to end implementations, strategic initiatives, mergers and acquisitions, roll outs, training and advisory.

More about Rahul Mohta