web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Payments in foreign currency best practices

(0) ShareShare
ReportReport
Posted on by 1,419

Hi,

I need to process AP and AR payments in foreign currency and many questions come up.

1. In the case of AP, I create payments in D365 and send the files to the bank. So the transactions in D365 are generated before we can see them in our bank statements. As I don't know which exchange rate the bank is going to apply I guess I can't post the payment journal until I see it in the bank and change manually the exchange rate so the amount that I will deduct from my D365 bank account match the amounts that I see on my bank statement. Can you confirm that this is the best practice in this scenario?

2. In case of customers, many times we will see the receipts in our bank statements before we create the payment proposal in D365. So we will calculate which exchange rate the bank has applied and put it manually on the "exchange rate" field under "exchange rates". This does not make much sense to me. It would make more sense that I manually inform the amount the bank has deducted and the exchange rate gets calculated accordingly. Am I understanding this correctly?

pastedimage1579689583106v2.png

When would the "secondary exchange rate" and the "cross rate" be active?

Also, why are the reporting exchange rates empty? There's a exchange rate informed in the system for that pair:

pastedimage1579689322324v1.png

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Payments in foreign currency best practices

    Hi CapsLock,

    For No 1:

    I have seen companies that either wait for the bank confirmation and the exchange rate applied before they post the journal.

    Yet, I have also seen companies who posted the journal directly against a bridging account.

    Once the bank deducted the money the bridge account was cleared and the difference recorded as exchange rate gain / loss.

    For No 2:

    For customer payments I am used to receive a bank statement that is imported and then used to reconcile.

    In Europe, many companies use add on's, that is, third-party solutions for importing and reconciling those customer payments.

    Otherwise, it is often a quite manual process that involves a lot of steps.

    Hope this helps.

    Best regards,

    Ludwig

  • CapsLock Profile Picture
    1,419 on at
    RE: Payments in foreign currency best practices

    Do you know why the exchange rates for the reporting currency (USD) are empty? The cross rates and secondary exchange rates are clear, we are not using triangulation so it's ok

    Also, is it possible then to pay an invoice in GBP from a bank account in EUR? I'm selecting an invoice in GBP and I want to settle the full amount in GBP but I'm doing that from a EUR bank account. Exchange rate between both currencies exist. When I try to post the journal I get an error saying that the currency is not allowed for the bank account but it should be because in real life that is possible.

  • CapsLock Profile Picture
    1,419 on at
    RE: Payments in foreign currency best practices

    Hi,

    I already found how to allow multiple currencies in a bank account.

    pastedimage1579709405280v1.png

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,850

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 795 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 519 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans