Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Is there any way or po...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by Charan140 19
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
  
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,468 Most Valuable Professional on at
    Is there any way or possibility for Composite Entity creation in D365 FNO based on below scenario.?
    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.
  • Charan140 Profile Picture
    Charan140 19 on at
    Is there any way or possibility for Composite Entity creation in D365 FNO based on below scenario.?
    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.
  • Martin Dráb Profile Picture
    Martin Dráb 230,468 Most Valuable Professional on at
    Is there any way or possibility for Composite Entity creation in D365 FNO based on below scenario.?
    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?

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.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans