How to pay a vendor in EUR from a GBP bank account

vremeni4

Hi All,

Simple question, and it seems like this is not possible in Dynamics NAV or 365.
We have a bank account with currency code set to GBP, as it is a GBP bank account.
Anyhow from this GBP account we paid a vendor in EUR, so how do we account for this in Dynamics 365.

When I insert an entry on the payment journal I cannot change the Currency code to EUR,
as the Bank account is set in GBP, so the system does not allow any other currency.

Thanks.

kylehardin

There is a hard check in the code that verifies that the Bank currency is exactly the same as a payment journal line currency (assuming the same bank balance account on that journal line).

The only work-around I can think of is to do this payment in a single-line journal. Change the bank card to GBP, create your journal line, then print or export your check. Then put your bank back to EUR.

I've never actually tried this, so please proceed with caution. I'm also hoping other people chime in with opinions.

What I've seen customers of mine do is that if this happens frequently, they make a separate bank account, one per currency. Customization to bypass that error message might also be an option.

kylehardin

There is a hard check in the code that verifies that the Bank currency is exactly the same as a payment journal line currency (assuming the same bank balance account on that journal line).

The only work-around I can think of is to do this payment in a single-line journal. Change the bank card to GBP, create your journal line, then print or export your check. Then put your bank back to EUR.

I've never actually tried this, so please proceed with caution. I'm also hoping other people chime in with opinions.

What I've seen customers of mine do is that if this happens frequently, they make a separate bank account, one per currency. Customization to bypass that error message might also be an option.

vremeni4

Thanks for your help.

Creating two lines in the Payment journal one for the Vendor In EUR and one for the Bank Account in GBP does the trick.
As lines are separated the currency validation is fine.

The amount for the Bank entry needs to be adjusted or one can select the correct exchange rate otherwise the total balance is not 0 and journal cannot be posted.

The only annoying bit is that application of the payment to the invoice needs to be done on the Vendor ledger entry page, but I think it is not too bad.

Thanks again for your suggestion and help.