Financial dimension lookup add in in excel files publishin problem

(0) Share

Report

Posted on by Hakan Fatih YILDIRIM_1

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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Kevin Xia Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Hakan Fatih YILDIRIM_1 14 on at

Like (0)

Report

Hi , The reason was division dimension was not added to Financial dimension configuration for integrating applications screen.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Financial dimension lookup add in in excel files publishin problem

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Financial dimension lookup add in in excel files publishin problem

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates