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 › Currencies › Foreign currency revaluation
Set up firstMain accounts Microsoft Learn ↗Ledger Microsoft Learn ↗Currency revaluation accounts Microsoft Learn ↗
Used next by—
Related pagesCurrency revaluation posting profile Microsoft Learn ↗Foreign currency revaluation Microsoft Learn ↗Foreign currency revaluation Microsoft Learn ↗

End user · Functional consultant

3How to do it

Microsoft's steps

  1. Go to General ledger > Currencies > Foreign currency revaluation.
  2. Select Foreign currency revaluation.
  3. Enter the From date and To date for the balances to revalue.
  4. In the Date of rate field, enter the date whose exchange rate should be used.
  5. Choose which main accounts to revalue: All, Balance sheet or Profit and loss, and narrow the range on the Records to include tab if needed.
  6. Select the legal entities and the currencies to revalue.
  7. Set Preview before posting to Yes if you want to review the results first.
  8. Run the process, or post the results from the preview.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
From dateStart of the period to revalue; 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, which can differ from the period being revalued.Microsoft Learn ↗—ExchangeRateDate
Preview before postingShows the results first so they can be checked, exported to Excel and posted without running the process again.Microsoft Learn ↗——
Exclude reporting currency adjustmentsLeaves out amounts posted with the reporting currency adjustments journal; they are included by default.Microsoft Learn ↗——
Reverse transactionReverses a past revaluation and adds a history record for the audit trail.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 laterEarlier revaluations aren't reversed; each run posts only the difference between the current balance, including past revaluations, and its new value. Reversals can be done out of date order, but a later revaluation may also need reversing to keep balances right. Microsoft Learn ↗

Technical architect

6Technical

Menu itemLedgerExchAdj Checked in Dynamics 365
FormLedgerExchAdjHist Checked in Dynamics 365
TableLedgerExchAdjHistShown as “Foreign currency revaluation” in Record infoKey field: RecIdChecked 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 pageOptions: Personalize, Page options, ShareChecked 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