web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

AR settlement with FX after closing year end in AX 2012

(0) ShareShare
ReportReport
Posted on by 7

Hello,

I have a question about Unrealized Gain/Loss with FX when settled the amount.

I found an issue in income statement due to the difference.

 Example) 

10-01-2018  (FX:1.0) INV 100 / AP 100 

12-31-2018(revaluation) (FX: 1.2) Unrealized loss 20 / AP 20 

-Closing year end

01-04-2019(settlement)  (FX: 1.3) AP 20 / unrealized loss 20

                                                    AP 100 / Cash 130

                                       realized loss 30 /

That case is what i found in AX 2012 through revaluation foreign currency test. 

When settled the AP, AX has reversed the transaction for revaluation amount, then all difference is shown by realized loss(30).

If i want to show realized loss with 10, what setting should i change in AX?

I mean, I don't want to see reversed transaction  for unrealized gain/loss with fx after closing year end.

if there's no setup about that, how to treat the transaction in general? 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    There is no setup or configuration for that.

    AX will always reverse the unrealized loss and record it - based on the new exchange rate at the time of making the payment - as realized loss.

    You thus have to live with that.

    Please do not try to make a system modification for that because when it comes to the accounting engine and the treatment of foreign currencies things quickly get complex and your adjustment can literally break things.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans