In D365 I need to be able to find what product(s) are tied to what open Opportunities. How can I go about doing this? I didn't see how to do this via advanced find, but maybe I am missing something. Please let me know, thank you.
Hi partner,
Please create such a report.
Primary record type is Product, Related record type is Opportunity Lines (Existing Product).
Add a condition in Opportunity Line. Filter the related entity Opportunity, set Status Equals Open.
Add Name of Product as a group head, and Opportunity of Opportunity Line as a column.
The report runs as follows.
Each group is a product, and there is no duplication between products, each product will only appear once, and the opportunities associated with the product are presented as a row of records under the product.
Hi, USA80
You could do an advance find where opportunityproducts.opportunity is equal to whatever opportunity you want, o filtering by its status 'OPEN'
regards.
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156