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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Settle between different currencies vendor payments INV EUR, Paid USD, Accounting Cur NOK

(0) ShareShare
ReportReport
Posted on by 10

Hi,

Did anyone experience this issue and have a solution

Customers accounting currency is NOK - and the vendor is sending an invoice in EUR. This invoice is then settled form the USD bank account. The (NO) bank return file is giving you the following information - (just as an example Inv amount settled EUR 99,44 - deducted from bank account USD 118,83 and the cross exchange rate is 1,195 USD per EUR).

By standard D365 / AX functionality I can settle the EUR invoice amount - transfer the EUR amount to the payment journal line - change payment journal line currency to USD (since this is the currency / amount deducted from the USD bank account) But now I'm stucked with the fact that my accounting currency is NOK and therefore changing the payment line currency to USD - gives me the cross exchange rate between NOK - USD.

From the bank return file I only have the cross exchange rate between USD / EUR (1,195 USD/ EUR) - and therefore I do not have directly the recalculated/corresponding cross exchange rate btw NOK / USD. This seems to be like a tri-angulation issue - and the payment journal line (D365) also have a secondary exchange rate field - but this is though disabled.

The best solution to hand over to the customer would be to use the return file information directly and key these informations into the payment journal line and with this achieve that the invoice is settled in EUR and paid in USD out of the USD bank account - but this seems not to be possible. I hope that you can help me out here - thank you in advance. BR Jakob

*This post is locked for comments

I have the same question (0)

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans