BeyondERP.Newsletter
Menu

Setup step on the Foreign currency revaluation page · Cash and bank management

Revalue foreign currency bank balances

Use this page at each period end to revalue the accounting and reporting currency balances of foreign currency bank accounts and post unrealized gain or loss.

Used by
Chief financial officer, Accountant, Accounting manager and 3 more roles
Business process
Perform bank balance currency revaluation in Dynamics 365 Finance
Menu item
BankCurrencyRevalHistory
Main table
BankCurrencyRevalHistory
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA page that shows the history of each bank foreign currency revaluation and lets you run a new one.
What you do hereUse this page to revalue the foreign currency balances of one or more bank accounts across legal entities.
ExampleFor example, you can revalue the balances as of January 31 but use the exchange rate defined for February 1.
Foreign currency revaluation page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAt each period end, after all bank transactions for the period are posted.
How oftenOnce per period end for each bank account in a foreign currency.
Batch settingsSchedule it as a batch job when you revalue many bank accounts across legal entities. Set Preview before posting to No, because a preview isn't available in batch.
What the output showsUnrealized gain or loss vouchers for each revalued bank account: one for the accounting currency and, when relevant, one for the reporting currency, split across the financial dimensions on the bank transactions. Very large offsetting debit and credit lines with a small net amount come from the legacy dimension allocation; the Enhancements to bank foreign currency revaluation feature changes that logic.

Source: Microsoft Learn

Setup steps on this page

Revalue foreign currency bank balances

Use this page at each period end to revalue the accounting and reporting currency balances of foreign currency bank accounts and post unrealized gain or loss.

Steps from Microsoft

  1. Go to Cash and bank management > Periodic tasks > Foreign currency revaluation.
  2. On the Action Pane, select Foreign currency revaluation to open the Bank - foreign currency revaluation dialog.
  3. Set Revaluation date to the cutoff date; the sum of all bank transactions up to this date is revalued.
  4. Set Exchange rate date to the date of the rate to use. For example, you can revalue balances as of January 31 with the rate of February 1.
  5. Select the legal entities, and then the foreign currency bank accounts to revalue.
  6. Set Preview before posting to Yes to review and export the results to Excel before posting; a preview can't run as a batch job.
  7. Post the revaluation and open the new history line and its voucher on the Foreign currency revaluation page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Revaluation dateThe cutoff date; all bank transactions up to this date are revalued.Microsoft Learn 1/31/2027TransDate
Exchange rate dateThe date of the exchange rate used for the revaluation.Microsoft Learn 2/1/2027ExchangeRateDate
Preview before postingLets you review and export the results before you post them; batch processing isn't available with a preview.Microsoft Learn Yes
Legal entitiesThe legal entities whose foreign currency bank accounts you revalue; the lookup shows only the ones you have access to.Microsoft Learn
Exchange rate type sourceOn Cash and bank management parameters (General tab): Ledger, Specific (per legal entity) or Bank (per bank account) decides which exchange rate types the revaluation uses.Microsoft Learn Ledger

Common errors and fixes

MessageWhat to do
Revaluation runs but posts no gain or lossWith Enhancements to bank foreign currency revaluation on, run Reset foreign currency revaluation, define dimension level first and use a revaluation date after the reset posting date; the account also needs a foreign currency balance after that date. Microsoft Learn
The voucher has very large debit and credit lines but a small net amountThe legacy calculation spreads the adjustment across financial dimensions in proportion to their balances. Turn on Enhancements to bank foreign currency revaluation (after the one-time reset) to calculate per ledger account. Microsoft Learn
An older revaluation can't be reversedReverse the most recent revaluation first, then older ones in date order, then run new revaluations for the reversed periods. Microsoft Learn

Test checklist

  1. A history line exists for each legal entity and posting layer that was revalued.
  2. The voucher posts to the unrealized gain or loss account and to the bank main account.
  3. Bank accounts in the accounting currency got no accounting currency entry.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Revalue foreign currency bank balancesRevaluation date = the last day of the period; Exchange rate date = the date of the rate policy (often the same day); Preview before posting = Yes for the first runs, exported to Excel as the working paper.The preview can be posted without rerunning and keeps a record of the calculation; batch processing can't be used with a preview.Which exchange rate types should bank revaluation use?Running it before all bank transactions of the period are posted; the late transactions are left out and the next run must make up for them.Test: Revaluation posts unrealized gain or loss

Number sequences

ReferenceShared or per companyNote
Foreign currency revaluationPer companySet on the Number sequences tab of Cash and bank management parameters before the first revaluation. Microsoft Learn

Feature management and licence

Feature to turn onForeign currency revaluation performance improvements (Mandatory from 10.0.43)Exchange rate type enhancement for bank foreign currency revaluation (Optional)Enhancements to bank foreign currency revaluation (Optional; can't be turned off once enabled)
Licence or add-inIn this system 6 roles can open this page, among them Chief financial officer, Accountant, Accounting manager and Accounting supervisor.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyGlobal page: from one page you revalue bank accounts in every legal entity you have access to. A history record is created for each legal entity and posting layer. Microsoft Learn
Can it be undoneReversible newest first: Reverse transaction undoes a run; several runs are reversed from the most recent back.
If you change it laterPosts unrealized gain or loss transactions to the ledger for each revalued bank account. Revaluations can only be reversed newest first. Microsoft Learn
Technical architect

6Technical

Menu itemBankCurrencyRevalHistory Checked in Dynamics 365
FormBankCurrencyRevalHistory Checked in Dynamics 365
TableBankCurrencyRevalHistoryShown as “Foreign currency revaluation” in Record infoChecked in Dynamics 365
Who can open itPrivilegesView bank - foreign currency revaluation history BankCurrencyRevalHistoryViewDutiesInquire into bank revaluations BankCurrencyRevalInquireMaintain bank revaluations BankCurrencyRevalMaintain
6 security rolesChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerTreasurer PaymTreasurer
Checked in Dynamics 365
Roles to set it up and use itTo use itTreasurer PaymTreasurerChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 6 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankCurrencyRevalHistory
Data migrationLoad order: Bank foreign currency revaluation has no data entity in Data management, so it can't be loaded from a file or a configuration template. It posts revaluation from the bank balances in this environment; revaluations of the old system stay there. Bring opening bank balances in at the go-live rate and revalue from the first period end after go-live.Microsoft Learn
Table definitionBankCurrencyRevalHistory columns and relations Microsoft data model
Everyone

8Sources

To cite this step: CB-JOB-310, Revalue foreign currency bank balances. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-JOB-310