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.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
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 | All TechTalks
I am trying to build a view from multiple entities: Contacts, activitypointer and one custom: payment.
Contact 1:N with Activitypointer
Contact 1:N with payments.
I would like to build a view that will present contacts who made payment in the last week but no action was directed to them. Is this possible with CRM 2013 out of the box?
Let me know if you can help.
You can use Advance find to achieve it.
But your condition ‘last week’ is just for payments? or both for payments and Activity?
If it is just for Payment, you can follow step1.
1.Contacts with payments last week and no activity.
(1) Click Advanced Find button.
(2) Select Contacts entity and View that you need. then add a reference entity and set condition.
If ‘last week’ condition is also for Activity, you need the FetchXML builder – it is part of a larger set of tools called the XRM ToolBox.
2.Contacts with No Activities last week View using FetchXML
(1) Download XRM ToolBox.
(2) Once you have downloaded and installed it, you’ll open the view you created in step1, and edit it.
3.reopen the view in advanced find.
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
It works, thanks for your help!
Business Applications communities