web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to join data sourc...
Finance | Project Operations, Human Resources, ...
Suggested answer

How to join data sources in entities

(0) ShareShare
ReportReport
Posted on by AstridMalanka 8

Hi,

I joined sales invoice line v3 datasource - CustInvoiceTrans with MarkupTrans

pastedimage1637004844716v1.png.

And I added a field on my entity - MarkupCode

pastedimage1637004923198v2.png

my issue is that i get duplicates in the results.

how do i need to join not to get duplicates when i export to excel or my BYOD?

Thanks

I have the same question (0)
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,637 Super User 2025 Season 2 on at
    RE: How to join data sources in entities

    Hi Astrid,

    Do want to crate a new custom entity for this purpose? Please check docs.microsoft.com/.../build-consuming-data-entities to get a overview on how create a custom entity and create a relation.

  • AstridMalanka Profile Picture
    AstridMalanka 8 on at
    RE: How to join data sources in entities

    Hi,

    No, I dont want to make a customer entity, I tried to duplicate this entity but run into a lot of issues, therefore I just added the join, I am not sure why I am getting duplicates.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,004 Super User 2025 Season 2 on at
    RE: How to join data sources in entities

    Hi Astrid,

    Did you only add the tables or also set a join relation? What relations are set for the two additional data sources? Do you have one or more charges per sales order line?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 696 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 569

#3
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans