I have a custom field on the OpportunityLineItem and want to show it in a custom report.
- Custom Report Type: Invoices with Asset
- OpportunityLineItem- child of Opportunity
- Invoice - child of Opportunity
So, in theory, I should be able to add the custom field in the custom report type, following the path:
Invoice Fields(Lookup) > Opportunity > OpportunityLineItem > Custom field.
But after the Opportunity > I don't have the OpportunityLineItem option.
What am I missing here and what relationship should I add in order to get the Custom Field from the OpportunityLineItem?