Microsoft Dynamics AX (Archived)

Help with Exchange rate loss

(0) Share

Report

Posted on by Community Member

Hi All

We have Ax 2012 R3 and the exchange currency as below

87871.2.PNG

the exchange rate was 1 USD = 1275 IQD until 11 June we change it to 1 USD = 1200 as below

2330.3.PNG

on 13 June we invoiced a vendor with 155,000 USD so we got 186,000 IQD on our inventory account

however I opened Exchange rate account and I fount there is an amount !!

how that possible ?

2514.1.PNG

amount in transaction = 0 but the amount is 11,621,249 IQD

how can I fix this ? and why system calculate the amount above ?

Regards

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I cannot see a relationship between the transaction that you showed in the last screenprint and the exchange rate issue.

What is the posting and transaction type of the transaction?

What is the transaction origin?

Can you check the voucher and identify the original document?

What is the relationship to the 155000 USD invoice?

If I calculate the IQD amounts for the old and the new exchange rate then I get foreign currency amounts of 197625 USD and 186000 USD and a difference of 11625 USD.

How does this difference relate to the transaction shown?

Would be great if you could clarify.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Dr

how are you ? actually I was waiting your response :)

here the details for 11,621,249 IQD

transaction origin

first account 21300002 is Vendor credit

second account 66300030 is expanse of Foreign exchange differences

the last account is Vendor account

here is the original document

let me explain in details :

first of all we invoiced a PO with total 155K USD

so the vendor account is now credit 155K and the inventory increased 186,000,000 IQD (= 155K USD * 1200 IQD)

till now nothing wrong ..

I was checking TB and found that there's wrong amount in expanse of Foreign exchange differences the amount is 11,621,249 IQD

so I tracked to find that if we add 11,621,249 IQD + 186,000,000 IQD = 197,621,249 IQD if you divided to 155K USD u will get 1275 IQD the old exchange !

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I tried replicating something similar on my demo machines but was not able to do that.

If you record the very same transaction in a demo/test system do you get the same outcome?

Have you already searched on LCS for an available hotfix for your system?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi

I found the issue

simply our invoices were in USD with exchange rate 1275

so system makes a voucher

Dr customer (with exchange rate 1275)

Cr AR (with exchange rate 1275)

when the customer paid the invoice he pay it with new exchange rate 1200

so system make the voucher below

Dr cash (exchange rate 1200)

Dr Exchange rate loss (75)

Cr customer ( 1275)

Was this reply helpful? Yes No