You’re offline. This is a read only version of the page.
449
Hi,
I joined sales invoice line v3 datasource - CustInvoiceTrans with MarkupTrans
.
And I added a field on my entity - MarkupCode
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
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?
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,963
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (