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 :
Finance | Project Operations, Human Resources, ...
Answered

Can AX do currency revaluations on AR transactions that load into AX (not generated from AR module in AX)?

(0) ShareShare
ReportReport
Posted on by 2,442

Hi All, 

I've asked a similar question before, but this one is more specific.  

1.  When I transferred funds from one account to another (screenshot 1)-> posted the transaction->ran the currency revaluation, the revaluation showed a loss (screenshot 2).  So the revaluation worked. 

Bank-transfer.png

currency-loss.png

2.  When I wrote a GL journal entry in GBP.  The accounting currency is EUR.  Posted this transaction->Ran the currency revaluation. Nothing happened.  No result.

Journal-entry-in-GBP.png

Currency-revaluation-page.png

Curremcy-page-next-step.png

I wonder why that is.  Am I missing something?

Thanks so much!

I have the same question (0)
  • Suggested answer
    SouravDam Profile Picture
    11,732 on at

    Hi Kim Johnson,

    Have you checked if the Foreign currency revaluation check box in "Main accounts" form for those main accounts are set to enabled or not ?

    Unless this check box is enabled; system will not be able to run currency revaluation on those accounts. Below screen shot is taken from D365 for your understanding.

    84252.JPG

    In addition to above; please check if the exchange rate between currencies what is recorded in the transaction is actually different compared to the exchange rate on the date when you are running the currency revaluation. If there is no difference in exchange rates; then system will not be able to revalue the accounts.

    Also I have below concern.

    --- Are the main accounts for those subledger 'Bank' accounts (in your 1st screen shot) fall in the same '6' series accounts as you showcased in the 3rd screen shot ? Can you compare those main accounts with other accounts. I feel; the Foreign currency revaluation check box may not be enabled for other accounts due to which revaluation is not working. 

    --- Bear in mind; only Balance sheet type accounts should be selected for foreign currency revaluation process. Not profit & loss type accounts.

    --- Can you check if those '6' series main accounts what you selected in the journal line; is actually Balance sheet type accounts or not ?

    Kindly check and update us.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • lmai Profile Picture
    2,442 on at

    Thanks, Sourav, for your feedback.

    Yes, the Foreign currency revaluation boxes are checked for those accounts; and yes, the currency exchange rate GBP to EUR has been set up with today's rate. 

    Now, what if I have a separate AR system outside of AX for a reason (AR module in AX is not used), for reporting purposes, I need to load these sales transactions into AX through GL journal, can AX generate the currency revaluation on those loaded AR transactions?  Keep in mind that these AR transactions have GBP currency and the accounting currency is EUR.  I appreciate all the feedback on this issue.  Thanks so much!

  • Suggested answer
    Satish Panwar Profile Picture
    14,673 Moderator on at

    Hi Kim,

    Give this link a try and see if it helps. The AR transaction loaded in GL should be just treated as any other GL transaction (just different account).

    organicax.com/.../

  • lmai Profile Picture
    2,442 on at

    This is great!  Let me go back review and re-test.  Thanks, Satish!

  • Suggested answer
    SouravDam Profile Picture
    11,732 on at

    Hi Kim Johnson ,

    Yes you can run the revaluation on those journals too even though it is imported from outside ERP. System will consider those transactions just like any other transactions as mentioned by Satish Panwar .

    But would like to know; is there any chance that you have 'Modified' the original question ? I can see this looks different now :-)

    Kindly let us know.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Kim,

    Your revaluation example does not make sense to me :-)

    You posted the transaction on 20 December and on the same day you want to revalue the transaction.

    This does not work because for a single day you can only enter a single rate.

    Please test the following:

    Enter a different exchange rate for 21 December and run the revaluation again.

    Then you should see a posting and revaluation.

    Best regards,

    Ludwig

  • lmai Profile Picture
    2,442 on at

    You are right.  Thanks, 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 April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 804

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 639 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 528

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans