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

Opening balance and G/L Account Bank with the right amount in local and foreign currencies

(0) ShareShare
ReportReport
Posted on by 187

Hello BC-Forum,

I only have an Opening Balance (from another ERP system) with total amounts which I have to upload to Business Central. I have the local amounts (CHF) and for the G/L Bank accounts also the foreign currency Amounts.

Let's say I have the following:

                                                         Balance (LCY)                                    Balance (FCY)               

102095   UBS Bank EUR             .......................                                       .........................

110010   Debtor EUR                   125487.60

For the G/L Bank Account (102095) I have the following total amounts:

LCY:    125487.60 CHF

FCY:    100115.39 EUR

How can I get these two amounts in the Opening Balance? Can I make a correction journal entry? Or is there another way to get both amounts in the Opening Balance? I do not want to set a fictional currency rate because this could mess up things later. And also the currency difference G/L Account also has a fixed amount in the Opening Balance.

Same question but yet with a balance that has already amounts on it, see my printscreen nr 2.

124487.60 EUR should change to 100115.39 without changing the other amounts on my Balance.

Thanks for the answer

Greetings,

John

pastedimage1632285869837v1.png

pastedimage1632287333521v2.png

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Johnny,

    If I follow you correctly, you want to book the Bank Account entry that shows CHF 125,487.60 and matches the EUR LCY GL Entry of 100,115.39. CHF Currency Exchange Rate that equals the rate to convert the CHF to EUR

    Now, I am a little confused since the GL shows EUR 125487.60 in account 110010 and the Bank shows 124487.60. Where is the CHF related? Is the Bank Account to be CHF. I am not following the GL Account and your numbers.

    Thanks,

    Steve

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,651

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 808 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 718 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans