Dynamics Community Forum Thread Details

Hello,

I have already referred the Microsoft documentation -

https://learn.microsoft.com/en-au/archive/blogs/dynamics_financial_reporting/creating-consolidated-financial-statements-using-management-reporter-consolidating-data-across-one-or-multiple-dynamics-erps-with-different-fiscal-periods-part-3-of-7

I am looking for guidance on how to configure Financial Reporting in Dynamics 365 Finance & Operations to generate a consolidated Trial Balance for two legal entities that have different fiscal year periods.

Business Scenario

We have two legal entities with the same Chart of Accounts but different fiscal calendars:

Entity A: 1 July – 30 June
Entity B: 1 April – 31 March

For example:

Main Account	Name	Entity A TB	Entity B TB	Interco	Consolidated TB
1000	TB	XXXX	XXXX	XXXX	XXXX

The requirement is to generate a single Financial Report where the Trial Balance of both entities is presented side-by-side and then consolidated after considering intercompany eliminations.

Current Setup

Both legal entities have the same Chart of Accounts.

For the Financial Report, I have created a Row Definition using:

Edit > Insert Rows from Dimensions

This automatically brings all Main Accounts into the row definition.

I have also created a Reporting Tree with separate reporting units for:

Entity A
Entity B

Column Definition

My current Column Definition is approximately as follows:

	Main Account	Name	Entity A	Entity B	Entity A Eliminations	Entity B Eliminations	Elimination	Consolidated Balance
Column type	ACCT	DESC	FD	FD	FD	FD	CALC	CALC
Book code			Actual	Actual	Actual	Actual
Financial year			BASE	BASE	BASE	BASE
Period			BASE	BASE	BASE	BASE
Periods Covered			YTD	YTD	YTD	YTD
Formula							E+F	C+D-G
Reporting Unit			CONSOLIDATED^Entity A	CONSOLIDATED^Entity B	CONSOLIDATED^Entity A	CONSOLIDATED^Entity B
Currency Display				Reporting Currency		Reporting Currency
Dimension Filter					MainAccount = Elimination Accounts	MainAccount = Elimination Accounts

I have tried several combinations for Entity B in the Period field, including:

BASE
BASE+3
BASE-3
1:12
BASE, 1:12
BASE+3, BASE-3
7:BASE+3

However, I have not been able to get the Financial Report to correctly align the reporting periods of the two entities.

Report Definition Setup

Currently, I have configured:

Company in Report Definition: Entity A
Base Period: 12
Base Year: 2026
Default Base Period: S-1
Reporting Tree: Linked to the Report Definition
Dimension Set: Main Account only

Entity A is currently considered the base entity for the report.

Expected Result

The requirement is essentially to produce something like:

Main Account	Name	Entity A	Entity B	Intercompany Elimination	Consolidated
1000	TB	1,000	1,200	(100)	2,100
2000	Revenue	5,000	4,500	(200)	9,300
3000	Expense	(2,000)	(1,500)	100	(3,400)

The important point is that Entity A and Entity B have different fiscal calendars, but the consolidated report should represent the same comparable reporting period.

Questions

Could someone please advise on the recommended configuration for this scenario?

Specifically:

Can D365 F&O Financial Reporting consolidate two legal entities that have different fiscal calendars/fiscal years into a single Trial Balance report?
If yes, how should the Column Definition Period / Financial Year / Periods Covered be configured?
If Entity A has a fiscal year of 1 July – 30 June and Entity B has a fiscal year of 1 April – 31 March, how can I make the Financial Report retrieve the same calendar reporting period from both entities?
Is using BASE+3, BASE-3, 1:12, etc. in the Column Definition the correct approach, or is there another recommended configuration?
Does the Reporting Tree need to be configured differently when the legal entities have different fiscal calendars?
Is it possible to achieve this entirely through Financial Reporting configuration, or would we need to use D365 consolidation functionality / a separate consolidation legal entity before generating the Financial Report?
What is the recommended approach for handling intercompany eliminations in this scenario?
Are there any limitations in Financial Reporting when the reporting entities have different fiscal calendars that I should be aware of?

Additional Information

The main objective is to generate a Trial Balance-style consolidated report where:

Entity A TB + Entity B TB – Intercompany Eliminations = Consolidated TB

while ensuring that the amounts for both entities relate to the same reporting period, despite their different fiscal calendars.

I have already tried multiple combinations of BASE, BASE+3, BASE-3, 1:12, etc. in the Column Definition, but I am not getting the expected result.

Any guidance on the correct Financial Reporting configuration, or an explanation of whether this requirement is supported and what the recommended architecture would be, would be greatly appreciated.

Thanks in advance.

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX