web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Enable 'Change trackin...
Finance | Project Operations, Human Resources, ...
Suggested answer

Enable 'Change tracking' for virtual F&O data entity error: Change tracking cannot be enabled...

(2) ShareShare
ReportReport
Posted on by b_radlyjames 3,155
Here is what I did to support this change:
  1.  Create extension of HcmWorkerEntity in F&O
  2. Set HcmWorkerEntity property 'Allow Row Version Change Tracking' to 'Yes'.
  3. Activate HcmWorkerEntity as virtual entity via power platform.
  4. After activation, go to activation form for virtual entity and select 'Change tracking'
After doing these steps I receive: Change tracking cannot be enabled since F&O entity HcmWorkerEntity uses a custom query
 
What 'custom' query is it referring?  Could this be the 'defaultCTQuery' that is on the HcmWorkerEntity?
 
I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 236,289 Most Valuable Professional on at
    Enable 'Change tracking' for virtual F&O data entity error: Change tracking cannot be enabled...
    A custom query for change tracking in an F&O entity means writing an X++ method returning a query object rather than letting the system to analyze the entity structure and decide which tables needs to be taken into account. You can see an example in Enable change tracking for entities > Custom query for change tracking. It's used, for example, when the entity uses a view as a data source and you want to enable change tracking for those tables.
  • Suggested answer
    Jakob Trasbo Profile Picture
    Jakob Trasbo 16 on at
    Enable 'Change tracking' for virtual F&O data entity error: Change tracking cannot be enabled...
    A custom query is not allowed for Row version change tracking. 
     
    Many exising entities use a custom query and they must be rewritten to support Row version change tracking. 
     
    Row version change tracking has some rules before the entity is valid. See https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/rowversion-change-track
     
    Row version change tracking is needed to support features like Synapse integration.

    A long list of entities contains BIEntity is designed for Row version change tracking.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,188

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 868 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 593 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans