web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Consolidation error
Small and medium business | Business Central, N...
Unanswered

Consolidation error

(0) ShareShare
ReportReport
Posted on by Allen FGC 10

Dear All, 

I'm doing the consolidation and have sorted out all the GL mapping issues however one error does not allow me to pull off the consolidation. Can anyone support please? The error is as follows:

A G/L Entry with Posting Date on a closing date xxxx  was found while consolidating non-closing entries.

This is something about the closing entries that we have had before . Do I have to  exclude closing entries from consolidation? And if so, how?

The path to this error: 1 Business Units 2. Actions 3.Functions 4.Test Database( the error above will be seen in the report generated at this stage).

Thank you

I have the same question (0)
  • Dallefeld Profile Picture
    Dallefeld 211 User Group Leader on at

    What date range are you using in your consolidation?

  • Allen FGC Profile Picture
    Allen FGC 10 on at

    Thank you.

    I did run the consolidation from the inception of company in  Jan 2020 to August 31th 2022. The point is that closing of PL accounts has only been done at the end of FY 2020 and those entries has been marked as (C12/31/20). Alternatively, I did the consolidation from Jan 2021 to now and it worked perfectly but the balances would not be correct. I plan to do consolidation from inception of the company though.

    Thank you for advice beforehand.

  • AD-22040756-1 Profile Picture
    AD-22040756-1 642 on at

    Yes you have to exclude closing entries from the consolidations. To do this you run the consolidation on date ranges that exclude it. E.g. run December 1 to December 31 and then January 1 to January 31 rather than December 1 to January 31. The latter range includes the C12/31 date which is a closing date. You would then run the Close Income Statement function in the consolidated company

  • Allen FGC Profile Picture
    Allen FGC 10 on at

    Thank you so much.

    Then that means I should have multiple consolidation documents? Cause there is a start data and end date when you run the consolidation. Obviously I cannot punch a range when there is start date and end date in the report. To clarify further, here is the period I want to consolidate: Jan 2020 to 31 August 2022. The PL closing has only been done on 31/12/2020 for 2020 FY.

    So the period should be 01/01/2020..30/12/2020 and 01/01/2021..31/08/2022.

    How the  above range could be punched into the system when there is start date and end date?

    Many thanks

  • AD-22040756-1 Profile Picture
    AD-22040756-1 642 on at

    Yes you would have multiple consolidations. Typically this is done monthly. Your start date would be the beginning of the date range, and the end date would be the end of the date range. E.g. start date: 01/01/2020 and end date: 31/12/2020 (you have to include the 31, the closing date is c31 so the system will skip it if your end date is 31). c31 is a fictitious date after 31 and before 1.

    If your consol. company and subsidiary companies have the same functional currency I would:

    • 1st consolidate 01/01/2020..31/12/2020 -> and then run the close income statement function for 2020 in the consol. company after all companies have been consolidated
    • 2nd consolidate 01/01/2021..31/12/2021 -> and then run the close income statement function for 2021 in the consol. company after all companies have been consolidated
    • consolidate 2022 monthly. this way if you need financial statements monthly for the consol company for the current year you can run them. You could also consolidate the entire period 01/01/2020..to today monthly, but that's a lot of work and depends if you need monthly reporting in the consol. company. 

    If your consol. company and subsidiary companies have different functional currencies, then this gets more complicated as you have to account for fx rates and revaluations performed by the system. You could either run consolidations for the date ranges I mentioned above, or decide if you need to do it monthly to use the correct monthly fx rates. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,606

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans