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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Foreign Currency Setup

(0) ShareShare
ReportReport
Posted on by 101

Good Maorning all, we implemented D365BC over 1 year ago but did not the use the foreign currency functionality, therefore our foreign bank , customers and vendor balances were created in local currency.. Now we will like to implement the foreign currency functionality in the software . What is the best approach 

I have the same question (0)
  • Suggested answer
    Vaishnavi J Profile Picture
    3,096 on at

    Hi,

    Following is the approach you can do

    1. Set up Currency. you can follow the below  link

    learn.microsoft.com/.../finance-set-up-currencies

    2. Set up currency exchange rates. Refer the below link

    3. Define Currency exchange rate accounts in Chart of Accounts and tag in currencies setup

    4. Set Currency code in Vendor and Customer

    5. Added the Currency Code in bank accounts

    6. And then you are good to post the transaction using foreign currency code.

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

  • PETERFL Profile Picture
    101 on at

    Thanks for your answer. How do we convert existing bank balances, vendors and customers in foreign currency

  • Suggested answer
    Vaishnavi J Profile Picture
    3,096 on at

    Hi,

    if you really want all your transaction to be done in foreign currency for this year fiscal. Then you can follow the below process.

    All the balances need to be move one by one in intermediate G/L Account

    For Example:

    Vendor balance = 50000 LCY

    Create one Intermediate G/L Account (Transfer Account)

    Then pass one Journal entry which will credit the vendor and add it to intermediate account this transaction is happening with LCY 

    Now again transfer back from Intermediate G/L Account to vendor but with Currency code in it.pastedimage1663684421787v1.png

    Please note this process can be risky if you have not consider appropriate posting date or amount. Based on posting date and amount the currency exchange gain and loss accounts will be hitting and before proceeding with posting such transactions make sure you have completed the above setups for Foreign Currency in Business Central.

    Also please try to post the above transaction in Sandbox first before using Production.

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

  • Suggested answer
    Amit Baru Profile Picture
    3,043 on at

    hi,

    Pls refer the below link

    https://erpconsultors.com/configure-exchange-rate-according-to-document-date-in-d365/

    Regards

    Amit Sharma

  • Suggested answer
    YUN ZHU Profile Picture
    102,811 Super User 2026 Season 2 on at

    Hi, I personally don't recommend converting.

    For Bank, you can create new foreign currency banks,
    For vendors and customers, foreign currency may be considered for new orders.

    pastedimage1663720311047v1.png

    Hope this helps

    Thanks.

    ZHU

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 548 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 417 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 377 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans