How to use Fixed Financial Dimensions in AX 2012 R2

by | Apr 4, 2013 | Dynamics AX, Financials

AX 2012 R1 did not allow you the ability to fix a financial dimension value for a given main account. However, AX 2012 R2 has added functionality allowing you to fix a financial dimension value for a given main account. This ensures that regardless of other financial dimension assignments used on a particular AX transaction, posting to the main account for which you’ve defined a fixed dimension will always use that fixed financial dimension value. The key towards using fixed financial dimension values in AX 2012 R2 for a given main account is to use the ‘Select the level of main account to display’ option in the Main accounts form. When this is set to ‘Companies’ you can map your individual companies and an additional fast tab called Financial dimensions fast tab becomes available.

Please consider the following example on how to use fixed financial dimension values in AX 2012 R2:

Assume that you have a main account ‘110110’ in your Chart of Accounts, for which you want to make sure you always have a Department financial dimension value of ‘022’ posted with the main account.

You would start by going to General Ledger | Common | Main accounts to open the Main accounts list page. Within the Main accounts list page, you would double-click on the ‘110110’ main account to open the Main accounts form. Once in the Main accounts form, you should select ‘Companies’ from the ‘Select the level of main account to display’ field.

How To Use Fixed Financial Dimensions in AX 2012 R2

You can then click the green Plus button to the right of the Companies field and select the individual company for which you want to assign a fixed financial dimension value for. In my example, I’ve used the green Plus button to select the ‘USSI’ company.

How To Use Fixed Financial Dimensions in AX 2012 R2

Now that I have the ‘USSI’ company selected in the Companies field, the Financial dimensions fast tab appears at the bottom of the Main accounts form. When I expand the Financial dimensions fast tab, I can select ‘022’ in the Department field and specify ‘Fixed’.

Fixed

I can now close the Main accounts form. At this point, any future postings against the 110110 main account in the USSI company will always associate the ‘022’ department financial dimension value. As an example, I will simply create a GL journal using the ‘110110’ main account. You will see that the ‘022’ department defaults in.

How To Use Fixed Financial Dimensions in AX 2012 R2

When you then post the journal, the ‘022’ Department financial dimension value will always be passed in. I can see from the posted voucher (clicking on Inquiries | Voucher at the top of the Journal voucher form) that the ‘022’ Department financial dimension value was passed in.

How To Use Fixed Financial Dimensions in AX 2012 R2

In this example, I’ve articulated how this works using the example of a simple GL journal. However, where this fixed financial dimension value becomes more valuable/advantageous is in those unique types of subledger tranasctions where you need to ensure that a main account always has a specific financial dimension value passed in to ensure accurate financial reporting.

Ryan Kleven

2 Comments

  1. Tahseen

    Hi Ryan,
    Am into an implementation where, I have a previous company A using AX for its transactions for an year now.
    Am now implementing company B (same instance) with a partner. I am told that we cannot have a separate set of financial dimensions for company B. Your answer will be appreciated.

    Thanks,
    Tahseen.

  2. Dalton Roll

    Hello Tahseen,

    I have spoken to a couple of our functional consultants, and I received the following answer.

    Financial dimensions are shared between all companies. With that being said, you use the “Account Structures” to deem which financial dimensions are used per company, per account so per say you can have separate financial dimensions per company.
    1. Create any new dimensions needed for Company B.
    2. Go to GL > Setup > Chart of accounts > Configure account structures
    a. Setup the account/financial dimension hierarchy for company B. This could use existing dimensions from company A, the new dimensions created for B, or a combination of both.
    3. Activate the new account structure or structures created.
    4. In company B, go to GL > Setup > Ledger and select the account structures that will be used for the company. This will make the dimensions selected in the account structure active for company B.

    Regards,
    Dalton

Submit a Comment

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

Upcoming Events

april

08apr10:00 am10:30 amLicensing Preparedness for Dynamics 365 Customer Engagement

08apr12:00 pm1:00 pmMaking Project Information Management (PIM) a Priority

08apr2:00 pm2:30 pmFeatures in the Spring Release of Dynamics 365 Customer Engagement Users Can Take Advantage of Immediately

09apr11:00 am12:00 pmConfab With Stoneridge - Livestream - Portals

13apr11:30 am12:30 pmStoneridge Connect Online Keynote: Business Transformations Throughout History

14apr8:00 am5:00 pmStoneridge Connect Online - Day 1

15apr8:00 am5:00 pmStoneridge Connect Online - Day 2

15apr1:15 pm5:00 pmWhat’s New for Developers in Dynamics 365 Finance and Supply Chain Management – Online Workshop

16apr8:00 am5:00 pmStoneridge Connect Online - Day 3

22apr11:00 am12:00 pmPower BI and Reporting with Dynamics 365 Business Central

22apr2:00 pm2:30 pmNew Features for Power Apps Users

23apr11:00 am12:00 pmConfab With Stoneridge - Livestream - Internet of Things (IoT)

29apr10:00 am11:00 amStreamlining Customer Service and Enabling Your Sales Team with a Self-Service Portal

29apr12:00 pm12:30 pmUpdates to the Dynamics 365 Customer Engagement User Experience - What Technical Resources Need to Know

may

06may12:00 pm12:30 pmPower Apps Telemetry and AI Builder - Power Platform Updates

06may2:00 pm2:30 pmImprove Customer Experience with a Mobile Workforce Management Solution

07may11:00 am12:00 pmConfab With Stoneridge - Livestream - Manufacturing

13may12:00 pm1:00 pm3 Simple Sets Your Business Can Take to Embrace the Future of B2B E-Commerce

21may11:00 am12:00 pmEnterprise Asset Management and Manufacturing

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