Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Retained Earning Balance not showing in Consolidated financial reports

(1) ShareShare
ReportReport
Posted on by 124
Dear Members,
 
I created a consolidated entity combining two standalone entities which had the same currency value. While consolidating the entities all the balances were consolidated in Trial balance. But we had a mismatch in retained earnings it did not fetch the Year end closure balance. so I made year end closure in the consolidated entity now the retained earnings balance matches but it is not being displayed  in financial statement - Balance sheet. The consolidation translation method I mentioned for all the accounts including retained earnings  was Closing rate (Please refer to the attached image). Please help me to resolve this issue.
 
Thanks in Advance,
Sneha
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,349 Super User 2025 Season 1 on at
    Retained Earning Balance not showing in Consolidated financial reports
    Create a third column where the Business Unit field is empty.
     
  • Sneha Mani Profile Picture
    Sneha Mani 124 on at
    Retained Earning Balance not showing in Consolidated financial reports
    Dear Valentin,
     
    Thank you for the response. I have setup the financial statements using business unit code in column definition. I would like to know how to display closing entry in the financial reports. Please find the attached image for your reference and help me to resolve this.
     
    Thanks
    Sneha
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,349 Super User 2025 Season 1 on at
    Retained Earning Balance not showing in Consolidated financial reports
    Most probably your financial statements are setup to only display entries that have a business unit code. As the closing entry doesn't have one, it doesnt get displayed on the report. If you're using the financial reporting module then check what filters you have applied in the row/column definitions. 
     

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans