411
Dear all,
I would like to display the whole order lines contract related to the customer in the 'account entity', for example if i click on the Test account name, i would like to display all his order lines contracts. I have tried to achieve it but unfortunately i could only display the whole orders
Best regards,
Hi Partner,
Has the problem been solved? Any updates?
Please click Yes under "Did this answer your question?" to close this thread.
Thanks.
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Hi Archetype,
This involves three entities according to your description, they are Account, Order and Order Line, and they have following OOB relationship:
Account and Order is 1:N relationship
Order and Order Line 1:N relationship
So Account and Order Line has no direct relationship, what you need is that display grandchildren records(Order Line) in subgrid of grandparent’s(Account) form, Order entity is necessary.
1.New 1:N relationship between Account and Order Line.
(1) Create relationship and add the lookup field to the order line form.
Go Settings > Customizations > Customize the system > Entities > Account > 1:N relationships.
Go Settings > Customizations > Customize the system > Entities > Order line > Forms > Information
(2) Create order line sub-grid in Account form.
(3) Fill order account with customer value from order.
The step is necessary, it missing step is why your sub-grid are missing data, because your lookup field is empty.
(4) Check sub-grid in Account form.
2.Nested Editable Grids
Nested Editable Grids in D365 CE v9 UCI | D365 Demystified
(1) Go Settings > Customizations > Customize the system > Entities > Account > Forms to select one form.
(2) Add order sub-grid in the form.
(3)Configure Nested Editable Grid.
(4)Test.
Expand one order, you can view related order line records.
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Hey!
Can you please make sure, the below lookup field which is on the OrderLine entity has the value set in it:
Hi Piyush Parate,
Thanks for your help, unfortunately its not working for me, maybe i did something wrong.
I followed the steps below :
1. Create relationship 1:N between account entity and order lines entity
2 : Go to Account main form that i use and added a subgrid with that relation :
3 : When i go back to the Test account name, there is no data displayed :
Best regards
[quote user="Piyush Parate"]Hi!
Yes, it is because there is no OOB relation between Account and OrderLine (of order). OOB, there is a relation between Account and Order, and that's the reason you end-up with the list/view to display the whole orders in the Account form.
Solution:
Hi!
Yes, it is because there is no OOB relation between Account and OrderLine (of order). OOB, there is a relation between Account and Order, and that's the reason you end-up with the list/view to display the whole orders in the Account form.
Solution:
up :( really need help please
[quote user="Archetype"]Dear all,
I would like to display the whole order lines contract related to the customer in the 'account entity', for example if i click on the Test account name, i would like to display all his order lines contracts. I have tried to achieve it but unfortunately i could only display the whole orders
Best regards,
[/quote]
#1
André Arnaud de Cal...
293,265
Super User 2025 Season 1
#2
Martin Dráb
231,927
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
