Expose financial dimensions to Excel integration in Microsoft Dynamics 365 for Finance and Operations

The Excel integration is one of the powerful tools in Microsoft Dynamics 365 for Finance and Operations. This is helpful tool for accountants to push journal entries through Excel to Microsoft Dynamics 365 for Finance and Operations. The out of the box Excel integration does not have the financial dimensions values, but it could be exposed to the Excel integrations. Of course, the importance of financial dimensions specially the entry will be validated based on the account structure setup.

This blog post will illustrate step by step how to Expose the Financial dimensions on Excel integration. This will need to follow certain steps on Dynamics 365 for Finance and Operations client, Visual Studio, and Excel.

Microsoft Dynamics 365 FFO client

• Add financial dimension configuration for integrating applications

Visual studio

• Add financial, dimensions for OData
• Build and synchronize the model

Excel

• Add dimensions fields.

 

 

 

 

 

Go to D365 FFO, General ledger| Chart of accounts| Dimensions| Financial dimension configuration for integrating applications. Ensure that the required financial dimensions added on integration applications form.

Microsoft Dynamics 365 for Finance and Operations

 

 

 

 

 

 

 

 

 

 

 

Then move to Visual studio| Dynamics 365| Add-ins| Add financial dimensions for OData

 

 

 

 

 

 

 

 

 

 

 

Add financial dimensions, and link it to Dimensions model.

 

 

 

 

 

 

 

 

 

 

 

 

 

Dimension fields have been added to dimension integration entity.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Build and synchronize the model

 

 

 

 

Move back to Microsoft Dynamics 365 for Finance and Operations client, and create a new General journal, then jump to Excel integration.

 

 

 

 

 

 

 

 

 

 

Enable editing on Excel file, then move to Design.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Then click on LedgerJournalLine  and select Edit.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Select the following values of which represents your financial dimensions and add them to the selected fields.

Financial dimensions represents account

Account.BusinessUnit
Account.CostCenter
Account.Department

Financial dimensions represents offset account

OffsetAccount.BusinessUnit
OffsetAccount.CostCenter
OffsetAccount.Department

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You have the option to arrange the presentation of the selected fields. 

 

 

 

Then press done to update the changes.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Refresh the Excel sheet to apply the updates.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The financial dimensions have been added to Excel template, select the proper values and publish it to Microsoft Dynamics 365 for Finance and Operations

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Go back to Microsoft Dynamics 365 for Finance and Operations client, the general journal entry is updated,  and it has financial dimensions.