Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Financial dimension lo...
Finance | Project Operations, Human Resources, ...
Answered

Financial dimension lookup add in in excel files publishin problem

(0) ShareShare
ReportReport
Posted on by Community member 12
Hi all ,
 
We have custom and standart financial dimnesions on our movement journal lines added. It has been implemented OData Excel integration as below on DimensionCombinationEntity and DimensionSetEntity.
 
 
when publishing division custom financial dimension through excel with new lookup value , excel cell becomes blank and it publishes blank value? Has anyone encountered such issues? And any clue how to resolve it?
 
Regards 
  • Suggested answer
    Community member Profile Picture
    Community member 12 on at
    Financial dimension lookup add in in excel files publishin problem
    Hi , The reason was division dimension was not added to Financial dimension configuration for integrating applications screen.
     
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Financial dimension lookup add in in excel files publishin problem
    Hi,
    Did this answer solve your problem? If so, you can mark the thread as verified so that other users of the forum can view it.
    Best regards,
    Kevin
  • Verified answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Financial dimension lookup add in in excel files publishin problem
    Hi,
    Can you use other users with higher privileges to export? It may be that the exported excel cell is blank due to a permission issue. Have you ever try to directly export entity from data management?
    These fields are not exported, are they virtual fields? If so, you must first add them to the staging table, and if you don't, the data can't be exported to staging, so these two fields are not included in the exported file. For more details, refer to this link: Solved: Data entity virtual fields are not exported (dynamics.com).
    If they're not a virtual field, are they added to the Grid? If not, you need to personalize the grid, add these two fields before exporting. For more details, refer to this link: Some custom data entity fields not shown in while data export in excel from form and if i directly data entity export from data management the specific fields are shown successfully (dynamics.com).
    Best regards,
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans