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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Currency exchange rate service incorrect in Consolidation company

(7) ShareShare
ReportReport
Posted on by 194
I have a client who use currency exchange rates every day. They have an automated job queue which updates the currencies list every Monday accordingly (and the list is correct).
They have an issue where in the consolidation company it is populating an incorrect currency amount.
 
They create a sales invoice in the German company (the default currency here is EUR), they then run consolidate function. This then pushes the documents into the consolidation company where a general ledger entry is created, and from there it is pushed into the UK company as a purchase invoice. Upon looking at the inspect page in the German and UK companies, the sales invoice in the German company and purchase invoice in the UK company the currency is correct (1.15460934 which is the currency as on 01/09/2025). However, on the description line it is stating that the currency is 1.20482, which is nowhere in the currencies list. This is an issue for multiple lines in the consolidation company, for various currencies.
 
What would cause the consolidation company to populate the incorrect currency? The customer is using BC onprem.
I have the same question (0)
  • Verified answer
    OussamaSabbouh Profile Picture
    12,808 Super User 2026 Season 1 on at
    Hello,
     
    Consolidation does not use the daily Currency Exchange Rate table.
    It uses the Business Unit consolidation exchange rates (Average/Closing).
    Those rates are stored separately and often contain old values → that’s where the wrong “1.20482” is coming from.
     
    Consolidation company → Business Units → Exchange Rates → update the Set Up Business Unit Currencies table.
     
    Regards,
    Oussama Sabbouh
  • Verified answer
    Gregory Mavrogeorgis Profile Picture
    992 Super User 2026 Season 1 on at
    Hi,
    Even though the daily exchange rates are correct in the German and UK companies, the consolidation company doesn’t necessarily use those same rates directly. When BC does a consolidation, it can use:
    • a calculated rate
    • an average rate
    • a closing rate
    • or even the inverse of the rate depending on how the companies are set up
    So the rate you see on the description line (like the 1.20482) often won’t match any rate in the currency table, because it’s a consolidation calculation, not the raw daily rate.
    This usually happens because:
    1. The consolidation company is set up differently
    One company might store the rate as “1 EUR = X GBP”, while another stores it the opposite way (“1 GBP = X EUR”), and consolidation ends up using the flipped version.
    That alone can easily produce a number like 1.20482.

    2. The consolidation uses a different translation method
    If the business unit in the consolidation company is set to use Average or Closing rates, BC computes a special rate for the consolidation period.
    That calculated number is what shows up in the description.

    3. The job queue might not update the consolidation company
    It’s very common that the daily updates run for the German and UK companies, but not for the consolidation company.
    So consolidation ends up mixing old rates + new rates.

    4. The description always shows the consolidation factor, not the invoice factor
    The inspect page in the DE and UK companies is showing the invoice rate (which is correct).
    The consolidation description line is showing the group currency translation rate, which can absolutely be different.
     
    If you find this helpful please mark it as verified
     
  • Verified answer
    YUN ZHU Profile Picture
    99,055 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.

    Specify exchange rates for consolidations
    Thanks
    ZHU
  • NL-28100713-0 Profile Picture
    194 on at
    Thank you. That is very helpful.
    Is there a way to amend the lines in the consolidation company?
  • NL-26110715-0 Profile Picture
    18 on at
    And how would one prevent this from happening in the future?
  • NL-28100713-0 Profile Picture
    194 on at
    Is there a way to change the business units in the consolidation company so that it populates the correct currency and how does one change past entries?
  • Suggested answer
    Valentin Castravet Profile Picture
    32,157 Super User 2026 Season 1 on at
    If you rerun consolidation for a time period it's already been run for, the system zeroes out the previous consolidation entries and posts the new entries. That's how you can "change" your posted consolidation entries. 
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans