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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Ledger settlement - local/reporting currency (EUR) different to accounting currency (USD)

(0) ShareShare
ReportReport
Posted on by 20

Our company is set up to report is EUR - this means all transactions are (usually) in EUR but our accounting currency is USD as this is what the parent company is so we have both currencies in our TB. 

When I go to utilize the ledger settlements (new feature of finance version 10.0.25 is in use) the 'marked' value is my USD translated value that is checked to equal nil to allow the ledger settlement. 

The problem is my opening balances - these were recorded at year end at the average rate for the month. The revaluation was run and an FCR entry created to move the exchange rate to the month end exchange rate. 

The opening balance is then at the month end exchange rate. 

In the new year, the year end entry is automatically reversed by the system and reverses at the ORIGINAL rate (i.e. the av rate for the month) to my amounts do not settle to nil. 

I am able to settle the monthly recording and then in the new month reversing as these are done at the same rate. 

I note the FCR entries but they combine revaluation amounts for all months and I cannot take a piece to settle my opening balance. 

To summarize, how do I settle my opening balance brought forward when it was brought forward at the month end rate the then reversed at the original average rate? Ledger-settlements.PNG

I have the same question (0)
  • BillurSamdancioglu Profile Picture
    19,036 Most Valuable Professional on at
    RE: Ledger settlement - local/reporting currency (EUR) different to accounting currency (USD)

    I asked the same question before to Microsoft and was advised to run the revaluation but can not remember the exact case.

  • Suggested answer
    Charlotte X Profile Picture
    on at
    RE: Ledger settlement - local/reporting currency (EUR) different to accounting currency (USD)

    Hi Caro_Smart,

    You can try running the General Ledger Foreign currency revaluation in the consolidation entity, after running the consolidation. This will revalue the year to date balance of each balance sheet account (including the opening balance) using the rate on the date of rate specified.

    Best Regards,

    Charlotte Xu

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,258

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 949 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 631 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans