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) / Accounts Receivable Re...
Microsoft Dynamics AX (Archived)

Accounts Receivable Revaluation

(0) ShareShare
ReportReport
Posted on by MrAxapta89 975

Hi All,

I have an issue where trying to run the Foreign Currency Revaluation in the AR module. I get an error that states "Account number for transaction type Exchange Rate loss does not exist". I have checked "accounts for automatic transactions" and added an account for Exchange Rate Loss. I have also checked GL > Setup > Currency > Currency Revaluation Accounts, here I populated accounts for AUD currency and USD currency, I still get the error. Please advise.

(AX 2012 R2)

*This post is locked for comments

I have the same question (0)
  • MrAxapta89 Profile Picture
    MrAxapta89 975 on at

    Anyone have any idea on this? This is time sensitive as our finance team needs to complete this task by EOD.

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    Hi MrAxapta89,

    I notice you can also set these accounts at G/L -> Setup -> Ledger, at the bottom of this form.

  • MrAxapta89 Profile Picture
    MrAxapta89 975 on at

    Hi Guy,

    Thanks for your reply. Unfortunately, I have already populated accounts here as well.

    Thanks,

    Dave

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    Go to G/L -> Setup -> Ledger. Under 'Account structures', make a note of the Account structure(s) listed.

    Go to G-L -> Setup -> Chart of accounts -> Configure account structures.

    Find the Account structure(s) you noted in the first step. Are they Active? Does one of them contain the account you think this exchange rate loss should be posting to?

  • MrAxapta89 Profile Picture
    MrAxapta89 975 on at

    Hi Guy,

    I just checked where you suggested. All account structures are indeed active, also, the account that the exchange rate loss should post to is define there. It is also set to allow blanks for all dimensions.

    Thanks,

    Dave

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    Running out of ideas now....

    I assume on the Currency revaluation accounts form, the 'Ledger' in which you have set these accounts is the right one.

    At G/L -> Setup -> Ledger, is the Accounting currency one of USD or AUD? If not, have you set up exchange gain/loss accounts for that currency.

    When you run the Revaluation job, can you use the Select to run it for transactions in one currency at a time to determine which currency is causing the problem?

  • MrAxapta89 Profile Picture
    MrAxapta89 975 on at

    Hi Guy,

    Thanks for the suggestion. I checked the ledger and the accounting currency is USD. I also doubled checked and made sure gain/loss accounts were populated again anyway.

    I followed your suggestion to try and narrow down the issue and found I was able to run the revaluation job using the AUD currency. However, when I tried with the USD currency I got the same error. So I can tell that it is definitely with the USD currency but I am unsure what to check next. Any ideas?

    Thanks again!

  • MrAxapta89 Profile Picture
    MrAxapta89 975 on at

    Hey is something interesting I found. When I looked at the voucher for the posted AUD revaluation it is using the account that is define under "Ledger" Unrealized loss. This is NOT  the same account that I set up under GL > Setup > Currency > Currency revaluation accounts (I picked a different one quickly because it is a test environment). This leads me to believe that I am missing the set up somewhere for USD.

    Is there a place to define unrealized USD (it is not the account currency for the entity).

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    Maybe you could:

    1. Run another currency evaluation in Contoso

    2. Look at the voucher transaction from Origin to trace all GL, subledger and sometimes temporary sub-subledger accts.

    Sometimes there are  temporary summary accounts in between the revaluation (sometimes acct pending approval, then offset approved transaction acct), before the transaction finally posts.

    Check the temp accounts in between.

  • MrAxapta89 Profile Picture
    MrAxapta89 975 on at

    Unfortunately, I do not have access to a contoso environment. I appreciate your tip though, that is good thinking.

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
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans