Announcements
No record found.
I have created a custom entity for a new Table. I need to copy the value of the execution Id from staging table to target table. Please guide the best way to achieve this.
Hi Martin,
I have not heard of this requirement before. Just curious, for what reason do you need to have this?
You can try to create a computed column or virtual field for this. You have to be aware of a performance penalty when you are using virtual fields. See also the documentation: Computed columns and virtual fields in data entities - Finance & Operations | Dynamics 365 | Microsoft Docs
Hi André ,
I need to track the data inserted during each import (Similar to the staging table) and perform some action (Invoicing Sales order)only for that set of data. I guess execution Id is most approriate.
Hi Martin.
Thanks. You can check the documentation I provided above.
I am unable to get the value of the execution ID in any of DataEntity methods.
You already have the data in the staging table (in cases when staging tables are used, of course, e.g. not when using OData or X++). Can't you simply read it from there?
Copying such data to the actual tables looks like a bad data model to me.
1. >> I need to track the data inserted during each import (Similar to the staging table) and perform some action (Invoicing Sales order)only for that set of data. I guess execution Id is most appropriate.
Another option could be to add the checkbox "Invoice posted" and fill it in after sales invoicing. In this case, you will know what data was posted and what data is not posted.
2. One more option is to use postTargetProcess method, where you add post logic
ievgensaxblog.wordpress.com/.../
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 659
André Arnaud de Cal... 465 Super User 2026 Season 1
Syed Haris Shah 304 Super User 2026 Season 1
