Finance | Project Operations, Human Resources, ...

Process to populate data in mytabloe without entering into Staging table

(0) Share

Report

Posted on by premK6969

198

Hi there, i got an requirement to populate data imported through Data entities and need to populate in my table without being entered into Staging table. As am new to Data entitied and DMF i request you to update me with the approach to achieve my requirement. In my case i had created MyTable and added some fields. Our client used to import retail orders which were going to be created Online Sales Orders in Dynamics through Sync Online Order process. My role is to populate that particular data into my table before creating SalesOrder. Our consultant insisted me to check RetailSalesTrans Table and postGetTargetData() method in D365. My question here is from which class postGetTargetData() method is used so that i need to create extension for that class and need to call postGetTargetData() accordingly. I request you to suggest the approach to complete my task and coding i need to use for my requirement. Thanks in advance

Regards,

Prem

I have the same question (0)

All responses (7)

Answers (0)

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi premK6969,

Just to better understand your requirement, you have an entity that imports orders and you need to create a records in your table during import based on staging data, but before orders are created?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You can check the cross references of any method in the system (including postGetTargetData) by right clicking it in AOT and selecting "Find references". So far I'm not sure if I understand your requirement, and how staging tables are related to it.

Was this reply helpful? Yes No
premK6969 198 on at

Like (0)

Report

Hi Sergei, yes thats my requirement. Can you let me know the approach for that. Thanks

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

Like (0)

Report

Hi Prem,

Can you describe the business requirement? Is it about moving data to your table instead of the sales order or should it still import in both?

Are you using the retail statement to have the details imported with Commerce functionality or do you have an own data entity?

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi premK6969,

I guess your consultant means special static methods on the entity level, but I haven't heard about postGetTargetData method, maybe you can check methods

preTargetProcessSetBased

postTargetProcess

ievgensaxblog.wordpress.com/.../

ievgensaxblog.wordpress.com/.../

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi premK6969,

Are you talking about the postGetStagingData() method. You can extend the method and update Data entity staging table when you import data to D365FO.

See:rahulmsdax.blogspot.com/.../update-data-entity-staging-table-data.html

Also see the method's calls during import:

defaultCTQuery

copyCustomStagingToTarget

postGetStagingData

preTargetProcessSetBased

postTargetProcess

Anyway, I think it is unreasonable not to update the staging table when importing.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I guess you could also hook into some methods on the Sales order side, such as insert. And if it's a retail order, populate your table.

It really depends what exactly it means when you say "populate particular data into my table before creating SalesOrder".

But, if you run your code before the insert method of sales table, then it's populated before the SalesTable is inserted.

Was this reply helpful? Yes No