Finance | Project Operations, Human Resources, ...

Copy executionId to Target Table

(0) Share

Report

Posted on by Martin Gumbs

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.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

RE: Copy executionId to Target Table

Hi Martin,

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/.../

Was this reply helpful? Yes No
Martin Dráb 236,025 Most Valuable Professional on at

Like (0)

Report

RE: Copy executionId to Target Table

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.

Was this reply helpful? Yes No
Martin Gumbs 10 on at

Like (0)

Report

RE: Copy executionId to Target Table

I am unable to get the value of the execution ID in any of DataEntity methods.

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

Like (0)

Report

RE: Copy executionId to Target Table

Hi Martin.

Thanks. You can check the documentation I provided above.

Was this reply helpful? Yes No
Martin Gumbs 10 on at

Like (0)

Report

RE: Copy executionId to Target Table

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.

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

Like (0)

Report

RE: Copy executionId to Target Table

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

Was this reply helpful? Yes No