I try to make at payment in Business Central cloud version, with standard BC settings.
When I try to generate a file, it tells me that it can only be done in DKK and EUR.
If I try to make a payment in SEK I get this message:
- Valutakode for en eller flere Finanskladdelinje er forkert. Du kan kun bruge DKK eller EUR.
- (In English: Currency code for one or more Financial Journal line is incorrect. You can only use DKK or EUR.)
I guess that there must be a setting that tells the system, that I can only make payments in those currencies, but I cannot find that setting.
They currency and rates are set in the system. The bank account is set with blank in currency to allow all currencies.
Hope you can help me.
Hi Martin,
Blank in currency code in bank account doesn’t mean it allows all currencies.
Blank means it uses LCY.
You need to set 1 bank account for each currency you have in each bank.
Thank you for your answer. I did read that blank (LCY) would mean that all currencies would be accepted, and setting a currency would only allow that currency. I will give it a try to creat the 6 bank account with different currency, point to the same ledger account.
Hi Martin, well this is a bit more complex… each bank account has its own currency, if you leave blank currency code in a bank account, it is considered as a local currency, then you can create a journal line with any currency for this bank account, but when it is posted, it is converted to blank (local) currency, its entries will have blank currency code, and all amount will be in local currency.
Hi Ponç .
I have tried to change the ledger account to SEK, the bank account to SEK and the make a payment to a Swedish vendor. It the comes up with the same error that payments can only be done in DKK or EUR. I guess it must be some settings in the “Definition of payment export lines” under Payment Methods. In this standard Danish version, there is a setting named BTI that should be for Bank Transfers International. BC is set up to use DKK as LCY, and payments works fine with both DKK and EUR from a bank account in DKK (blank)
Hi Martin,
I have had the same issue as you’ve experienced. Somehow I ended up finding a github, which has listed the code for the base app of a Danish localized Business Central: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/dk-22/FIK/Source/Payment%20and%20Reconciliation%20Formats%20(DK)/src/codeunits/PaymentExportManagement.Codeunit.al
Although your initial post is long time ago, and you probably found a solution to your problem since then, others may find this post, searching for answers, just like I did.
The code in Business Central does a validation on the payment export lines. In the code, which I have linked above, it does a check on the Local Currency, which is set up in the General Ledger Setup, and the first found EMU Currency (ØMU-valuta) in the list of Currencies.
If you remove the EMU Currency checkmark in the list Currencies for EUR, and select the SEK instead, you are able to export the file, and you will not be stopped by the validation error. Then afterwards you should of course revert the changes made on the list of Currencies.
A stupid code, but with a possible fix. Although it does make a check on some of the fields listed in the Creditors bank account, which may result in some errors, if it does not comply with the Data Exchange Definition.