Finance | Project Operations, Human Resources, ...

List of method calls while exporting data using Data Entity Export so that I can write my own logic in D365 FnO

(0) Share

Report

Posted on by KaamranKhan

Hi all,

At the time of exporting Data Entity in D365 FnO through Data Management I want to Pass range through code.

Please suggest where I write code in Data Entity.

Its a customize data entity Base Datasource is CustTable and this base Data source I nested CustTrans Table and in this CustTrans table AmountCur Field I want to pass range using x++ code AmountCur>0

I have the same question (0)

All responses (8)

Answers (0)

apa 8,284 Moderator on at

Like (0)

Report

I have moved this to the D365 Finance forum.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi Khan,

you can refer to some standard data entities on how to apply ranges, for eg. you can see in the below example, how HCMWorker table is nested with HCMEmployment table and using a range "EmploymentType" with the value as "Employee". This will result in extracting only Employees from the HCMWorker table.

about adding methods to a data entity, have a quick read on https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-tools/design-best-practices

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entity-computed-columns-virtual-fields

Was this reply helpful? Yes No
KaamranKhan 10 on at

Like (0)

Report

I know how to pass using Data sources range but using a code I need to do it. Because I need to write other logic also

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Where / when would you want this code to run? Could you share your business requirement?

If you use the entity in x++ you can use a select statement for the data entity, and provide range there.

In OData call the range is defined by the caller. In data management project the range is defined in the data project.

And, of course all ranges defined in the entity metadata are always respected.

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

If you are looking list of methods then There are various methods get called while exporting data such as mapdatasourcetoentity, postload etc...Add your breakpoint in one of these methods and you can step through and see entire call stack.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

In one of the earlier discussed thread below sequence is shared by Martin, take a look at that

community.dynamics.com/.../data-entity-methods-execution-sequence

Was this reply helpful? Yes No
Suggested answer

Pedro Tornich 955 on at

Like (0)

Report

You can add ranges in the data project and this ranges are stored in a container field on the data project record.

Find where this field is used and then you will find where to put your logic.

Please, check my answer on this other thread for an example on how to change data project ranges through code before executing the project.

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/368072/data-management-framework-export-limit

Your scenario seems to be different, but I hope it helps.

Was this reply helpful? Yes No
KaamranKhan 10 on at

Like (0)

Report

Sir I want to pass range on Data Entity methods and this range should work at the time of Exporting Data using that Data Entity

For example: In CustTrans Table and AmountCur Field I want to skip all the values those are less than Zero or Zero

Please give me example

Was this reply helpful? Yes No