Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

How we can modify existing index in d365fo.

(0) ShareShare
ReportReport
Posted on by 5,961

Hi all,

How we can modify existing index in d365fo.

For example - Sales Table

Please give me more shed on this 

Thanks!

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,431 Super User 2024 Season 2 on at
    RE: How we can modify existing index in d365fo.

    Hi Arpan,

    The solution would be rethinking the solution direction. It was possible in AX2012 and before to do overlayering and change existing indexes. As mentioned, this is not possible. Suppose you need to move customizations from AX2009 or AX2012 to Dynamics 365 and the index was changed in the past, then you have to be creative and think of another solution for a business requirement.

    An example I encountered myself before. The Form notes (FormLetterRemarks) got extended with more form note types (enumeration) and a business unit field which was also added to the primary key. Due to the business unit field as part of the primary key, it was not possible to do the same in Dynamics 365. This requirement was about having multiple notes on the invoices on different positions (top and bottom) which were different per business unit. In fact there was no need to have the details stored in the FormLetterRemarks table. We created a new table for the layout texts where we could manage to setup the same information and use it on invoice documents. The same requirement was fulfilled but implemented a bit different.

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How we can modify existing index in d365fo.

    As I already said there is no other solution for this. If you change the index, then it will make the existing records collapsed, that's why its restricted.

    Alternate will be adding validation while inserting records into the table via code.

    Thanks,

    Girish S.

  • @rp@n Profile Picture
    @rp@n 5,961 on at
    RE: How we can modify existing index in d365fo.

    It just query. Not required to change now. But if required, then what the solution. So, I am asking...

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: How we can modify existing index in d365fo.

    Hi, It seems you have asked this question few years ago but I think it's still same behavior in F&O

    community.dynamics.com/.../index-in-extension-table

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How we can modify existing index in d365fo.

    From my understanding there is no other solution for this. Changing index through extension is not supported.

    You have option to only create new indexes - Cannot modify existing index.

    Creation of new index won't restrict the standard index fields - It will work along with standard index fields.

    So, I don't think there is any other solution for this.

    Can you tell me why you want to change the existing standard index?

    Thanks,

    Girish S.

  • @rp@n Profile Picture
    @rp@n 5,961 on at
    RE: How we can modify existing index in d365fo.

    Thanks Girish, then what the solution ? If required genuinely to modify index

    Please give me more shed on this

  • Verified answer
    GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How we can modify existing index in d365fo.

    Hi Arpan,

    You cannot modify the existing index on standard tables.

    There is no option to modify existing index event after extending the table.

    Thanks,

    Girish S.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans