web
You’re offline. This is a read only version of the page.
close
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...
Answered

Consolidation

(1) ShareShare
ReportReport
Posted on by 76
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
I have the same question (0)
  • Verified answer
    Valentin Castravet Profile Picture
    31,505 Super User 2025 Season 2 on at
    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

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,092

#2
YUN ZHU Profile Picture

YUN ZHU 663 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 515

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans