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 ?
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,
how are you ? actually I was waiting your response :)
here the details for 11,621,249 IQD
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 !
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?
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)
Business Applications communities