Financial dimension configuration for integrating D365FO

Today, A bug reported to me that complete segments Default Dimensions are not exporting using Data Entity...

Functional share more detail with me Like, they set the default dimension with Positions.

Dimension have 9 segments but while they are exporting using data management framework then 5 dimension segment are missing in Excel sheet..

Entity Name > Position default dimensions

Here is the screen shot of position and the set of dimension.

Dimension set

Functional Create Export Project and Export the data and download the file

downloaded file screenshot

Resolution

After spending hours of hours and debugging in the code, finally we found that this is configuration issue and there is template configuration form available for Dimension Integration..

General Ledger>Chart of accounts>Dimensions>Financial dimension configuration for integrating

Here We define segment which we need to export via integration.....

Navigate to Financial Dimension Configuration for Integration

Select Dimension in which you want to change...

Default are 4 Dimension were set in my case and the same were exporting..

Move your required segment from left to right list page.. for demo purpose i have moved all segment.

Save the record a confirmation prompt show on your screen... click on yes.

Now Execute the Export project and download the export file...

Here is the final result... After changing in

Dimension configuration working fine for me ...

Please feel free to contact me In case of any issue you are facing during implementation of this blog

Author Description