web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX2012 Financial Dimen...
Microsoft Dynamics AX (Archived)

AX2012 Financial Dimensions default value

(0) ShareShare
ReportReport
Posted on by Mathijs van de Wete... 355

Hi, In former AX versions, one could specify a default value per financial dimension per gl-account.

Now, in Ax2012 there is great improvement regarding financial dimensions: structures  and advanced structures, all is there to easily control the combinations of dimensions.

However, the option of a default value  seems to be gone. Very sad as I am looking for this (of course).

Why would I want this: imagine the use of a project as a financial dimension. Other financial dimension must be entered as well because of reporting/analysis requirements. These other dimension can be derivated from the project, ie a project dimension value will point to specific values of other dimensions. To prevent unneccessary clicking/typing, default values would help a lot.

 

Anybody a clue?

Many thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Kim Nelson - Dynamics Profile Picture
    Kim Nelson - Dynamics Microsoft Employee on at

    Hello -

    To set the default financial dimensions on the main account, you need to change the level of main account to display to be 'Company' in the main accounts form. Then you can select the company you want to define the default dimension for.

    The reason the defaulting is at that level in AX2012 is that the chart of accounts can be shared across legal entities but you may want to set up the defaulting differently.

    Thanks - Kim

  • Mathijs van de Wetering Profile Picture
    Mathijs van de Wete... 355 on at

    Tnx, this helped for the level of main account!

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,659 Super User 2026 Season 1 on at

    Thanks in advance, if any one may help me.

    In dynamics ax 2009 we were having 3 financial dimensions i.e. Dept, CostCenter and Purpose. Here in AX 2012, we may use any number of dimensions.

    Where i am struck is, i have created a new form. Now i want to show a interface to user where he may select the three dimensions i.e. Dept, Cost Center and Purpose, by selecting values of drop down.??

    In Ax 2009 we use to create a Relation on Extended Data Type. and by putting name of this Extended Data Type in the window of field where we want to show the DropDown.  For example(in ax 2009), in order to show Financial Dimensions upon my customized or newly created form i use to put the Extended Data Type 'Dimension' in the Properties window of Table's Field, where i have to provide selection of Dimensions to user.

    How to Acheieve this in Dynamics Ax 2012?

    How to provide a drop-down to user for which data is from some other table.?

  • Craig Beattie Profile Picture
    Craig Beattie 40 on at

    Hello Kim.

    I have seen that this is how to apply a default value.  However, I am having an issue with my Balance Sheet Accounts.  For my creditors control account, I have defaulted in some dimensions.

    In my account structure that contains this account, it is set to not allow blanks.

    When trying to post a vendor invoice, it tries to post to the creditors control account, but does not apply the default dimensions set on the account, and instead fails saying that invalid combination ------20000 (20000 is the control account).

    How can the defaults be used?

    Thanks

    Craig

  • Anne Schwarz Profile Picture
    Anne Schwarz Microsoft Employee on at

    To Sohaib:

    • Firstly EDT Dimension (array) is deprecated and replaced with DimensionDefault (Int64 RecId).

    • Financial Dimensions master table Dimension is replaced with DimensionAttribute and DimensionValueDetails.

    • To store these dimension on your customized table then instead of EDT Dimension one should add DimensionDefault EDT.

    • At Form level make use of DimensionDefaultingController class to show the available dimensions.

    To Craig:

    I have the same problem - any answers out there?

  • Sandra Champagne Profile Picture
    Sandra Champagne 70 on at

    Hi,

    I have the same problem but the solution (default value in main account form) doesn't work for me. Do you use the account structure?  I use the structure account and it seems to have the priority before the default dimension.  Right now it works when I create manuel GL entries, but doesn't work for entries created automatically (item group) by posting invoices (AR).

    Thanks!

    Sandra

  • Eric Larsen Profile Picture
    Eric Larsen 70 on at

    Hello,

    I have the same problem as Sandra in 2012.  The AR account won't take the dimensions from the item or the default dimension on the account.

  • Suggested answer
    Eric Larsen Profile Picture
    Eric Larsen 70 on at

    I found the solution to my problem.  I did not have the financial dimensions on the header of the order.  The AR account takes the dimensions from the order header and the sales accounts take the dimensions from the line items.  Makes sense.

  • Sandra Champagne Profile Picture
    Sandra Champagne 70 on at

    Hi!

    Kim write in her aswer: The reason the defaulting is at that level in AX2012 is that the chart of accounts can be shared across legal entities but you may want to set up the defaulting differently.

    My situation: I have 12 companies with 2 charts of accounts. 4 companies shared the same chart of account. Each company have a different financial dimension fixed value for the AP subledger. I did the setup for each company on the main account

    My problem: When I post a invoice journal in AP, AX doesn't work with the good account structure. If I try to post the invoice journal in company ABC, I get error this message: Account structure DEF, for the combination 2000-005, is not valid for ledger ABC.

    Someone have the same problem?

    Thanks you!

     

  • Jaren Profile Picture
    Jaren 155 on at

    Hi,

    I am facing exactly the same problem as Sandra.

    The COA dimension defaulting logic seem to pick up the wrong shared main account from another account structure, causing the error message "Account structure 'other', for the combination 123-x-x is not valud for chart of accounts 'current'

    The main account 123-x-x is same and valid combination for both account structure 'other' and 'current'. but the validation failed because the ledger engine pick up main account from 'other' when user are posting in 'current' company.

    Anyone could shed some light?

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#1
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#1
Pratik Bhosle Profile Picture

Pratik Bhosle 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans