Share
ReportHi,
I need to add the new fields in default index in d365 update 8.0.
is it possible to extend the index?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi,
I need to add the new fields in default index in d365 update 8.0.
is it possible to extend the index?
*This post is locked for comments
Thank you André Arnaud de Calavon and Nikolaos Mäenpää.
Hi Gnanaprakash,
In MSDyn365FO, you have to think different than we were used to do in the past. In the past we could change a default index, but is was and is far from recommended. What if it was supported and various solutions did all try to extend the same primary index? It would really break everything. So, there is a very good and valid reason why you cannot change it anymore.
During an upgrade from AX2009 to MSDyn365FO, we also encountered a customization which was done by another partner where the primary index was changed. When I did analyse the real requirement, I was able to find another and even better solution where we only used extensions. In my case we created a new table with some document parameters instead of changing the original one. At the end it appeared to be more logic than they used before and also the performance was better.
We can try helping you finding a better solution using extensions, but like Nikolaos mentioned, you have to provide the business scenario then.
we are trying to include the new customized invetsite field in smmresposibilitiesEmplTable for the index RespRefIdx.
No, it's not possible. Such change would break every standard read, insert and update operation regarding this table, and that's why such changes are not allowed.
You have to come up with a different technical solution to your business requirement.
What is the table? What is your business requirement?
Thank you Nikolaos Mäenpää,
Is there any possibility to extend the default primary index.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (