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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / DAX - Revaluation of a...
Microsoft Dynamics AX (Archived)

DAX - Revaluation of a Sub-Ledger

(0) ShareShare
ReportReport
Posted on by SU-22040800-0 2,487

Hi

 

I’m trying to understand sub-ledger revaluation. I have an example below, if someone can fill the gaps for me?

 

I have a company with the Accounting Currency set as USD, and the Reporting Currency set at EUR. I want to revalue my AR sub-ledger in GBP. My exchange rates are as follows:

DATE     USD       EUR        GBP

01-Jan   1              0.8          0.7

15-Jan   1              0.85        0.75

31-Jan   1              0.9          0.8

01-Feb  1              0.95        0.85

 

I have a clean AR control account to start with, and process 3 invoices against it: 1 in each currency, on 02-Jan, for 100 USD each. This leaves a balance on my AR Age Analysis (extracted in my Accounting Currency – USD) of $100 + $80 + $70 = $250. This naturally balances to my AR control account.

 

I then get to the end of the month, and I revalue my AR sub-ledger as at date 31-Jan into currency GBP.

 

What amount am I expecting to see post to my AR Control Account, and Unrealised Gain/Loss Account?

 

Thanks

 

 

*This post is locked for comments

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

    Hi  

    It depends on what parameters you select when running the revaluation. You can run it e.g. With a rate different from the last day pf the month.

    Best regards

    Ludwig

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Thanks Ludwig.. Yes, I understand that you can run it with a different exchange rate, but my question, is what am I to expect once it has run?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello James,

    If you run the revaluation with the rate from 31 Jan then I would expect to see

    Invoice 1: 100USD

    Invoice 2: 88,89 USD (Euro appreciated against the USD => FX loss of 8,89 USD)

    Invoice 3: 87,5 USD (GBP appreciated against the USD => FX loss of 17,5 USD)

    The assumption is that you have USD/EUR rates specified above.

    Hope I did not mess up with my math skills :-)

    Probably just run the revaluation to see whats the Outcome.

    Thanks,

    Ludwig

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Thanks Ludwig - May I ask you how you got to the 88.89 and 87.5 ?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    1411.fx.png

    Please run the revaluation.

    Keen to know whether I made a calc. error in Excel or not :-)

    There is a preview function, so you can actually simulate the revaluation before actually running it.

    Best regards,

    Ludwig

  • Verified answer
    SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Hi Ludwig

    Here are my findings:

    After posting the initial invoices (AR Aging Report):

    6866.7.png

    Control account postings:

    8311.2.png

    Ran Simulation Reval:

    2480.3.png

    5460.4.png

    Ran Final:

    1007.5.png

    8715.6.png

    New Aging Report (as at 01/31/2018):

    6266.8.png

    Control Account Postings:

    6866.7.png

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Something I noticed was that you cannot select a currency, when running the REVAL. So i'm wondering what exactly it is "fixing".

    Are you able to explain the postings to me at all.. ? (how/why does it get those numbers?)

  • Verified answer
    SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Hi Ludwig

    ok, I see what has happened here.. The system takes each transaction, in its transaction currency, and calculates it based on the selected exchange rate date (in the above case, 1/31). It then works out a new figure, and writes the different to Un-Realised G/L:

    INVOICE TRANS AMT USD (1 JAN) EUR (1 JAN) USD (31 JAN) EUR (31 JAN) USD DIFF EUR DIFF
    INV1 USD 100        100.00           80.00          100.00            90.00  0 10.00
    INV3 GBP 100        142.86         114.29          125.00          112.50 -17.86 -1.79
    INV2 EUR 100        125.00        100.00          111.11          100.00 -13.89  0
            242.86         194.29           225.00           202.50 -  31.75             8.21
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi James,

    I think you got it. For some additional info on the available parameter settings, please see here: dynamicsax-fico.com/.../foreign-currency-revaluation

    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
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans