How to: enable lookup for a field in 'Open in Excel' for Dynamics 365 Finance and Operations
vinitgoyal2005
6,330
Like
Share
Report
Lookup in Excel comes from relations defined on the data entity, if there is no lookup in 'Open in Excel' then check the data entity.
![]()
![]()
![]()
Below is an example where item number doesn't have lookup. the data entity is 'SalesOpenSalesLineDiscountJournalLineEntity'
![]()
So to add the lookup, just create an extension for this data entity and add the relation with EcoResReleasedDistinctProductV2Entity.
Now you can have the lookup in Excel.
This was originally posted here.
*This post is locked for comments