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

Notifications

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) / Currency revaluation b...
Microsoft Dynamics AX (Archived)

Currency revaluation batch job

(0) ShareShare
ReportReport
Posted on by lally 8

Hi All ,

AX 2012 R3

AP/ AR Currency revaluation batch job has different options which confuses a lot to understand how the functionality work and which options to select .

Currency revaluation batch job has a field called Method - standard , Minimum and Invoice date.

Even I went to the Help also , but does not contain with an example .

Could any pioneer explain with an example that how to use the above three options and which is most common option will be used in the business ?

*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 lally,

    Standard - records revaluations profits/losses on your revaluation accounts

    Minimum - only records losses on your revaluation accounts (Example: Some countries such as my home country Germany have a special regulation in place that does not allow them posting unrealized exchange rate gains)

    Invoice date - resets/reverses/cancels your prior exchange rate revaluations if you have run the Job more than one time for a specific date/month.

    Hope this helps,

    Ludwig

  • lally Profile Picture
    lally 8 on at

    Thanks for the reply ,

    Which method I need to select normally ?

    Still I am not clear about the standard and Invoice date ? Please explain with an example.

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

    Normally you would chose "standard". You can chose invoice date if you noticed e.g. that an exchange rate has not been setup for a specific date and that the revaluation has thus calculated wrong unrealized exchange rate gains/losses. If you want to re-run the currency revaluation you would Need to run it first by selecting "invoice date", then complete the Setup of the missing Exchange rate and then run the currency revaluation again with the ordinary "Standard" method.

    Ludwig

  • lally Profile Picture
    lally 8 on at

    Sorry to say that I am still not clear .

    Could you please explain with some values , that how to play with Standard , Minimum and Invoice date using standard date , invoice date ?

  • lally Profile Picture
    lally 8 on at

    [quote user="Ludwig Reinhard"]

    Standard - records revaluations profits/losses on your revaluation accounts

    Invoice date - resets/reverses/cancels your prior exchange rate revaluations if you have run the Job more than one time for a specific date/month.

    [/quote]

    Could any pioneer explain the difference between the above two options with an example ?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi lally,

    I can prepare an example for you within the next days. Alternatively, you can post e.g. some foreign currency vendor invoices in a demo system and run the currency valuation with different Setups. It will take some time but it will probably be the best way to identify the difference between those options.

    Best regards,

    Ludwig

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

    Hello lally,

    Here is an example:

    Company currency: EUR

    Foreign currency vendor invoice: USD

    Invoice date: 1 January

    Exchange rates:

    EN_5F00_121_5F00_0015.png

    Running a foreign currency valuation with the method "Standard" as of 28 January results in an unrealized foreign currency loss of 250 EUR.

    If you re-run the foreign currency revaluation as of 28 January by using the method "Invoice date", AX reverses the previous foreign currency revaluation and uses the Exchange rate applicable at the invoice date for the revaluation. In other words, the "invoice date" method cancels the previous foreign currency revaluation.

    If you run a foreign currency revaluation on 31 January by using the "Minimum" method, AX will not post anything because of the foreign currency gain of 200 EUR. The Minimum method ensures that only unrealized foreign currency losses are considered and prevents the posting of unrealized foreign currency gains.

    Hope this helps,

    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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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