Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I am new in AX7. I want to know how can we find relations between two tables which can be used for creating a Query.
Is this how I should proceed ahead? Will deploy project work in this case.
Also, what will be in datasets and precision design. I am new in this part.
I only want to display above listed things in my report. I am making use of Filters for this. Filter will be PO and information related to that filter has to be displayed.
You could also consider using a temp tables as your report data sources. That makes it easier to separate (complex) data retrieval from the report design work. And then you can use x++ code (in addition to queries) to retrieve data.
I suggest you check the standard purchase related reports for some inspiration.
Could you please provide some more details like the standard report name that I can search. Where can I access them?
Please help me in getting familiar with basics.
Sorry to inform you this. I can't use x++ at present. I am only allowed for using queries. That's the reason I am so much into relations, datasource and designs.
You can look at reports such as PurchPurchaseOrder and VendInvoice. The standard system is often the best documentation of x++ and D365 development. So you should use it as a reference, documentation and inspiration.
Why can't you use x++? Handling these complex datasets such as contact information can be quite difficult to fine tune without using x++.
Since I am on my 1st learning stage, I am given this task to display information from Organization administration->Organization->Legal Entities. I need to display Company address, phone no, Facebook etc along with Other fields from PurchTable & PurchLine. It's a SSRS report but NO use of any code.
That works exactly the same way!
Go to PurchLine -> Relations and you will find a relation named DeliveryPostalAddress.
You can see the relation between these two tables is PurchLine.DeliveryPostAddress==LogisticsAddress.RecId.
You can customize the relation between two tables by setting the properties of the relation.
Look at relation LogisticsPostalAddressBaseEntity on PurchLine. It has relation with entity LogisticsPostalAddressBaseEntity, then you can link LogisticsPostalAddressBaseEntity with LogisticsElectronicAddress on LogisticsPostalAddressBaseEntity.LocationRecId = LogisticsElectronicAddress.Location. Then you can display Tel no., URL, facebook from LogisticsElectronicAddress table
In AOT you can find Relations node in the table definiiton. It's defined from child to parent, for example from SalesLine to SalesTable.
Right click PurchLine table - Open in designer. Now you can see the properties of the relation, and all the fields that are part of the relation.
Are you sure it was not already explained to you?We have shared you a general process how you can find table relations in AOT. In addition to that, the exact relation between PurchLine and LogisticsPostalAddress was shared to you.
Could you please read through all messages once again, and see if you find the information in there.
Also, if your issue is resolved, could you please mark all helpful answer(s) as verified. Thanks!
Hi Ashish ,
Nikolaos already gave you directions about how to find relations , so i am not going to talk about same .
I see you are trying to set relation in your query . If you know the relation exist between datasources you added in your query then you can use use relations property = yes on the LogisticsPostalAddress datasource of your query and dont have to create anything manually , which i see you are trying to do.
Just right click and see properties of LogisticsPostalAddress1 datasource in your query and set the property top yes
If you are looking for relation between PurchLine and LogisticsPostalAddress then see it in this pics. You can also see it in AOT on PurchLine table in Relations node. In your example screenshot, Select DeliveryPostalAddress in Field and RecId in RelatedField property
Business Applications communities