Job page · Accounts receivable

Foreign currency revaluation

The page that revalues open Accounts receivable transactions in foreign currencies with a new exchange rate on a specified date.

Used by: Accounts receivable manager, Collections manager, Accounting manager and 3 more roles
Business process: —
Menu item: CustExchRateAdjustment
Main table: CustExchRateAdjustment
Data entity: —
Setup steps: —

Show what matters for

Everyone

1What it is and why

What it is	The page that revalues open Accounts receivable transactions in foreign currencies with a new exchange rate on a specified date.
What you do here	Used to run (immediately or in batch) the revaluation that posts unrealized gains or losses for open transactions, and to view the history and transactions of each run.
Example	Before revaluing open foreign currency amounts, run Simulation on the Foreign currency revaluation page for the same date and method to preview the unrealized gain or loss.

Functional consultant · Solution architect

Business process	—
Menu path	Accounts receivable › Periodic tasks › Foreign currency revaluation
Set up first	Currency exchange rates Microsoft Learn ↗Accounts receivable parameters Microsoft Learn ↗
Used next by	—
Related pages	Foreign currency revaluation automation Microsoft Learn ↗

End user · Functional consultant

Go to Accounts receivable > Periodic tasks > Foreign currency revaluation.
Optionally select Simulation first to preview the unrealized gain or loss.
Select Foreign currency revaluation.
In the Method field, select Standard, Minimum or Invoice date.
In the Considered date field, select the date on which open transactions are found and adjusted.
In the Date of rate field, select the date of the exchange rate to use.
In the Use posting profile from field, select Posting or Select, and choose a posting profile if needed.
Select which financial dimensions to post.
Set the Print option to Yes to print the report, and then run the process.

Field	What it means	Worked example	Table column
Method	Standard posts gains and losses, Minimum posts only losses, and Invoice date returns transactions to their original rate.Microsoft Learn ↗	—	`ExchPrinciple`
Considered date	Transactions that are open on this date are revalued; it becomes their last revaluation date.Microsoft Learn ↗	—	`ConsideredDate`
Date of rate	The date whose exchange rate is used.Microsoft Learn ↗	—	`DateOfRate`
Use posting profile from	Uses each transaction's posting profile, or one you select.Microsoft Learn ↗	—	`UseProfile`
Financial dimensions	Which dimensions are posted on the revaluation entries: none, the customer's, or the original transaction's.Microsoft Learn ↗	—	`Dimensions`

Functional consultant

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

Solution architect

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	Choose whether to print the results before you run the revaluation; the report can't be reprinted afterwards. Revaluing again reverses the earlier unrealized gain or loss and posts a new one. Microsoft Learn ↗

Technical architect

Menu item	`CustExchRateAdjustment` Checked in Dynamics 365
Form	`CustExchRateAdjustment` Checked in Dynamics 365
Table	`CustExchRateAdjustment`Shown as “Foreign currency revaluation” in Record infoKey field: RecIdChecked in Dynamics 365
Data entities	—
Who can open it	PrivilegesAdjust exchange rate for customer transactions `CustExchRateAdjustmentProcess`DutiesEnable invoice and cash process `CustInvoiceInvoiceAndCashProcessEnable`Enable invoice and cash process `RentalCustInvoiceInvAndCashProcEnable` 6 security roles Collections manager `CollectionLetterCollectionsManager`Accounts receivable manager `CustInvoiceAccountsReceivableManager`Accounting manager `LedgerAccountingManager`Accounting supervisor `LedgerAccountingSupervisor`Rental coordinator agent `RentalCoordinatorAgent`Rental manager `RentalManager` Checked in Dynamics 365
Actions on the page	Options: Personalize, Page options, ShareChecked in Dynamics 365

Developer

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

Everyone