Primary Index need to change on Sales table in D365FO

(0) Share

Report

Posted on by CU05031448-0

1,197

Dear team

As per our discussion with team I might need to change the primary index on Sales Table.

In between , I would like to know how will I handle these scenario. Is it possible to change the primary index?

As I think, if I change the primary index on Sales table, it will impact the existing records as well. If I am not wrong.

Could you please suggest me, how will I handle this situation , so that without hampering the existing data on sales table ,I can change the primary index on Sales Table.

Kindly advise pls.

Thanks in advance.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sohaib Cheema 49,145 User Group Leader on at

Like (1)

Report

Primary Index need to change on Sales table in D365FO

Hi,

You would not be able to change the Primary index via extension of the table. However you can create the additional indexes. You can also add additional validations (to control any behaviour)

Was this reply helpful? Yes No
CU05031448-0 1,197 on at

Like (0)

Report

Primary Index need to change on Sales table in D365FO

Thanks Sohaib

Suppose if I create an additional index on Sales table extension. Say CustIdx...

So, let's assume we now have two indexes like Salesidx (primary) and CustIdx (additional) newly added.

So, when Sales table is executed then how the index will work?

Is it called first Primary index and then additional index. So on...

Am I correct?

Thanks!

Was this reply helpful? Yes No
André Arnaud de Cal... 300,279 Super User 2025 Season 2 on at

Like (0)

Report

Primary Index need to change on Sales table in D365FO

Hi,

As mentioned, you can't change the primary index. What is the business scenario you want to solve? A primary index keeps records unique in the application. For sales orders, this is the sales order ID. I have not seen a scenario myself where this needed to be changed.

You are talking about a second index. What is the purpose of that index? Additional indexes can be used to retrieve data faster in case of filtering, but it also takes more time to insert or update records in case the field is part of an index. Indexes can also be used for sorting purposes.

Was this reply helpful? Yes No
CU05031448-0 1,197 on at

Like (0)

Report

Primary Index need to change on Sales table in D365FO

Thanks Andre for the reply.

Actually I have added one new column in Sales table extension say "MiscSO".

We like to add the field "MiscSO" with Salesidx primary index to make unique. Which is not at all possible.

Could you please provide me alternative solution for this pls

Thanks in advance!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Primary Index need to change on Sales table in D365FO

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Primary Index need to change on Sales table in D365FO

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates