Search
  • 365 Finance Architec

Where did those numbers come from? D365FO Consolidation Trick...


#D365 #D365FO #Accounting #Consolidation #FinancialDimensions #LegalEntity #Setup


When you setup your Consolidation, Online in Dynamics 365 FO, there is an easy trick to identify what Legal Entity (LE) the Trial Balance values come from.


1. Financial Dimensions

Create a Financial Dimension and point it to the Legal Entity table.

I usually name the Financial Dimension "LE".

General ledger > Chart of Accounts > Dimensions > Financial dimensions

Note: You will probably need to put your system into Maintenance Mode to Activate the new dimension.



2. Financial Dimension Sets

I usually create a Financial Dimension Set for use in my Consolidation company [C01]

I name it MA+LE.

The Financial Dimension Set is chosen when you run a Trial Balance report from your consolidation company.

The new set will display the Main Account AND Identify the Source Legal Entity for all transactions.

General ledger > Chart of Accounts > Dimensions > Financial dimension sets

Remember to create balances after your create your new Financial Dimension Set.



3. Account Structure

Add the new Financial Dimension to the Account Structure(s) that you have assigned for your consolidation company,


General ledger > Ledger setup > Ledger



4. Consolidate, online

When you are filling out the Financial Dimensions (tab) within Consolidate, Online, choose the Company accounts specification for the LE Financial Dimension


Consolidations > Consolidate, online

Then go ahead and finish processing your consolidation.

See my prior blog for process.

Automated Accounting, D365 Online Consolidation (365financearchitect.com)


5. Trial Balance report


When your run your Trial Balance report, select your new Financial Dimension Set.



We have successfully added identification of the source legal entity values in the consolidated Trial Balance report.

28 views0 comments

Recent Posts

See All