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

by | Updated December 29, 2017 | Dynamics AX, Financials

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

2 Comments

  1. Sharon Nolan

    Hi Jessie!

    Great article. I’m going to tuck this one away for review after we get through our AX12 upgrade. I am sure we can figure out a way to use the Advanced Rules someplace.

    FYI: I had to smile when I received the email with the Blog updates. I had a hunch who authored the article you wrote before I even clicked on Read More!:}

    Good stuff!
    Sharon

  2. Brandon Carmichael

    Hi Sharon – it’s great to hear from you! I hope your upgrade is still moving along well and that your go-live is in sight. And I hope you can find a great way to use advanced rules – something like the old dimension of “purpose” might be a good candidate. If you’re going to AXUG Summit in Nashville I’ll see you there!
    -Jessie

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

august

12aug10:00 am10:30 amWhy Levridge Grain? How to Achieve Efficient and Accurate Scale Tickets

12aug12:00 pm1:00 pmThe Three Paths to Dynamics 365 Finance and Supply Chain from Dynamics AX

13aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Inspire Keynote Breakdown

19aug10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

19aug12:00 pm12:30 pmThe Modern Manufacturer - Death by Safety Stock

27aug12:00 pm1:00 pmConfab with Stoneridge - Livestream - Dynamics 365 2020 Wave 2 Preview

september

02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

09sep10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X