Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Exporting financial dimensions with translations

Posted on by

Hi All,

Im exporting financial dimensions in excel via code. But dimensions are showing EN-US, not in NL. I see that there are code to get financial dimensions translations via code. 

When I am using NL as my default language, shouldnt it export translated financial dimensions? Or should i write code explicitly to get financial dimensions in NL, after checking the default language of the environment?

Please advise.

*This post is locked for comments

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Exporting financial dimensions with translations

    Dimension names are of course different form the values held against each dimension, in most cases those values come from system  tables, and that would imply that everyone entering data and creating new values would be bi-lingual and would remember to create both values and would do so accurately., nd that a field to hold multiple, translations for each data value would exist.

    As far as I know for financial dimensions you can pick up translations of the main account values and also for custom dimension values. You only can enter translation text when < Custom dimension > is selected in the Use values from field in the Financial dimensions form. Normally access control to this would be restricted to finance and not for those who e.g. create items, or projects  

    Some system fields e.g. item description can hold multi language against the field.

    This post will give you an idea of how to extract translations for a custom dimension :  https://community.dynamics.com/ax/b/yasirsmicrosoftdynamicsaxworkshop/archive/2017/12/06/translation-text-of-custom-financial-dimension

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Exporting financial dimensions with translations

    Hi NoobDaxCoder,

    Do you have all financial dimensions in English and Dutch language?

    Best regards,

    Ludwig

  • NoobDaxCoder Profile Picture
    NoobDaxCoder on at
    RE: Exporting financial dimensions with translations

    Hi Andre,

    Thanks for response. The translations are provided in the environment.

    I wrote code to get translation from this table DimensionAttributeTranslation.

    dimensionAttributeTranslation.DimensionAttribute == dimensionAttribute.RecId

                                                       && dimensionAttributeTranslation.LanguageId ==  (new xInfo().language());

    Back to original question. I assume some set up was not done correctly? So it is not yielding the desired translations. Please advise.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Exporting financial dimensions with translations

    Hi NoobDaxCoder.

    There is no translation tool within the application itself. Check if the setup was done and a user did actually provide the required translations.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans