Dear experts,
I have case below: our company setup the same realized and unrealized account (both for gain and loss).
So now i cannot breakdown the realized and unrealized transactions,
did someone ever encounter the same issue?
Please give me the advice,
Thank in advance,
Best regards,
Thu
*This post is locked for comments
Hello Thu,
If you use only a single account for your FX gains/losses then things become difficult to separate.
What you can get out - based on my example - is the following:
1. You can identify the total FX effect of 100 in my example on your account
2. You can identify the previously posted unrealized FX effect by applying filters on the transactions recorded on your single FX account
3. You could also get the reversal effect of the unrealized FX gain / loss but would have to make calculations - for example - in MR to get this.
Theses are all, however, only second best workarounds.
If your management is highly interested in unrealized and realized exchange rate gain/loss effects, you should think about changing your accounting setup and use separate accounts for realized / unrealized FX gains/losses.
Best regards,
Ludwig
Hi Ludwig,
Sorry I still not understand, as your explanation, the report will show 50 USD (unrealized when you run AP revaluation)
but actually, I want the report displays both 50 USD (unrealized when you run AP revaluation) and -50 USD (revert unrealized when you paid the invoice)
-> How can I distinguish the revert unrealized when you paid the invoice and the realized? They have the same posting type and Transaction type
-> I think of simplest way is the side of the amount
(example: gain when evaluation (negative amount) -> when revert (positive amount)
-> But is there any other way to do?
Best regards,
Thu,
Hi,
Here is an example where I posted a FX currency invoice (USD is the foreign currency in my case and EUR is the accounting currency)
Invoice posting:
Foreign currency revaluation (exchange rate dropped from 80 to 75)
Payment of the invoice (exchange rate dropped from 75 to 70)
Can't you filter the unrealized gain/loss by entering a MR line that filters the transaction type 'foreign currency revaluation'? In my example, this should give you the transaction that was posted on 31 July with an amount of USD 50.
Best regards,
Ludwig
Hi Ludwig,
As my understanding, when user made the settlements, AX will reverse the unrealized and record the realized.
But since the unrealized and realized account are the same, so i cannot breakdown the details.
* The unrealized transaction
Dr Cust A: unrealized amount
Cr Account X: unrealized amount
* Settled Opened transaction
(Reverted previous evaluation)
Dr Account X: unrealized amount
Cr Cust A: unrealized amount
(Record realized transaction)
Dr Account X: realized amount
Cr Cust A: realized amount
Sorry for any confusing,
Best regards,
Thu,
Hi,
Please also check the transaction type in combination with the posting type.
This should help you getting the separation.
Best regards,
Ludwig
Hi Ludwig,
I checked as your suggestion in voucher transactions (though you mentioned about it) -> transaction type : foreign currency revaluation.
But the point is, as my understanding, when user made the settlements, AX will reverse the unrealized and record the realized.
But since the unrealized and realized account are the same, so i cannot breakdown the details.
Sorry for any confusing,
Best regards,
Thu,
Hi Thu,
Each transaction is posted with a posting and transaction type.
For unrealized losses/profits you typically have the transaction type 'foreign currency revaluation' recorded.
With that info you can setup for example a Management Reporter report that splits up the account balance.
Best regards,
Ludwig
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
