Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Financial dimension lookup add in in excel files publishin problem

Posted on by 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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,908 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans