Table of Contents
Business Requirement
It is challenging to a user to make bulk Ledger transaction manually directly in D365 F&O with financial dimension combination. In such scenario there is a requirement of bulk import of ledger transaction with financial dimension through Data management workspace. In this case user need to fill all the ledger transaction detail with ledger dimension and import. This import with ledger dimension will give error if Financial dimension configuration for integrating applications in Dynamics 365 F&SC is not completed.
Introduction
Data entity integration formats are required in order to import transactions that contain accounts and financial dimensions.
In our example budget register entry import through data management (data entity name is "Budget account entry") screenshot is provided Below. Dimension display valuse will not be visible in Data management export until we define the Financial dimension configuration for integrating applications
Example:
Date | Main account and dimensions | Amount |
---|---|---|
6/1/2016 | 605140-0021-03 | 150.00 |
6/1/2016 | 110110-0024-04-001 | -150.00 |
When you import the file, the system reviews the Main account and dimensions column, and maps it to what you've set up in the active budget register dimension format. For this example, the active budget register dimension format is as follows: Main account - Department - Item Category
Here, Main account = 605140, Department = 0021, Cost Center = 03
Likewise for second line there is segment 4, Main account = 110110, Department = 0024, Cost Center = 04, Segment 4 = 001, this will not be imported.
Configuration:
Navigation: General Ledger > Chart of Accounts > Dimensions > Financial Dimension configuration for integrating applications
There are 4 dimension format type used for different purposes. Select and define the order of dimensions for dimension formats used by data entities. Multiple dimension formats can exist for a single dimension format type, but only one format for a dimension format type can be active.
1. Default dimension format – This format type is required when you import default dimensions, through both Data Management and the Microsoft Excel integration.
2. Ledger dimension format – This format type is required when you import ledger dimensions, through both Data Management and the Excel integration. The ledger dimension format is the most common format, because it's used any time that transactions are imported, such as through the general journal
3. Budget register dimension format – This format type is required any time that you import dimensions for budgeting and budget control, through both Data Management and the Excel integration.
4. Budget planning dimension format – This format type is required any time that you import dimensions for budget planning, through both Data Management and the Excel integration.
Below setup is shown for Budget register dimension format in our particular case likewise for rest three Dimension format type setup can be configured.
Before Configuration:
Dimension display value will not be visible in Data management export until we define the Financial dimension configuration for integrating applications
User cannot import any utility with dimension values.
After Configuration:
Dimension display value will be visible in Data management export once we complete the Financial dimension configuration for integrating applications.
Now after configuration user can import the utility/transactional data with dimension values.
Note:
The dimension format types are not company-specific. The setup is a global setup. You can set up as many of each format type as you need, but only one format type can be active at one time. If no dimension format type is set up, you will receive an error when you import. You will also receive errors if the order is incorrect.
Thank you 😀
Happy Learning
*This post is locked for comments