Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
we are trying to get the data from 2 tables, LedgerTrans and VendTrans , it is having the data like below:
We need the result as below:
tried writing x++ statement but the results is coming in duplicate records.
How we can write the x++ select statement to get the result.
please refer the below example
Thank you Muthu for the quick response,
We are having both transaction tables,will order by works, we don't want the duplicate records in the result.
you can use Group by instead of order by to avoid duplicate records in your selection
Hope this solution works for you, if so please mark this as resolved.
For such requirements, best to create a view first and understand how different linked to each other. You can simply create a view object in your project and add tables into it, add the right relation and see by browsing if getting expteced data.
Business Applications communities