Dynamics Community Forum Thread Details

Legal entity Group consolidation set up

I'm hoping someone might be able to help me here.

I'm in the process of creating a consolidation company to consolidate 25+ companies in D365 that share the same chart of accounts. Note the set up of all the other legal entities is fairly straightforward in that they all trade in GBP and therefore no revaluations are required. And as mentioned, they all share the same chart of accounts.

When creating the new Consolidation company, I had done the following config.

In Organisation Legal entities, I had applied 'Use for financial consolidation process' switched on.
Added the consolidation company to the hierarchy and switched the same setting on the legal entity setup
Included in the legal entity setting 'use for financial elimination process'
In the Chart of accounts, I added shared account structure to mirror the same for the other legal entities.

From the steps above from D365, and understanding that all legal entities share the same COA, I thought this was enough for me to run the Online consolidations. Yet when completing all the parameters for the online consolidation and then running the consolidation, I get the following error from the batch logs.

A number sequence has not been set up for the reference General journal transfer in the area General ledger.

An error occurred during the consolidation process. All consolidations that match the criteria for this consolidation event have been deleted. You must process the consolidation again.

Since there was no mention of the requirement to create a number sequence, let alone define journal names, these have not been created.

If this what I need to create at part of the consolidation set up? I don't quite understand why it's needed since all companies are trading GPB or is this irrelevant?

Any help would be greatly appreciated.

Quick Links

Leaderboard