Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to increase standa...
Finance | Project Operations, Human Resources, ...
Suggested answer

How to increase standard field size in table by create new EDT

(0) ShareShare
ReportReport
Posted on by GIB 64

Hi all,

I need to increase Table : VendInvoiceInfoTable , Field : Num size 20 to 50 and create new EDT size string 50.

Now change EDT filed Num (extension table :VendInvoiceInfoTable ) I getting error like below


Error Path: [AxTableExtension/VendInvoiceInfoTable.Customizations/Fields/Num/ExtendedDataType]:The extended data type 'NewEDI' is not derived from 'Num'. Project_Customize (VAR) [Customizations] K:\AosService\PackagesLocalDirectory\Customizations\Customizations\AxTableExtension\VendInvoiceInfoTable.Customizations.xml

I'm not sure, I can add new EDT standard filed or not ?

Any suggestions to resolve.

Thanks your advance.

  • GIB Profile Picture
    GIB 64 on at
    RE: How to increase standard field size in table by create new EDT

    Thanks all for your advice.

    My solution is extension base EDT and increase size only , which will affect the all places.

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How to increase standard field size in table by create new EDT

    Are you saying that Extended data type lookup not showing your custom created EDT under table field properties?

    Can you try using string50 standard EDT and see if the same error throws?

    Thanks,

    Girish S.

  • GIB Profile Picture
    GIB 64 on at
    RE: How to increase standard field size in table by create new EDT

    Yes, correct the changing the size that impact all the places. I want it to happen only in the table. I think create new EDT and changing the extended data type at filed in table but I have found a problem for filed standard.

    - Create new EDT and set size 50

    pastedimage1686056742987v2.png

    - Go to table extension , Go to filed standard and changing "Extended data type" but I getting error.

    I notice the expand "Extended data type" , I could not find the new EDT but show all the specific extend EDT "Num"

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How to increase standard field size in table by create new EDT

    I think changing the size of the standard EDT will affect all the places where it is used. I think that is not recommended.

    Thanks,

    Girish S.

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How to increase standard field size in table by create new EDT

    Hi Wathanavipa,

    I am not sure what the error is about, but my suggestion will be instead of creating new EDT - You can use standard String50 EDT - You can set the label and help text for the field in the table field properties.

    Thanks,

    Girish S.

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,547 Super User 2024 Season 1 on at
    RE: How to increase standard field size in table by create new EDT

    Hi, Instead of adding new EDT, you can increase the string size of EDT via EDT extension. You can only modify the value if the EDT does not extend from another EDT.

    learn.microsoft.com/.../modify-edt

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans