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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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... / Currency Factor in BC ...
Small and medium business | Business Central, N...
Suggested Answer

Currency Factor in BC impact

(3) ShareShare
ReportReport
Posted on by ZP-13041104-0 62
Hi Team,
 
I have an issue with currency conversion in Business Central.
 
My sales order is in EUR, and our LCY is DKK.
 
The exchange rate is correct:
1 EUR ≈ 7.47 DKK
 
The sales order amount is 52,000 EUR, and the posted sales invoice also shows 52,000 EUR correctly.
 
However, in Customer Ledger Entries, I see:
Original Amount: 52,000 EUR
Amount (LCY): 7,800,000 DKK !!!
 
It should be approximately:
388,565.32 DKK
 
After investigation, I found:
- The field Currency Factor on the posted sales invoice is 0.0066 though it should normally be around 0.1338
- Other EUR orders have the correct Currency Factor on the same date
- The EUR exchange rate setup on the posting date is correct
- The Currency Factor field is not visible to users, so it was likely not changed manually
 
Can someone please help me understand why and how the Currency Factor could become incorrect on one sales order/invoice?
 
Any input would be appreciated.
 
Thanks, 
Zeb
Categories:
Dynamics 365 Business Central migration
I have the same question (0)
  • Suggested answer
    Rajvi Shah Profile Picture
    Rajvi Shah 255 on at
    Hello,
    In the Document Currency Factor is not editable but in the currency card (3 dots in right side) may be someone has changed the Relational Exch. Rate Amount, that is possible.
     
    If Possible please check that exchange rate as well as posting date (currency exchange rate on that posting date) once.
     
     
    You can check below blog,
     
     
    I Hope this will help.
  • Suggested answer
    Teagen Boll Profile Picture
    Teagen Boll 3,252 Super User 2026 Season 1 on at
    I would check two areas.
     
    As Rajvi mentioned you can check the relational exchange rate amount by selecting the 3 dots (option button) here:
    If you see a large discrepancy I would double check the Currency table for that currency and check to see what the FX rate was on the posting date for that currency.
     
    Afterwards you can just run the "Adjust Exchange Rates" process and that will update the fx rate for that entry. You can read more here: Update currency exchange rates - Business Central | Microsoft Learn
     
    Best,
    Teagen Boll
    Social: LinkedIn
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 2,736 Super User 2026 Season 1 on at
    Hello,
    You need to issue a credit memo to offset this invoice and create a new invoice with the correct exchange rate.

    Using Adjust Exchange Rates to adjust is only temporarily method because you will faced with large realized gain/loss entries when the receipt come in.
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 17,836 Super User 2026 Season 1 on at
    Hello Zeb,
    This usually means the posted invoice did not use the EUR exchange rate you are looking at now; it used the Currency Factor stored on that specific sales document, and since your factor is 0.0066, BC calculated a massively inflated LCY amount. Microsoft explains that BC converts foreign currency using the exchange rate/currency factor from the document/posting date setup, but the important point here is: once posted, the customer ledger entry reflects the factor that was on the invoice, not what the exchange rate page shows afterward. Since other EUR orders on the same date are fine, I’d check the source sales order/posted invoice history for anything that could have overwritten the factor: manual change via page personalization/config package/API, a customization/event subscriber, integration/import, copied document, or exchange rate update/recalculation at document creation time. Also check the EUR Currency Exchange Rates line for that date, especially Exchange Rate Amount, Relational Exch. Rate Amount, and Fix Exchange Rate Amount; one bad temporary rate can be pulled into a single document and later corrected, leaving only that invoice wrong. Standard fix is normally not to edit posted entries directly; create a corrective credit memo and repost the invoice with the correct factor, or involve your partner if they need to inspect customization/integration logs. 
    Regards,
    Oussama Sabbouh

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,687 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,041 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 974 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans