Finance | Project Operations, Human Resources, ...

Foreign revaluation for accounting currency transactions

(0) Share

Report

Posted on by Mr Kenneth

Hi everyone,

I work for a company that have EUROS as a accounting currency, but Finance department needs to all that transactions that were posted in EUROS, have their secondary amount (DOLLARS) re valuated. We exclude Euros currency when we run revaluations on GL an AP/AR modules... at the end, they need this because they need to have their trial balance in dollars to send that information to headquarters, and for example, if an invoice were posted last month for 110 Euros equivalent to $100, they want that this month with an exchange rate of 1.2, this amounts change to 110 Euros and $91.66 ...does anyone know if there is a way to do that without affecting accounting currency amounts? After dual currency functionality released, we are a little bit afraid of run revaluation in accounting currency.

Regards,

Kenneth

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

saurabh bharti 15,059 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Kenneth,

If this all about presenting financials in USD on certain exchange rate then that can be achieved through "Management reporter" report design. Here is the link in which last section explains how you can generate report in different currency without changing anything in Dynamics.

docs.microsoft.com/.../generating-consolidated-financial-statements

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Kenneth,

What you describe isn't this a currency translation issue that needs to be handled in the Financial reporter when you design your report?

Best regards,

Ludwig

Was this reply helpful? Yes No
Mr Kenneth 65 on at

Like (0)

Report
Copy link

Link copied!

Thank you both for your asnwers. I´ve been testing Report Designer. I used a GL main account and add a “Financial reporting exchange rate type” different than the “Exchange rate type”, just the see if there is some variation and then generated the TB, but it still show the same amount. Should I have to run some process to update the amount taking in consideration the “new” Exchange rate type?

And in the row definitions of the Report Designer, I know that I can add automatically all the main accounts using “Insert rows from dimensions” but, is there a way to add automatically all the financial dimensions? Main account, sub account, etc. I´m trying but doesn´t seems to work.

Really appreciate your help.

Regards,

Kenneth

Was this reply helpful? Yes No