Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Change Financial Dimension description field size

(0) ShareShare
ReportReport
Posted on by 64

Hi,

The current description field for financial dimensions is limited to 60 char. We have recently liked to a new system that generated contracts and are sending us the ContractIDs and Names via AIF. unfortunately we have had a few of them fail as AX is limited to 60 char and rejects the data coming in. Is it an easy task to adjust the description field size?

Thanks

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Change Financial Dimension description field size

    Please let us know the outcome of your discussion :-) and if there is nothing else open verify the answers to get this thread completed. Many thanks and best regards, Ludwig

  • Shristi_MP Profile Picture
    Shristi_MP 64 on at
    RE: Change Financial Dimension description field size

    Hi Ludwig and Andre,

    These were my thoughts exactly. I needed clarification as the data is coming from a custom-designed system and I asked them to just truncate the description coming through. I can now go back and confirm that decision.

    Thank you very much for your help!

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Change Financial Dimension description field size

    Hello Shristi MP,

    Is it possible that you just trim it?

    As Andre mentioned, from a technical perspective it might be possible but you can run into problems doing that.

    One of those might be your financial reports that are generated in the Management Reporter. Some of them might not work properly anymore and you might have to reset the data mart and refresh them. That is one of the smaller issues that comes to my mind when making such a change.

    Do people really care about the description of your findims when it comes to reporting?

    If the answer to this question is no, then discuss internally whether this change is really needed.

    Best regards,

    Ludwig

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    RE: Change Financial Dimension description field size

    Hi Shristi,

    Usually, AX will trim the value if it exceeds the string size. Possibly you are using xml where a limit is set? Or custom logic which evaluates the incoming length?

    You can enlarge EDT in field length, however, this dimension data model is not the most easy one. You need to verify all occasions where dimension values can be stored. Also check code internally if the descriptions are store in a variable with other EDTs. I do think it is possible, but it has a risk. If you intend to upgrade sooner or later to Microsoft Dynamics 365, you have to review if the same solution can be applied on the current version as well.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans