Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Order and Account Related select returns no data

(0) ShareShare
ReportReport
Posted on by 40

I have had the new UI completed on our Sandbox version and i am reviewing all tabs on the account.

I have a Sub grid for Orders to display all orders associated to the account but if i select Orders from the Related - Common section on the right it does not show any of the orders

Sub Grid on Account

pastedimage1583412701544v4.png

Related Orders

pastedimage1583412661938v3.png

To clarify i can go to the Orders entity and see all Orders there as well it just seems to be the Account and Order relationship is not showing the view i am using in the Sub grid is available in the related order section but does not show any data?

In the first screen shot you can see i also have a Invoice Sub Grid and this is showing the relationship correctly when you click on Invoice and in the Customization section both Order and Invocie looks the same.

this is how the sub grid is set up in the form.

pastedimage1583412826118v5.png

I'm sure its something simple staring me in the face but i just cant see it at the moment.

Thank you in advance for any help received.

  • Henry J. Profile Picture
    Henry J. 5,237 on at
    RE: Order and Account Related select returns no data

    Glad you were able to fix it

  • Suggested answer
    Colin365Bell Profile Picture
    Colin365Bell 40 on at
    RE: Order and Account Related select returns no data

    I have found the solution to my problem, Henry set me on the right path so thank you.

    Basically I had multiple relationships that had the same display name in the issue above we have a Order relationship and a bill to 3rd party relationship but both had display name of Order. I changed this and now it is functioning correctly.

    Thanks again Henry

    Colin

  • Colin365Bell Profile Picture
    Colin365Bell 40 on at
    RE: Order and Account Related select returns no data

    HI Henry thanks for the reply.

    there are no other filters on the Order Associated view, this is the out of the box view and none of the views seem to be working on the section when i try switching between them

    the only relationships are the same as the invoice ones between Order and account so i am still stumped at the moment...

    any other checks you can think of is appreciated

  • Verified answer
    Henry J. Profile Picture
    Henry J. 5,237 on at
    RE: Order and Account Related select returns no data

    Hi Colin,

    There are a few things I would check here:

    1. Is the "Orders Associated View" containing additional filters that prevent displaying any data?

    2. Is there any additional relationship between Order and Account, on top of "Customer"? The issue could come from the fact that the "Order Associated View" in "Related" doesn't use the same relationship between these 2 entities (that could be the case if you have created a custom lookup to the Account entity).

    Henry

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans