Friday, July 17, 2015

CRM 2013 Subgrid vs. (Expanded) Associated View Records. OR Recent and Associated Entity views

Sometimes you experienced when you have subgrid in your CRM Form, but when you click the ‘expand’ button to expand the view then it will redirect you to Associated View, but you found the records appear in the list are different.

to find the solution of that problem then click the below link or directly read the same content from my blog.

https://community.dynamics.com/crm/f/117/t/141127

http://missdynamicscrm.blogspot.se/2014/10/crm-2013-subgrid-vs-expanded-associated-view-records.html

I have checked this issue.

So, the issue will be happening if you have one more Opportunity to Account custom N:1 Relationship.
For example:
The standard CRM have 2 normal N1 Relationship to Account, those are Parent Account and Potential Customer.
Then, I added one more relationship with name new_account2 (Account 2) as shown here:


If you notice, in the subgrid, the Entity (Opportunity) is having setting:
(see the section inside the red-square)

So, it means that only show if the Potential Customer is the respective account, correct.
Then if you click to pop out the associated view, some of your Opportunities are gone and missed out to appear in the list.
After I checked, it was because the missed Opportunities didn't have relationship to the new relationship (in this case is new_account2 or Account 2)
So, I put more detail here.
Now, in the Account, I have two Relationship to Opportunity in the Navigation explorer.

The first one is Account to Opportunity (Custom)

The second one is Account to Opportunity (System)

And if I go to each Associated View, it will give me different result.
Okay, this is from the subgrid:

*You can see 2 Opportunities, correct.
Then, try again to see the Associated View from the Navigation.
This is from the first one (a custom relationship)

*Yes, you can only see 1 Opportunity
And this is the second one (a system relationship)

* You can see two records of opportunity and see the arrow, the new section of filter, showing it is a different associated view
And finally, from the pop out from the Recent Opportunities subgrid.

*As you can see, you can only see one (1) record, so this view, after you pop up out is referring to the custom relationship (to Account 2)
To check deeper, I try to search in the database what is the different between them, and then, yes it is actually because of the disappeared opportunity does not have relationship to Account 2:

*See the null value of Account 2, the rests are same.
And I guess, the missing Opportunities are the existing Opportunities just before you created a new custom relationship.
Because basically, for the new records, CRM will auto populate and auto-mapping all of the lookup relationship to the same entity if newly created from subgrid or associated view., in this case is Account, but not for old records (CRM Mapping behavior concept).
To ensure you and myself, I put the Account fields in to the Opportunity Form.
All of the account fields

and

And you can see that one of them doesn't have value for the Account 2, and the Opportunity with the null value will not show in the Associated View.
To check in your data, you see the missing Opportunities in your data, there are 2 records, which one them is:
"Leslie Test Lead 0627-16", and the other one I can't see since this is not in the first page.
You can try to go to Associated View and then 'Add Existing Opportunity', then add the "Leslie Test Lead 0627-16", now back to your Opportunity Form.

Then,

After that you open the form..

Now, you can see that the custom field to custom Account, in my term is Account 2, now is filled up!.
I guess this is the answer.
SO, back to your question.
How the views are populated?
The answer is:
- For the Recent Opportunities shown in the subgrid, it shows all of the related Opportunity record from the Potential Customer.
- For the Associated View pop out from the subgrid, it shows all of the related Opportunity record from the new custom relationship.
And in fact, it picks the first relationship defined in the navigation in order or in sequence (see the solution in the below section for detail)
How to solve, there are two solutions basically.
1. You fix the data, fill the value of your new custom relationship (you can use Account 2 field in the Opportunity Form) or can use by adding the Existing Opportunity through the Opportunity Associated View in the Account form, as for this example: "Leslie Test Lead 0627-16".
Or you can use Workflow or programming to auto-fill the Account 2 aligning with the Potential Customer value.
2. You can use either: Remove the Navigation of the Custom relationship
OR, just Re-Order the position of those relationship in the navigation area:

So, now this is the result after you re-order, the subgrid after you click the pop up will no longer calling the wrong associated view, instead, it will call the associated view by Potential Customer (since you put it first)

Now, your customer will see the same for subgrid or associated view after clicking the 'grid' ribbon to show the detailed associated view. And they will not frustrate again.
 

29 comments:

harini ganga said...

The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea. here by i also want to share this.
Block Chain Training in Bangalore

Block Chain Training in tambaram

Block Chain Training in chennai

Block Chain Training in annanagar

Block Chain Training in pune

Block Chain Training in velachery

harini ganga said...

Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
r-programming Training in rajajinagar

r-programming Training in bangalore

Rprogramming Training in velachery

Rprogramming online Training

Rprogramming Training

r-programming Training in Bangalore

Unknown said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.

rpa training in velachery| rpa training in tambaram |rpa training in sholinganallur | rpa training in annanagar| rpa training in kalyannagar

Unknown said...

Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
Data Science course in kalyan nagar | Data Science course in OMR
Data Science course in chennai | Data science course in velachery
Data science course in jaya nagar | Data science training in tambaram

Unknown said...

Your story is truly inspirational and I have learned a lot from your blog. Much appreciated.
python training in rajajinagar | Python training in btm | Python training in usa

Anjali Siva said...

Useful blog, I got good information through this article. Share more like this.
ccna Training institutes in Chennai
ccna Training
AWS Training in Chennai
AWS course in Chennai
Python Training in Chennai
UiPath Training in Chennai

LindaJasmine said...

Amazing Post . Thanks for sharing. Your style of writing is very unique. Pls keep on updating.
Best Spoken English Institute in Chennai
Spoken English Course in Chennai
Spoken English Course in Chennai
English Speaking Course in Chennai
Spoken English Training center in Chennai
Spoken English Classes in Anna Nagar
Spoken English Classes in Velachery
Spoken English Classes in Tambaram
Spoken English Classes in Adyar

sathyaramesh said...
This comment has been removed by the author.
Vicky Ram said...

Amazing Post . Thanks for sharing. Your style of writing is very unique. Pls keep on updating.

Article submission sites
Technology

sultana said...

I am really enjoying reading your well written articles.
It looks like you spend a lot of effort and time on your blog.
I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..
Java Training in Bangalore
hadoop training institutes in bangalore
Java Course in Bangalore
Java Training Institutes in Bangalore
Java Institutes in Bangalore

aruna ram said...

Thank you so much for sharing this pretty post, very interesting to read. You have provided a nice article. Keep more updates....
Data Science Course in Perambur
Data Science Training in Nolambur
Data Science Course in Mogappair
Data Science Training in Tnagar
Data Science Course in Vadapalani
Data Science Training in Aminjikarai

mercyroy said...

Thanks first of all for the useful info.
the idea in this article is quite different and innovative please update more.
python training courses near me
best python training in bangalore
python training in bangalore
Python Training in Vadapalani

aruna ram said...

Great concept! I got more information from your post. Good work and continuing………
SEO Training in Tnagar
SEO Course in Nungambakkam
SEO Training in Saidapet
SEO Course in Omr
SEO Training in Omr
SEO Training in Tambaram

sathyaramesh said...

This post is much helpful for us. This is really very massive value to all the readers and it will be the only reason for the post to get popular with great authority.
Selenium testing training in chennai
Selenium course
Software testing selenium training
Software Testing Training Institutes in Chennai
software testing course
testing courses in chennai

kayal m said...

Great work!!! Your post is too good and it was wonderful concept. Thank you for your sharing.
Hadoop Training in Bangalore
Big Data Hadoop Training Bangalore
Big Data Hadoop Course in Bangalore
Big Data Hadoop Training in T nagar
Big Data Hadoop Course in Velachery
Big Data Hadoop Training in Omr
Big Data Hadoop Training in Chennai

sathyaramesh said...

Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
Good discussion.
Certified Ethical Hacking Course in Chennai 
Ethical Hacking Course 
Ethical Hacking Course near me
Python Training
Python Training Institute in Chennai
Best Python Training in Chennai

Anbarasan14 said...

Very informative blog! I liked it and was very helpful for me. Thanks for sharing. Do share more ideas regularly.

English Speaking Classes in Mulund
English Speaking Course in Mulund East
English Speaking Classes in Mulund West
Best English Speaking Classes in Mulund
Best English Speaking Course in Mulund East
Best English Speaking Training in Mulund West
Spoken English Courses near me

Mariam Ahmed said...
This comment has been removed by the author.
kaushik said...

This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog keep doing more.
Aws Classes in Bangalore
Aws Cloud Training in Bangalore
Aws Coaching Centre in Bangalore
Android Development Training in Bangalore
Android Development Course in Bangalore
Best Android Training in Bangalore

nikitha josh said...

Very useful information, Keep posting more blog like this, Thank you.
Air hostess training in Chennai
Air Hostess Training Institute in chennai
cabin crew training institute in chennai
cabin crew training chennai

Joe said...

Great Work. Amazing way of writing things. Thanks for Posting.
Informatica MDM Training in Chennai
informatica mdm training
Informatica MDM Training in Tambaram
Informatica MDM Training in Anna Nagar
Informatica MDM Training in T nagar

Anonymous said...

Visit for Blockchain training in Bangalore:- Blockchain training in Bangalore

un known said...

I just loved your article on the beginners guide to starting a blog.If somebody take this blog article seriously in their life, he/she can earn his living by doing blogging.thank you for thizs article. top blockchain online training

Unknown said...

Very correct statistics furnished, Thanks a lot for sharing such beneficial data.
todaypk movies

lavanya said...

The Piece of your Information's are very valuable..Keep updating c Software Testing Training in Chennai | Software Testing Training in Anna Nagar | Software Testing Training in OMR | Software Testing Training in Porur | Software Testing Training in Tambaram | Software Testing Training in Velachery

deiva said...

"Thanks for sharing this awesome content..

Digital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery

"

Revathi said...

Thanks for your informative article, Your post helped me to understand the future and career prospects & Keep on updating your blog with such awesome article.keep it up!!

Android Training in Chennai

Android Online Training in Chennai

Android Training in Bangalore

Android Training in Hyderabad

Android Training in Coimbatore

Android Training

Android Online Training

shiva said...

I just loved your article on the beginners guide to starting a blog.If somebody take this blog article seriously in their life, he/she can earn his living by doing blogging.thank you for this article.
Cyber Security Training Course in Chennai | Certification | Cyber Security Online Training Course | Ethical Hacking Training Course in Chennai | Certification | Ethical Hacking Online Training Course |
CCNA Training Course in Chennai | Certification | CCNA Online Training Course | RPA Robotic Process Automation Training Course in Chennai | Certification | RPA Training Course Chennai | SEO Training in Chennai | Certification | SEO Online Training Course

Buy SEO Service said...

Thankyou for the valuable content.It was really helpful in understanding the concept.50 High Quality Backlinks for just 50 INR
2000 Backlink at cheapest
5000 Backlink at cheapest
Boost DA upto 15+ at cheapest
Boost DA upto 25+ at cheapest

Split the String values with a special character in MS Flow to convert this into Array

 Many times we have a requirement to prepare the Mailing address for some of the documents, suppose there are Address Line1, Address Line2, ...