DimensionOrderBlog

When you setup dimensions and activate them using account structures in Microsoft Dynamics AX, the order of the fields on forms displaying the default dimensions is alphabetically on name. This post will inform you how to change the order without customizing your Microsoft Dynamics AX environment.

There have been some blogs related to this topic. The ones I found always showed a solution where you needed to customize the system. One of these blogs is from Munib Ahmed. He is also one of the current Microsoft Dynamics AX MVPs. This could be a good solution, but when possible I would like to avoid customizations. So this blog will describe a way to achieve the requirement for another order of the dimensions using standard setup.

Standard behavior

First I will describe the standard way how AX will display these dimensions. Assume you have setup three dimensions: BusinessUnit, CostCenter and Project.

DimensionOrder01

We have created two account structure active in a legal entity having the main account linked to these dimensions:

  • Main account, Project, BusinessUnit
  • Main account, CostCenter

On forms like Customer details the dimensions will be displayed in alphabetically order. It is sorted on the Dimension name.

DimensionOrder02

Setup your own order

As mentioned above the sorting is on the Dimension name. So we can change the dimension names having a pattern with a prefix which manages the order. You can see an example in the next screenshot.

DimensionOrder03

When you only change the Dimension name on the forms it will also show the dimensions with the prefix D00#. Per dimension you can setup a Translation.

DimensionOrder04

If you enter the translations for your language (or languages) the translated text will be used as a friendly name.

DimensionOrder05

Additional notes

It is not possible to start the Dimension name with a number. It should be a letter. Also spaces are not allowed.

When you change the name after you have entered the Translated text it will reset the translation to the new Dimension name. So in that case you have to re-apply the translations. Probably a customization as blogged by Munib would be your choice if this would be too cumbersome.

You can leave some gaps in the numbering to be able to easily add new dimensions in between when needed.

 

 

That’s all for now. Till next time!

Microsoft Dynamics AX CommunitySubscribe to this blogger RSS Feed

Comments4
  1. Patrick PerlasJuly 01, 2015   

    Cool tip! Thanks!

  2. imran Ul HaqJuly 02, 2015   

    Good logic, thanks to wake it up

  3. Beth JohnstonJuly 03, 2015   

    Great idea!

  4. Arun GargJuly 16, 2015   

    Nice post

Leave a Comment!

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