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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

not able to increase StringSize for EDT 'InvoiceDescription'

(0) ShareShare
ReportReport
Posted on by 311

We have a requirement where we want to increase the StringSize of EDT 'InvoiceDescription'. We can't increase directly because its extended from EDT 'String50'. We don't want to increase the StringSize for EDT 'String50' coz its gonna impact to many other fields. Is there any workaround without without creating new field.

Thanks in Advance. 

I have the same question (0)
  • Suggested answer
    Vishal Dhavgaye Profile Picture
    405 on at

    Correct, you shouldn't be changing string size for 'String50'. you can replace 'String50' with 'String255' on 'InvoiceDescription'. I believe 255 character length is enough for invoice description.

  • Blue Wang Profile Picture
    Microsoft Employee on at

    HI Vinayak,

    Regarding your question, I know two options:

    1. Create and expand the size of String50. This will affect others, as you have already mentioned.

    2. Create new fields and modify functions to use other EDTs, which you don’t want.

    In addition, for the time being, I have no better way.I think you better choose the second option.

  • Suggested answer
    Vishal Dhavgaye Profile Picture
    405 on at

    Hi Blue,

    I don't think we should be creating new field and modify functions to use that EDT as you suggested in option 2. Is it feasible to do this much customization for this change.

    Do you see any issue with the solution i have suggested above?

  • Blue Wang Profile Picture
    Microsoft Employee on at

    Yes, I saw it.

    How replacing 'String50' with'String255' on'InvoiceDescription'? Change directly? Extension?

  • Suggested answer
    Vishal Dhavgaye Profile Picture
    405 on at

    I saw the issue now, EDT extension does not allow to change base EDT.  

    I see this EDT is used on 'vendInvoiceTable' and 'VendInvoiceJour' table. One solution is to create extension for these tables and change EDT for 'Description' field. This does not guarantee that description wont be truncated as any function parameter using this EDT will truncate data but it is worth trying.

    I believe Extension should not have any restriction for length. We are not overriding any behavior here. MS ticket can be submitted for this.

  • Suggested answer
    Joris dG Profile Picture
    17,780 on at

    From an extension, you can only change the base EDT's stringsize, not a child EDT's. The restrictions are the same as they were with over-layering. The main reason is that this "hierarchy" of EDTs is an actual feature used in tables. Changing the stringsize of one of the child EDTs could cause data corruption in any data structures were different child EDTs' values can be stored in a field that uses the parent EDT.

    A typical example of this Inventory Transactions that store a generic "order number" using the NUM EDT. This field could end up getting sales order numbers, purchase, production, etc. that all use EDTs derived from Num. As such, you can't increase the sales order number without increasing NUM or you'd have data problems.

    The main reason people don't like increasing NUM in this example, is because now all fields using an EDT derived from NUM actually get a larger string size which can be irritating due to large forms controls, report layouts, etc.

    We're working on a new feature to address the need of extension without causing data problems or other functional areas' UI being affected. This new feature will be similar to how Real EDTs handle database precision versus NoOfDecimals in UI, and how and when it allows EDT extensions. Will provide more information and documentation when this feature will become available.

  • Vishal Dhavgaye Profile Picture
    405 on at

    That make sense, Its also important that "hierarchy" of EDTs maintained correctly. In this case 'string50' is used as parent EDT for invoice description.

    As 'String50' is widely used in system and most the cases it is parent EDT to some other EDT's. It put restriction on extensibility. I believe it hierarchy should have been 'Invoice description' -> 'Description' where 'Description' is parent EDT. That gives me ability to increase the length thought out system only for description fields. 

    Like in your example why 'NUM' EDT used as parent EDT to all order numbers. why not 'OrderNum' so that in case I want to increase the length of 'Sales order' EDT i should be able to do it without causing an data inconstancy.  'String50', 'String255',..'NUM' there are base EDT derived from primitive datatype and should have not used directly on these EDT's. 

    looking for forward to have some solution around this.  

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 658

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 468 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 333 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans