Microsoft Dynamics AX (Archived)

Breakdown realized and unrealized transactions

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (8)

Answers (1)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Breakdown realized and unrealized transactions

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Breakdown realized and unrealized transactions

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,
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Breakdown realized and unrealized transactions

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Breakdown realized and unrealized transactions

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,
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Breakdown realized and unrealized transactions

Hi,

Please also check the transaction type in combination with the posting type.

This should help you getting the separation.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Breakdown realized and unrealized transactions

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,
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: AX 2012- Breakdown realized and unrealized transactions

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
Suggested answer

ZvikaR 89 on at

Like (0)

Report

RE: AX 2012- Breakdown realized and unrealized transactions

The transactions would have different transaction types, you can distinguish them that way