web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / How-Tos for Dynamics 365FO and Hints by Vinit G... / How to: enable lookup for a...

How to: enable lookup for a field in 'Open in Excel' for Dynamics 365 Finance and Operations

Views (497)
vinitgoyal2005 Profile Picture vinitgoyal2005
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.

Comments

*This post is locked for comments