Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
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
Small and medium business | Business Central, N...
Answered

Consolidation

(1) ShareShare
ReportReport
Posted on by VG-12111806-0 74
Hi,
we have 2 subsidiaries- AUS & EUR.
we have consolidation company using USD as denominated currency.
 
I have set up Currency Exchange Rate Table field to  specify consolidation uses exchange rates from consolidated company.
set up business card >currenyc exchange rate table to Local and data source to Local for both subsidiary business units ( EUR & AUS)
 
Consol translation method for all Balance sheet accounts set as Closing rate and P&L account as Average rate manual.
 
Have entered exchange rates for Aug 2024 - 1st to 31st on consolidated books for AUS & EUR.
 
Now when consolidation process is run, I realised that 'Average currency rate factor ' and 'Closing currency rate factor' both are same as Closing rate.
 
My question: average rate is not calculaed automatically and used up in the consolidation process?
Is this an intended fucntionality that average manual rate are not AUTOMAtically calculated n picked during consolidation process?
 
should the average manual rate be entered MANUALLY at the time to consolidation  process?
kindly confirm,
appreciate replies and comments.
 
thanks
Vijaya
Categories:
Dynamics 365 Business Central
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 28,147 Super User 2025 Season 1 on at
    Consolidation
    Yes, you need to manually calculate and enter the average rate. 
     

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

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,028

#2
YUN ZHU Profile Picture

YUN ZHU 950 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 718

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans