BeyondERP.Subscribe

Job page · General ledger

Foreign currency revaluation

The page for the General ledger foreign currency revaluation process, which also shows the history of each revaluation run.

Used by
Accountant, Accounting manager, Accounting supervisor and 1 more role
Business process
—
Menu item
LedgerExchAdj
Main table
LedgerExchAdjHist
Data entity
—
Setup steps
—
Show what matters for

Everyone

1What it is and why

What it isThe page for the General ledger foreign currency revaluation process, which also shows the history of each revaluation run.
What you do hereUsed to revalue main account balances posted in foreign currencies and generate unrealized gain or loss transactions, with a preview before posting and an option to reverse a revaluation.
ExampleRevalue the balances for January 1 to January 31 but use the exchange rate defined for February 1.
Foreign currency revaluation page in Dynamics 365
The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business process—
Menu pathGeneral ledger › Periodic tasks › Foreign currency revaluation
Set up firstMain accounts Microsoft Learn ↗Ledger Microsoft Learn ↗Currency revaluation accounts Microsoft Learn ↗
Used next by—
Related pagesForeign currency revaluation Microsoft Learn ↗Foreign currency revaluation Microsoft Learn ↗Ledger settlements Microsoft Learn ↗

End user · Functional consultant

3How to do it

Microsoft's steps

  1. Go to General ledger > Periodic tasks > Foreign currency revaluation and select Foreign currency revaluation.
  2. Enter the From date and To date for the balances to revalue.
  3. In the Date of rate field, enter the date whose exchange rate should be used.
  4. Choose which main accounts to revalue: All, Balance sheet or Profit and loss.
  5. Select the legal entities and the foreign currencies to revalue.
  6. Set Preview before posting to Yes to review the result.
  7. From the preview, select Post.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
From dateStart of the period; for balance sheet accounts it is ignored and the balance from the start of the fiscal year is used.Microsoft Learn ↗—FromDate
Date of rateThe date whose exchange rate is used for the revaluation.Microsoft Learn ↗—ExchangeRateDate
Preview before postingShows the result first so that it can be checked and posted without running again; not available in batch.Microsoft Learn ↗——
Exclude reporting currency adjustmentsLeaves out amounts posted with the reporting currency adjustment journal.Microsoft Learn ↗——

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
— No setup is made on this page.

Solution architect

5Design impact

Shared or per company—
Can it be undone—
Feature or country—
If you change it laterRevaluations can be reversed out of date order, but a later revaluation may also need reversing to keep each account's balance right. Microsoft Learn ↗

Technical architect

6Technical

Menu itemLedgerExchAdj Checked in Dynamics 365
FormLedgerExchAdjHist Checked in Dynamics 365
TableLedgerExchAdjHistShown as “Foreign currency revaluation” in Record infoChecked in Dynamics 365
Data entities—
Who can open itPrivilegesMaintain foreign currency revaluation history LedgerExchAdjHistMaintainView foreign currency revaluation history LedgerExchAdjHistViewDutiesMaintain foreign currency revaluation history LedgerExchAdjHistMaintainView foreign currency revaluation history LedgerExchAdjHistViewMaintain journals and transactions LedgerJournalsAndTransactionsMaintain
4 security rolesAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialController
Checked in Dynamics 365
Actions on the pageButtons: Foreign currency revaluation, Voucher transactions, Reverse transactions, ReviewedChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=LedgerExchAdj
Integrate with—
Table definitionLedgerExchAdjHist columns and relations Microsoft data model ↗

Everyone

8Sources and checks