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.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
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 | Upcoming TechTalks | All TechTalks
We resell products from multiple suppliers. So, on a single opportunity/quote, there might be multiple products from multiple suppliers. For example:
3 products from Supplier A (summing to $35,000)
2 products from Supplier B (summing to $10,000)
1 product from Supplier C ($22,000)
1 product from supplier A ($5,000)
1 product from supplier C ($22,000)
How can I create a view, chart, or report that shows just revenue by supplier?
For the example above, I would need 3 pipeline reports that might have columns like this:
Supplier A Pipeline view/report/whatever:
Opportunity 1 - $35,000
Opportunity 2 - $5,000
Supplier B Pipeline view/report/whatever:
Opportunity 1 - $10,000
Supplier C Pipeline view/report/whatever:
Opportunity 1 - $22,000
Opportunity 2 - $22,000
If your CRM is not an online version, you can use report to show this data because you can use transact sql flexibility and power to generate your queries.
You can use Business Intelligence Pack on Visual Studio to develop RDL reports.
but if you have online version it will be a few complicated because views, reports are based on FetchXML queries that are limited.
Business Applications communities