Hi all,
I do researched and posted the scenario based on the above example.
I would like to focus on two change tracking options in D365FO: Primary table and Entire entity.
1. Change tracking set to “Primary table”
Scenario 1: Initial export Suppose I have 100 customer records and no previous export has been performed. The initial export will include all 100 customers.
Scenario 2: New customers added Suppose I add 5 new customers after the initial export. During the second export, change tracking will identify and export only those 5 new customer records.
Scenario 3: Customer addresses updated Suppose I update the addresses of 3 customers. Since the address information is stored in a separate table, LogisticsPostalAddress these changes will not be tracked when change tracking is configured for the primary table, provided the address table is not the entity's primary data source.
2. Change tracking set to “Entire entity”
In this case, change tracking considers changes across the entity's relevant data sources.
Scenario 1: New customers and address updates Suppose that after the initial export:
During the next export, change tracking should identify the 5 new customers and the 20 customers whose addresses have changed both.
My understanding is that if we select “Entire entity” instead of “Primary table” as the change tracking system, both newly inserted records and updated records across the relevant data sources of the entity will be identified during the next export.
***I will discuss the deletion scenario separately.
Could you please confirm whether my understanding of these two change tracking options is correct?
Pls advise, thanks