Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Financial Dimension values the active from / active to field has default value and mandatory

Posted on by Microsoft Employee

In AX2012 R2 Cu7, we can create customized financial dimension.

when we create new financial dimension value, I'd like to make active from / active to fields mandatory or I'd like to setup the defaul value to the two fields. 

1856.Capture.GIF

How to archive this?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial Dimension values the active from / active to field has default value and mandatory

    Thank you so much Andre. Business owner really want to have this default value instead of manually entered

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Financial Dimension values the active from / active to field has default value and mandatory

    Hi Simon,

    It is logical to have default no dates. Of course, you can default values, but that is probably not compatible with the backing end dimension values such as departments, item groups, etc. You have to check that.

    On the insert method of the table with dimension values, you can try to add logic to set the two dates. Note that you will have additional effort when you need to extend the validity of the values.

    I would strongly advice against making this fields mandatory as the table holding the data is used for dimensions and main accounts; both for global level as well as company specific.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial Dimension values the active from / active to field has default value and mandatory

    When a user create a new financial dimension, the active from date should be today, the active to date should be one year later. those two fields auto populate the value.

    Currently, when a user creates a new financial dimension, the active from and active to fields both are blank. 

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Financial Dimension values the active from / active to field has default value and mandatory

    Hi,

    What you are looking for requires some coding/system modification.

    What are you exactly looking for?

    That you get the respective code?

    Would be great if you could make this clear.

    Thanks,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans