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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Increase field length ...
Finance forum

Increase field length of a standard table field

(0) ShareShare
ReportReport
Posted on by Sebastian Aurand 1,650

Hello,

I'm currently trying to extend the size of an existing standard table field (MainAccount.Name = str 60 to 120) via a table extension. As the property "size" is locked I tried to set a different extended data type. Unfortunatly is has no influence when entered "hardcoded" respectively no EDT is in the lookup:

5658.8750.Screenshot01.png

1440.0825.Screenshot-2.png

Is it possible to increase the size of string column? What is the correct way to do it?

I'm running 8.1. platform Version update 20.

Thanks in advance for any hint.

Sebastian

Categories:
Development / Customization / SDK
I have the same question (0)
  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    You need to change the EDT properties.

    You can change the StringSize of an EDT using extensions, if following conditions are met:

    - The EDT is not deriving from any other EDT. If it is deriving, please go to the base data type and extend that

    - The base EDT supports changing the length with extension

    The field that you are talking about has EDT AccountName. If you create extension of AccountName edt, you can indeed increase the string size.

    Of course this impacts all places in the system where AccountName EDT is used.

  • Sebastian Aurand Profile Picture
    Sebastian Aurand 1,650 on at

    So it is not possible to extend the field string size through changing the EDT on a table field via a table extension?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    It's not possible.

    You must extend the underlying base EDT to achieve your goal.

  • Ali Zaidi Profile Picture
    Ali Zaidi 4,657 on at

    Create extension for AccountName. Usually two properties are extendable. 1- Label and then length. I test that you can increase the length in extension of Data type.

    EDTextension.png

  • Dante Ramos Profile Picture
    Dante Ramos 20 on at

    Did changing the String Size property in the extension worked? I'm trying to do the same thing with the Name EDT (which doesn't derives from other EDT), but despite full synchronizing database and marking a full build of models, the new size doesn't appear further than my extension, I even tried creating a new EDT and set it as derived from Name.

    Am I missing something?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Doesn't appear where? Did you test it? In AOT it only appears in your extension. 

  • Dante Ramos Profile Picture
    Dante Ramos 20 on at

    Thanks Nikolaos, your comments in this community forum saved me many times.

    I tested it in a new EDT derived from Name but it's size is the name's size (60) not the size I put in my Name extension (200).

    I even checked if it affected other EDTs derived from Name and tables that has fields that uses the Name EDT, but everywhere the string size is 60.

    Thanks in advance.

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Did you really test it in the user interface, and try how many characters you can type in the field? Or did you just look at the properties of fields in Visual Studio?

    Also, please check the field length in the SQL Server database, there you will see what the real length is.

  • Dante Ramos Profile Picture
    Dante Ramos 20 on at

    Thanks for the answer.

    Yes, I tried in the EcoResProductCreation and currency forms, only gets 60 characters in the fields related to the Name EDT. Currency table uses Name directly and EcoResProductCreation uses EcoResProductName EDT.

    In database the currency table's txt field and the EcoResProductTranslation table's name field has the size of 60.

    And I forgot to answer your other question in my last comment, in AOT my extension is the only one made for Name EDT.

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Try to build your model one more time and do a full database sync.

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans