Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 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
I'm attempting to build a report that shows all line items on open opportunities. I've been successful in building the report, with the exception that the field "Product ID" is not available to use in the Report Wizard.
These are the record types that I have selected:
(I've noticed that some companies have a record type available called "Opportunity Line Items" and I do not show that as an option)
I have many available fields I can select to populate the report, but Product ID is not one them:
Any advice on how to get Product ID to show on the Report Wizard would be appreciated. Thanks in advance!
Please make sure the PRODUCT ID field is in Searchable Mode by opening the field in Customisation
The Product ID is one field in Product entity, so you can't view it in the Opportunity Product(Opportunity Line) entity.
And Product entity and Opportunity Product entity is N:1 relationship, and 'Existing Product' lookup field relate to Product entity in the Opportunity Product entity.
What you need is that present information form parent on child records, so you can create a new calculated field in the Opportunity Product entity, which stores Product ID value from Product entity .
Business Applications communities