Finance | Project Operations, Human Resources, ...

Is there any way or possibility for Composite Entity creation in D365 FNO based on below scenario.?

(0) Share

Report

Posted on by Charan140

Hi,

here is the scenario, I want to create a single Data Entity with sources like Standard Table: VendInvoiceTrans and other ISV: table. both table fields are the same, I need to fetch both table records into this entity in real-time used for the dual write. I am unable to create a composite data entity because there is no relation between the tables.

questions: 1. Is there any way to create a data entity/ composite data entity with this scenario to fetch all records based conditions like Line status: invoiced

2. ISV table having New invoices and Standard Table: VendInvoiceTrans having Posted Invoiced, I need to fetch all posted invoices from the standard table and New invoices from the ISV Table, Is there any way to satisfy this scenario?

In advance thanks for your reply,

Please let me know if need more info to understand the scenario.

thanks,

Charan

I have the same question (0)

All responses (3)

Answers (0)

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

A composite entity is a special type of entity consisting of several data entities. I suspect you don't want that; you want a single entity gettting data from several tables.

I'm not sure what you're trying to say by "both table fields are the same". Do you mean that the tables have a field through they're related to each other? Or do you mean that the other table has the same structure as VendInvoiceTrans?

Was this reply helpful? Yes No
Charan140 24 on at

Like (0)

Report

Hi Martin,

ISV table has the same structure as the VendInvoiceTrans Table. here, ex: VendInvoiceTrans Table has Old invoices, and after adopting ISV, all new invoices are maintained in the ISV Table, I need to fetch all old invoices from VendInvoiceTrans and New invoices from the ISV table into a single entity to consume data in CRM through dual write.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

You can create a view with a union query - use PurchTableAllVersions as an example. This view can be a data source of a data entity.

But I don't know whether dual-write doesn't have some limitations that will prevent you from using such an entity there.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Is there any way or possibility for Composite Entity creation in D365 FNO based on below scenario.?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Is there any way or possibility for Composite Entity creation in D365 FNO based on below scenario.?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates