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