Job page · Accounts payable

Foreign currency revaluation

A periodic page that revalues open (unsettled) vendor transactions in foreign currencies by using a new exchange rate on a specified date, and keeps a record of each revaluation run.

Used by: Accounts payable manager, Accounting supervisor
Business process: —
Menu item: VendExchRateAdjustment
Main table: VendExchRateAdjustment
Data entity: —
Setup steps: —

Show what matters for

Everyone

1What it is and why

What it is	A periodic page that revalues open (unsettled) vendor transactions in foreign currencies by using a new exchange rate on a specified date, and keeps a record of each revaluation run.
What you do here	Used to update the book value of open foreign-currency transactions; the differences are posted as unrealized gains or losses to the subledger and General ledger. It can run in real time or as a batch, and a simulation can be run first.
Example	Exchange rates have moved since vendor invoices in a foreign currency were posted, so at the considered date you revalue the open amounts and post the resulting unrealized gain or loss.

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 path	Accounts payable › Periodic tasks › Foreign currency revaluation
Set up first	Currency exchange rates Microsoft Learn ↗Accounts payable parameters Microsoft Learn ↗
Used next by	—
Related pages	Foreign currency revaluation automation Microsoft Learn ↗

End user · Functional consultant

3How to do it

Microsoft's steps

Go to the Foreign currency revaluation page under Periodic tasks.
First select Simulation to preview the unrealized gain or loss for the same date and method.
Select Foreign currency revaluation.
Choose the Method: Standard, Minimum or Invoice date.
Enter the Considered date and, if needed, the Date of rate.
In Use posting profile from, choose Posting or Select; for Select, enter the Posting profile.
Choose which Financial dimensions to post: None, Table or Posting.
Decide whether to print the report, then run the process now or as a batch job.

Source: Microsoft Learn ↗

Field guide

Field	What it means	Worked example	Table column
Method	How the revaluation posts: always (Standard), only losses (Minimum), or back to the original rate (Invoice date).Microsoft Learn ↗	—	`ExchPrinciple`
Considered date	The date on which open transactions are found and revalued.Microsoft Learn ↗	—	`ConsideredDate`
Date of rate	The date whose exchange rate is used.Microsoft Learn ↗	—	`DateOfRate`
Use posting profile from	Whether the vendor account comes from each transaction's posting profile or from a profile you select.Microsoft Learn ↗	—	`UseProfile`
Financial dimensions	Which dimensions are posted on the revaluation entries: none, the vendor's, or the original transaction's.Microsoft Learn ↗	—	`Dimensions`

Functional consultant

4Setup decisions

Setup step	Recommended value and why	Decision · common mistake · test
— No setup is made on this page.

Solution architect

5Design impact

Shared or per company	Per company: each legal entity has its own records. Microsoft data model ↗
Can it be undone	—
Feature or country	—
If you change it later	Running for a date earlier than a transaction's last revaluation date doesn't adjust that transaction, and the revaluation report can't be reprinted afterwards. Microsoft Learn ↗

Technical architect

6Technical

Menu item	`VendExchRateAdjustment` Checked in Dynamics 365
Form	`VendExchRateAdjustment` Checked in Dynamics 365
Table	`VendExchRateAdjustment`Shown as “Foreign currency revaluation” in Record infoKey field: RecIdChecked in Dynamics 365
Data entities	—
Who can open it	PrivilegesAdjust exchange rates for open vendor transactions `VendExchRateAdjustmentProcess`DutiesEnable invoice and payment process `VendInvoiceInvoicePaymentProcessEnable` 2 security roles Accounting supervisor `LedgerAccountingSupervisor`Accounts payable manager `VendInvoiceAccountsPayableManager` Checked in Dynamics 365
Actions on the page	Options: Personalize, Page options, ShareChecked in Dynamics 365

Developer

7Developer

Open it directly	`https://<your-environment>/?mi=VendExchRateAdjustment`
Integrate with	—
Table definition	`VendExchRateAdjustment` columns and relations Microsoft data model ↗

Everyone

8Sources and checks

learn.microsoft.com/dynamics365/finance/cash-bank-management/foreign-currency-revaluation-accounts-payable-accounts-receivable
learn.microsoft.com/dynamics365/finance/cash-bank-management/foreign-currency-revaluation-accounts-payable-accounts-receivable
learn.microsoft.com/common-data-model/schema/core/operationscommon/tables/finance/accountspayable/transaction/vendexchrateadjustment
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.