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

Notifications

Announcements

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,064 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,064 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,037 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
    96,039 Super User 2025 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

News and Announcements

Season of Giving Solutions is Here!

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 1,585

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 780 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 712 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans