The Beauty of Dynamics AX 2012 Advanced Rules From a Former Hater

By Jessica Swartz | August 10, 2017

The beauty of dynamics ax 2012 advanced rules from a former hater

I remember when Dynamics AX 2012 first came out and I was so excited to see the new Chart of Accounts Structure window. It was beautiful, intuitive and gave more flexibility and visibility than previous versions offered. I was in sweet, sweet accounting software love.

advanced-rules-jessie1

Come on.  Just TRY to not love that window.  I roundly rejected the Dynamics AX 2012 Advanced Rules functionality, saying “Why would I even bother learning about that?  The COA Structure is perfect on its own!”  I even advised clients to setup “corporate” dimensions.  For example, it’s fairly typical on balance sheet accounts for dimensions like cost center and department to be irrelevant. After all, the Accounting department rarely has its own cash account.  So I advised clients to setup a department “00 – Corporate”.  It’s not a BAD thing to do, but it’s a data point and setup that do not provide value.  Still, I left Advanced Rules on the shelf.

I was working on an AX 2009 to 2012 upgrade and saw that the upgrade created a single, basic account structure but a ton of advanced rules. I was incensed!  Okay, incensed is a strong word for any feelings with respect to accounting software configuration, but I was surprisingly riled. Why would Microsoft choose to create all these detailed, hard to follow advanced rules?  Still, it didn’t click.

But then I was preparing for an implementation that was expected to have a fairly complex chart of accounts requirements and I had a little time on my hands.  So *sigh* I sat down with my virtual image, pulled TechNet up on the other monitor and said: “time to attack the Advanced Rules beast.” The example I chose was to use Project as a financial dimension. One can imagine that only a few select P&L accounts would have Project as a relevant financial dimension. Revenue, cost, maybe some G&A or WIP on the balance sheet, but it would be incredibly irrelevant to the majority of the balance sheet and a bunch of the P&L. That’s where Advanced Rules become ingenious.  You can setup a simple little rule that says, for my cost accounts 50000-54999, require the Project financial dimension to be populated.  That’s it!  You don’t have to have multiple account structures that have the Project financial dimension or don’t. Just one that leverages that simple little-advanced rule! Think of it for a Customer financial dimension or an Item Group financial dimension – how perfect and targeted they could be!

advanced-rules-jessie2

Such beautiful simplicity!

My excitement quickly faded to shame.  Shame that I hadn’t learned this functionality sooner and shame that I hadn’t advised my clients better back in the days of AX 2012 RTM.  Here’s the link to the TechNet article I read and that reformed me from being an Advanced Rule hater: https://technet.microsoft.com/en-us/library/hh242096.aspx .  Check out the example – I found it illuminating.  It’s never too late….

Related Posts

Recommended Reading:

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X