Skip to main content

Notifications

Announcements

No record found.

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... / Opening balance and G/...
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 JohnnyLM 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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Opening balance and G/L Account Bank with the right amount in local and foreign currencies

    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

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 499 Super User 2025 Season 1

#2
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 373

#3
Mansi Soni Profile Picture

Mansi Soni 327

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans