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... / Retained Earning Balan...
Small and medium business | Business Central, N...
Suggested answer

Retained Earning Balance not showing in Consolidated financial reports

(1) ShareShare
ReportReport
Posted on by Sneha Mani 160
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
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 27,901 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 160 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 27,901 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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,281 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,019 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans