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 amount of th...
Microsoft Dynamics AX (Archived)

Currency amount of the transaction that foreign exchange gain and losses have been calculated on in Dynamics AX 2009

(0) ShareShare
ReportReport
Posted on by denny910 15

Dear Friends,

I have run  foreign exchange adjustment on the end of last month in Dynamics AX 2009   but  since than   I have two big problems:

1. Before running foreign exchange adjustments I  made simulation both in   payables and receivables moduls and I  `ve got figures that I`ve expected to have  on GL accounts for foreign exchange gain and losses but I`ve got on  foregn exchange gain and losses  amounts much bigger  than   those that were shown  on simulation file.

2.When I`ve tried to find the origin of these gain and losses in order to see why they are so big  I realized that I can not trace  the origin  of the calculation.

I  have  indead  voucher transactions  but I can not trace in them neither  the currency amount nor the any detail that the calculation have been made on. The currency amount is shown  as  0  EUR  while  foreign exchange loss exists in local currency. Is there any report  in AX  2009 where I can trace currency amount  that realized and unrealized foreign exchange gains and losses are calculated on?

PLEASE HELP!

*This post is locked for comments

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

    Hi,

    Have you tried comparing the currency revaluation voucher with the transactions that you find on the revaluation accounts?

    Do you have manual postings on the revaluation accounts?

    Can you identify any 'strange' postings on your revaluation accounts by analyzing the transaction and posting type?

    Best regards

    Ludwig

  • denny910 Profile Picture
    denny910 15 on at

    Hi Ludwig,

    Thanks a lot for your participation.

    In responding to your suggestions I can say:

    1.The revaluation account and the currency revaluation voucher have the same total value.

    2. Fortunately, I don`t have manual postings on revaluation accounts.

    3. I really do have "strange" postings on revaluation accounts but I can not trace their origin ( do they come from GL, from Payables or Receivables...).

    I`ve tried to find their origin by generating Ledger account report for revaluation account but it does not show the base for calculation (currency amount), only revaluations` differences in local currency.

    Best regards,

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

    Hi,

    Ah, you want to have a report that breaks down the posted revaluation amounts (original amount, old & new exchange rate, etc), right?

    I'm not aware of such a report.

    If you plan to create such a report yourself think whether the costs to create it justify the costs because the revaluation amounts will be reversed anyway once the invoices are paid.

    In addition, such a report could include many transactions which might not really help if you get e.g. a 50 page report.

    Best regards

    Ludwig

  • denny910 Profile Picture
    denny910 15 on at

    Hi Ludwig,

    You are absolutely right: I need  such a  report.

    Anyway, I  will check tomorrow again all transactions according to your suggestions.

    Best regards and thank you a lot,

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