In this blog post we shall delve into resolving this error. Let us understand this by actual requirement and an example.
Requirement: Necessity is to Integrate/Import data using data management in Dynamics 365. But business has different account structures and different financial dimensions. This however seems like a problem where we would not want users to go into settings (Financial dimension configuration for integrating applications) each time, they are going to import something. Also, at some point, one or more integration will be setup as recurring batch job which further complicates this.
Problem: The issue with this is main accounts where they have two advance rules depending on which account structure is being used.
Example: Let us understand this by taking main account (132100) as an example which has two advance rules in 2 account structures.
| Manufacturing B/S Account structure: |
Manufacturing B/S 2 Account structure: |
| 132100– Site – Mandatory. |
132100–Site + Store – Mandatory. |
Solution suggested:
We will map all the possible 5 segments in ‘Financial dimension configuration for integrating applications’ form.
Navigate to General Ledger > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications.
But during import, though we have different account structure mapping for same main accounts, we will be importing data specific to legal entity as in if we are importing data for Manufacturing B/S structure, below format should be used by keeping all 5 segments but leaving the unwanted ones to blank and separating them by delimiters.
Import for Companies which has Manufacturing B/S mapped:
In the file, it should be mapped in below way:
132100|||S001||
If we are importing data for Manufacturing B/S 2 structure, below format should be used by keeping all 5 segments, map the mandatory values but leaving the unwanted ones to blank and separating them by delimiters.
Import for Companies which has Manufacturing B/S 2 mapped:
In the file, it should be mapped in below way:
132100|||S001|DELHI|
Below screen shows the data imported to DEMF (Manufacturing B/S) with 5 segments, keeping other not required segments to blank.
Note: We are using 5 segments to companies with Manufacturing B/S structure, only for integrations to bypass the import issues and the reason behind it is because the ‘Financial dimension configuration for integrating applications’ form is global but after you import the data into D365 system, automatically considers the account structures mapped against each legal entity and post the journals accordingly.
PLEASE TEST THIS THOROUGHLY BEFORE APPLYING IN CLIENT ENVIRONMENTS.
That’s all for this blog post. Keep Exploring!!
THANK YOU!
