SBX - Search With Button

SBX - Forum Post Title

Help with Exchange rate loss

Microsoft Dynamics AX Forum

Abdalrahman Mohammed asked a question on 14 Jul 2018 4:22 AM
My Badges

Question Status

Suggested Answer

Hi All

We have Ax 2012 R3 and the exchange currency as below 

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

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 ? 

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 

Reply
Suggested Answer

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

Reply
Abdalrahman Mohammed responded on 14 Jul 2018 6:44 AM
My Badges

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 ! 

 

Reply
Suggested Answer

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

Reply
Suggested Answer

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

Reply
Suggested Answer

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

Reply

SBX - Two Col Forum

SBX - Migrated JS