Study guide
4.5 Foreign Currency Revaluation & Revaluation Posting Profiles
Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: MB-310 Exam Overview & Financial Architecture
1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework
2 Chapter 2: Chart of Accounts & Main Accounts
2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions
3 Chapter 3: Financial Dimensions & Account Structures
3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates
4 Chapter 4: Ledgers, Calendars & Currencies
4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles
5 Chapter 5: General Ledger Journals & Allocations
5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals
6 Chapter 6: Intercompany Accounting & Settlements
6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing
7 Chapter 7: Cash and Bank Management
7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting
8 Chapter 8: Periodic Closing & Financial Consolidations
8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules
9 Chapter 9: Sales Tax & Withholding Tax
9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting
10 Chapter 10: Accounts Receivable Setup & Invoicing
10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts
11 Chapter 11: Credit Management & Collections
11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals
12 Chapter 12: Subscription Billing & Revenue Deferrals
12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)
13 Chapter 13: Accounts Payable & Invoice Processing
13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation
14 Chapter 14: Vendor Payments & Expense Management
14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses
15 Chapter 15: Budgeting & Budget Control
15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries
16 Chapter 16: Fixed Assets Configuration & Transactions
16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)
4.5 Foreign Currency Revaluation & Revaluation Posting Profiles
Key Takeaways Explain This Topic AI
General ledger foreign currency revaluation restates monetary main accounts to current spot rates and posts unrealized gain or loss, in line with IAS 21 and ASC 830.
A main account is revalued only when Foreign currency revaluation is enabled on the main account record — balance sheet monetary accounts, not profit-and-loss accounts.
The currency revaluation posting profile maps unrealized gain and unrealized loss accounts by currency, main account, and legal entity.
Revaluation can be run in simulation to preview the calculated adjustment, and a posted revaluation run can be reversed as a discrete batch.
Last updated: August 2026
4.5 Foreign Currency Revaluation & Revaluation Posting Profiles
Quick Summary: Foreign currency revaluation restates open foreign-currency balances at period end and books the unrealized difference through the currency revaluation posting profile. This section covers main account eligibility, the posting profile lookup, simulation and reversal, and a full worked calculation.
1. General Ledger Foreign Currency Revaluation Architecture
At the end of an accounting period, foreign-currency denominated monetary balances (such as foreign bank accounts, foreign loans payable, or non-subledger foreign receivables) must be adjusted to reflect the closing spot exchange rate. This process is executed via General ledger > Periodic tasks > Foreign currency revaluation . +-----------------------------------------------------------------------------+
- | FOREIGN CURRENCY REVALUATION WORKFLOW |
- +-----------------------------------------------------------------------------+
- | [1. Identify Accounts] --> Eligible Main Accounts (Revaluation = Yes) |
- | | |
- | v |
- | [2. Compute Difference] --> (BalanceCur * NewRate) - Current BalanceMST |
- | | |
- | v |
- | [3. Determine Result] --> Gain (Credit Unrealized) / Loss (Debit Unreal) |
- | | |
- | v |
- | [4. Post Voucher] --> Debit/Credit Main Account vs Unrealized Gain/Loss|
- +-----------------------------------------------------------------------------+
- Subledger vs. General Ledger Revaluation Boundaries
A critical architectural principle on the MB-310 exam is understanding which revaluation tool to execute for each account type:
Account Classification Revaluation Routine to Run Navigation Path Why NOT in General Ledger Revaluation?
Accounts Receivable Trade (Customer Control 120100 ) AR Foreign currency revaluation Accounts receivable > Periodic tasks > Foreign currency revaluation Running in GL revalues the control account without updating customer subledger balances, breaking AR-to-GL reconciliation.
Accounts Payable Trade (Vendor Control 210100 ) AP Foreign currency revaluation Accounts payable > Periodic tasks > Foreign currency revaluation Running in GL revalues the control account without updating vendor open vouchers, breaking AP-to-GL reconciliation.
Cash & Bank Accounts Bank Foreign currency revaluation (or GL) Cash and bank management > Periodic tasks > Bank foreign currency revaluation Revalues bank master records and updates bank subledger valuation balances.
General Ledger Main Accounts (Loans, Intercompany, Cash) Ledger Foreign currency revaluation General ledger > Periodic tasks > Foreign currency revaluation Revalues all eligible non-subledger monetary main accounts across transaction currencies.
2. Main Account Eligibility & Revaluation Posting Profiles
Not all general ledger accounts should be revalued. Under IAS 21 / ASC 830, only monetary assets and liabilities (cash, receivables, payables, debt) are subject to periodic revaluation. Non-monetary items (fixed assets, inventory, prepaid expenses, equity) must remain at historical exchange rates. +-----------------------------------------------------------------------------+
- | MAIN ACCOUNT REVALUATION CONFIGURATION |
- +-----------------------------------------------------------------------------+
- | Main Account: 250100 (Foreign Senior Notes Payable - EUR) |
- | - Main Account Type: Liability |
- | - Foreign currency revaluation toggle: [ YES ] <--- MANDATORY ELIGIBILITY |
- | - Exchange rate type: [ CLOSING ] (Optional Override) |
- +-----------------------------------------------------------------------------+
- The "Foreign Currency Revaluation" Toggle
Located on the General FastTab of the Main accounts form ( General ledger > Chart of accounts > Accounts > Main accounts ).
If set to 'No': The main account is completely bypassed during General Ledger foreign currency revaluation, even if the account number is included in the periodic job's query filter.
If set to 'Yes': The main account's foreign-denominated transaction balances are evaluated and restated by the revaluation engine.
3. Revaluation Parameters, Simulation Runs & Reversals
When launching the Foreign currency revaluation periodic job, the accountant configures key calculation parameters: +-----------------------------------------------------------------------------+
- | PERIODIC REVALUATION PARAMETER DIALOG (GL > Periodic > Reval) |
- +-----------------------------------------------------------------------------+
- | From date: [ 2026-08-01 ] |
- | To date: [ 2026-08-31 ] |
- | Date of rate: [ 2026-08-31 ] (Determines which spot rate to apply) |
- | Dimension focus: [ MainAccount_BU_Dept ] |
- | Exchange rate type: [ CLOSING ] |
- | Simulation run: [ YES ] <--- VALIDATE WITHOUT COMMITTING TO DATABASE |
- | Records to include: MainAccount == 250100..250999 |
- +-----------------------------------------------------------------------------+
- Key Parameter Explanations
Date of rate: Specifies the exact calendar date whose exchange rate will be fetched from the designated exchange rate type to recalculate balances.
Dimension focus: Determines the financial dimension granularity at which balances are revalued and whether gain/loss vouchers will inherit the original transaction dimensions.
Simulation Run:
When 'Yes': Executes the full revaluation algorithm and produces a detailed audit report showing projected gains, losses, and new balances, but does not post any vouchers to the General Ledger.
When 'No': Posts live general ledger adjustment vouchers to the Unrealized Gain / Unrealized Loss accounts.
Reversing Historical Revaluations
If a revaluation was run with an incorrect date of rate, erroneous exchange rate type, or incorrect account filter, Dynamics 365 Finance provides an automated reversal feature:
Navigate to General ledger > Periodic tasks > Foreign currency revaluation .
In the revaluation history grid, select the executed revaluation batch.
Click Reverse on the Action Pane.
The system automatically creates exact compensating debit/credit vouchers that neutralize the historical unrealized gain/loss postings.
4. End-to-End Worked Numerical Example
To understand the dual-currency mechanics and foreign currency revaluation, consider a complete 3-stage accounting lifecycle for US legal entity USMF (Accounting Currency = USD , Reporting Currency = EUR ).
Stage 1: Initial Transaction (August 10, 2026)
USMF takes out a foreign currency bank loan of €100,000.00 EUR (Transaction Currency = EUR ).
Spot Exchange Rate on Aug 10: 1 EUR = 1.10 USD
Accounting Currency Amount ($): 100 , 000 × 1.10 = $ 110 , 000.00 USD 100,000 \times 1.10 = \mathbf{\text{\textdollar}110,000.00\text{ USD}} 100 , 000 × 1.10 = $ 110 , 000.00 USD
Initial GL Voucher Posted:
- Debit: Foreign Cash Account ( 110200 ): $110,000.00 USD (€100,000.00 EUR)
- Credit: Foreign Notes Payable ( 250100 ): $110,000.00 USD (€100,000.00 EUR)
- Stage 2: Month-End Revaluation (August 31, 2026)
At month-end, the Euro strengthens against the US Dollar.
Closing Spot Exchange Rate on Aug 31: 1 EUR = 1.15 USD
New Valuation of Note Payable: 100 , 000 × 1.15 = $ 115 , 000.00 USD 100,000 \times 1.15 = \mathbf{\text{\textdollar}115,000.00\text{ USD}} 100 , 000 × 1.15 = $ 115 , 000.00 USD
Existing Book Value: $ 110 , 000.00 USD \text{\textdollar}110,000.00\text{ USD} $ 110 , 000.00 USD
Unrealized Exchange Loss: $ 115 , 000.00 − $ 110 , 000.00 = $ 5 , 000.00 USD \text{\textdollar}115,000.00 - \text{\textdollar}110,000.00 = \mathbf{\text{\textdollar}5,000.00\text{ USD}} $ 115 , 000.00 − $ 110 , 000.00 = $ 5 , 000.00 USD
Periodic GL Revaluation Voucher Generated:
- Debit: Unrealized Foreign Currency Loss ( 750200 ): $5,000.00 USD
- Credit: Foreign Notes Payable ( 250100 ): $5,000.00 USD
Result: Notes Payable balance sheet carrying value is now accurately restated to $115,000.00 USD .
Stage 3: Loan Repayment & Settlement (September 15, 2026)
USMF repays the €100,000.00 EUR loan when the exchange rate has moved to 1 EUR = 1.18 USD .
Total Cash Paid: 100 , 000 × 1.18 = $ 118 , 000.00 USD 100,000 \times 1.18 = \mathbf{\text{\textdollar}118,000.00\text{ USD}} 100 , 000 × 1.18 = $ 118 , 000.00 USD
Total Realized Loss over original invoice: $ 118 , 000.00 − $ 110 , 000.00 = $ 8 , 000.00 USD \text{\textdollar}118,000.00 - \text{\textdollar}110,000.00 = \mathbf{\text{\textdollar}8,000.00\text{ USD}} $ 118 , 000.00 − $ 110 , 000.00 = $ 8 , 000.00 USD
Settlement Postings:
- Debit: Foreign Notes Payable ( 250100 ): $115,000.00 USD (Clears carrying balance)
- Credit: Bank Cash Account ( 110100 ): $118,000.00 USD (Actual cash disbursed)
- Debit: Realized Foreign Currency Loss ( 750100 ): $8,000.00 USD
- Credit: Unrealized Foreign Currency Loss Reversal ( 750200 ): $5,000.00 USD (Reverses August unrealized loss)
Net P&L Impact in September: $ 8 , 000.00 − $ 5 , 000.00 = $ 3 , 000.00 Loss \text{\textdollar}8,000.00 - \text{\textdollar}5,000.00 = \mathbf{\text{\textdollar}3,000.00\text{ Loss}} $ 8 , 000.00 − $ 5 , 000.00 = $ 3 , 000.00 Loss (representing movement from 1.15 to 1.18).
5. Step-by-Step Configuration & Execution Walkthrough +-----------------------------------------------------------------------------+
- | GL REVALUATION CONFIGURATION & EXECUTION |
- +-----------------------------------------------------------------------------+
- | 1. Enable Main Accounts --> Set 'Foreign currency revaluation' = Yes |
- | |
- | 2. Configure Accounts --> Set Realized/Unrealized Gain & Loss accounts |
- | |
- | 3. Execute Simulation Run --> Run with 'Simulation = Yes', verify report |
- | |
- | 4. Execute Final Post --> Run with 'Simulation = No', post vouchers |
- | |
- | 5. Audit & History --> Review posted records / Execute Reversal |
- +-----------------------------------------------------------------------------+
- Step 1: Enable Main Account for Revaluation
Navigate to General ledger > Chart of accounts > Accounts > Main accounts .
Select Account 250100 (Foreign Notes Payable).
On the General FastTab, toggle Foreign currency revaluation to Yes .
Click Save .
Step 2: Configure Revaluation Accounts
Navigate to General ledger > Currencies > Currency revaluation accounts .
In Main account , select 250100 .
Populate Unrealized gain account ( 750150 ) and Unrealized loss account ( 750200 ).
Populate Realized gain account ( 750100 ) and Realized loss account ( 750110 ).
Click Save .
Step 3: Run Revaluation in Simulation Mode
Navigate to General ledger > Periodic tasks > Foreign currency revaluation .
In From date , enter 8/1/2026 .
In To date , enter 8/31/2026 .
In Date of rate , enter 8/31/2026 .
Select Exchange rate type : CLOSING .
Toggle Simulation run to Yes .
Click Filter under Records to include and filter for MainAccount == 250100 .
Click OK to view the non-posting simulation preview report.
Step 4: Run Live Posting Revaluation
Re-open the form, keep identical parameters, and toggle Simulation run to No .
Click OK . The system posts the live revaluation vouchers.
6. Exam Traps & Real-World Best Practices
Warning
Exam Trap: Revaluing AP and AR Control Accounts in General Ledger A classic MB-310 exam question tests what happens if an administrator runs General Ledger foreign currency revaluation on Accounts Payable Trade Control ( 210100 ) or Accounts Receivable Trade Control ( 120100 ). Doing so will generate GL adjustments that do not update the AP/AR vendor/customer open transaction subledgers , causing the GL Trial Balance and the Subledger Aging reports to immediately fall out of balance! Always revalue AP via Accounts payable > Periodic tasks > Foreign currency revaluation and AR via Accounts receivable > Periodic tasks > Foreign currency revaluation .
Tip
Consultant Pro-Tip: Automated Revaluation Reversals at Period Open Depending on corporate accounting policy, some enterprises prefer reversing unrealized foreign currency adjustments on the first day of the subsequent month (Period opening reversal). In Dynamics 365 Finance, you can schedule the Foreign currency revaluation job to automatically reverse in the following period by selecting the appropriate revaluation profile method or running the Reverse action on the previous month's batch record.