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

Announcements

No record found.

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans