How to use Fixed Financial Dimensions in AX 2012 R2

by | Updated June 15, 2016 | 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

Related Posts

  • The much anticipated release of AX 2012 R2 has been announced. Here are the new features that have my attention. I'll be sure to post some detail, as I explore…

  • In AX 2012 you can set the value for a specific dimension using code similar to what is below. DimensionAttributeValue         dimAttrValue; DimensionAttribute              dimAttr; DimensionAttributeValueSetStorage davss; RecId                defaultDimension; davss = DimensionAttributeValueSetStorage::find(this.DefaultDimension); dimAttr…

  • AX 2012 R1 has expanded budgeting functionality, which has been moved to a transaction-based process via the budget register entry. Similarly to AX 2009, AX 2012 allows you to budget both at the…

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

september

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

02sep12:00 pm12:30 pmBest Practices for Work Order Planning and Routing for Field Service Companies

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

09sep12:00 pm12:30 pmOverview of Microsoft Promotion for NAV and GP Clients

10sep11:00 am12:00 pmConfab with Stoneridge - Livestream - Field Service Comparisons

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

16sep12:00 pm12:30 pmHow to Upgrade to Dynamics 365 Finance and Operations: Examining Custom Code and ISV Implications

16sep2:00 pm2:30 pmScheduling and Dispatching for the Modern Field Service Company

23sep12:00 pm1:00 pmDynamics 365 Business Central Wave 2 Release Preview - An Overview of the Most Exciting New Features Coming in October

24sep11:00 am12:00 pmConfab with Stoneridge - Livestream - The Modern Workplace: Teams, Sharepoint, Outlook, Office, and AI Integration

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

30sep12:00 pm12:30 pmEmpowering Your Field Service Technicians with a Mobile Solution

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Orders

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