For enterprise finance administrators, ERP architects, and project accounting teams, this update replaces manual journal adjustments with automated, exchange-rate-aware settlement logic. Instead of reconciling cash advances strictly through the lens of the company's base accounting currency, Dynamics 365 Project Operations will settle advances based on the transaction currency while explicitly calculating and posting any realized foreign exchange (FX) gains or losses.
Why Legacy Cash Advance Settlements Leave Phantom Balances
To appreciate why this update matters, consider how cash advances have historically behaved in Dynamics 365 Project Operations integrated with ERP. When a company issues a cash advance to an employee before a business trip, that employee acts as a vendor account in the financial subledger. Once the trip concludes and the employee submits an expense report against the paid advance, the system attempts to net the expense against the original advance balance.
According to Microsoft Learn documentation on Project Operations cash advances, the legacy implementation relied primarily on accounting currency values during settlement without adequate awareness of the transaction currency or the timing of exchange rate fluctuations. When foreign-currency advances were involved, three stubborn accounting problems routinely surfaced:
- Inaccurate remaining advance balances: Even if an employee spent the exact foreign currency amount they were advanced, exchange rate shifts between the payout date and the expense report date made it look like the advance was either overpaid or underpaid in the accounting currency.
- Lingering employee vendor balances: Employee accounts carried residual debit or credit balances that did not actually exist in the real world.
- Missing FX postings: The system failed to automatically calculate and post realized foreign exchange gains or losses on the settled advance, forcing finance staff to hunt down the discrepancy and book manual adjustments.
Section Summary: Relying solely on accounting currency equivalents during foreign-currency cash advance reconciliation creates artificial vendor balances and omits realized FX gain or loss entries, requiring manual intervention from finance teams.
How Exchange-Rate-Aware Settlement Works in Practice
Microsoft's new settlement engine—listed on the roadmap as Manage exchange rate variances on cash advances and documented in Microsoft Learn as (Preview) Manage cash advance rate adjustments—separates the clearing of the transaction currency from the recognition of the accounting currency impact.
Microsoft Learn provides a concrete walkthrough that illustrates the exact ledger math:
| Transaction Stage | Transaction Currency (EUR) | Accounting Currency Equivalent (USD) | Ledger & Settlement Impact |
|---|---|---|---|
| 1. Cash Advance Issued | 100 EUR | 140 USD | Employee receives 100 EUR advance. |
| 2. Expense Submitted | 100 EUR | 150 USD | Exchange rate shifts; 100 EUR now equals 150 USD. |
| 3. Automated Settlement | 0 EUR Remaining | 10 USD Variance | EUR advance clears to zero; 10 USD posts to configured FX Gain account; employee vendor balance nets to zero. |
In this scenario, the employee was advanced 100 EUR and spent 100 EUR. In the real world, the employee owes nothing and is owed nothing. Under the new logic, the system maps the expense to the cash advance in the transaction currency (EUR), clearing the EUR advance balance completely. Because the accounting currency value rose from 140 USD at issuance to 150 USD at settlement, the 10 USD difference is automatically recognized as a realized FX gain and posted to the organization's configured FX Gain account, ensuring the employee vendor balance nets cleanly to zero.
User Interface and Audit Trail Enhancements
Beyond the automated ledger math, Microsoft has updated the user interface and voucher structure to ensure auditors can follow every cent of variance:
- Requested Currency Visibility: Cash advance balances are displayed strictly in the currency originally requested on the cash advance.
- Visual Variance Indicators: On the expense line form, a visual indicator flags whenever the exchange rate differs between the cash advance and the mapped expense. If the exchange rates match, no indicator is shown.
- Explicit Voucher Splitting: The system generates separate voucher lines for the expense settlement itself and for the realized FX gain or loss. Both the cash advance number and the expense report number are stamped into the voucher descriptions.
- Direct Voucher Navigation: Finance reviewers can trace the full lifecycle using built-in navigation links—Related vouchers opens the expense voucher, All related vouchers displays every voucher tied to the expense, and Original document drills directly into the expense line details.
Section Summary: By matching advances in transaction currency and splitting the accounting currency difference into dedicated FX gain or loss voucher lines, the system guarantees zeroed-out employee balances and provides a complete, traceable audit trail.
Rollout Timeline and Important Deployment Boundaries
When planning for this update, IT administrators and Dynamics 365 functional consultants need to distinguish carefully between Microsoft's overarching roadmap milestones and the specific version prerequisites documented for integrated ERP environments.
On the Microsoft 365 Roadmap (ID 576744) and in the Dynamics 365 2026 Release Wave 1 plan, Microsoft lists this capability for Dynamics 365 Project Operations on the web across Worldwide (Standard Multi-Tenant) cloud instances. The release plan schedules public preview for July 2026 (specifically noted as July 27, 2026 in the wave plan and July 31, 2026 in M365 Admin announcements ) and targets General Availability for March 2027. Both the roadmap and the release plan classify the feature as enabled for end users automatically. As always with Microsoft roadmap listings, March 2027 represents a planned delivery window rather than a binding guarantee.
However, Microsoft Learn's technical documentation outlines a specific preview path for Project Operations Integrated with ERP, noting that the Cash Advance Exchange Rate Adjustments (Preview) capability is available starting with Dynamics 365 Finance version 10.0.49. Rather than waiting for automatic activation, administrators running integrated ERP deployments on version 10.0.49 or later can enable the preview manually—provided their environment meets strict data-hygiene prerequisites.
Prerequisites and Setup for the Integrated ERP Preview
Before an administrator can flip the switch in Feature Management for an integrated ERP environment, Microsoft Learn states that two mandatory conditions must be satisfied:
- Mapping cash advances to expense lines must be enabled: In the Feature Management workspace, organizations need the modern reconciliation workflow active (which typically pairs Expense reports reimagined with Ability to map cash advances to expense lines).
- No partially mapped cash advances can exist in the system: Any in-flight cash advances that are only partially mapped to expense lines must be fully settled or resolved before turning on the new rate adjustment logic.
Once those two prerequisites are verified in a Dynamics 365 Finance 10.0.49+ environment, administrators can activate the preview by following these steps:
- Open the Feature management workspace.
- Search for (Preview) Manage cash advance rate adjustments.
- Select Enable.
Operational Caveat: Returning Unused Cash
Even with exchange-rate-aware settlement active, finance teams should remind traveling employees of a standing rule in Dynamics 365 Project Operations cash advance workflows. If an employee's cash advance exceeds their actual expenses and they must return the unspent balance using the Return cash expense category, Microsoft Learn emphasizes that the cash return must still be recorded in the originally requested cash advance currency and at the exact same exchange rate. Furthermore, cash advances remain applicable only when the payment method assigns the expense owner as an employee.
Section Summary: While the broad roadmap targets automatic general availability in March 2027, administrators running Project Operations Integrated with ERP on Dynamics 365 Finance 10.0.49 can enable the preview via Feature Management after enabling line-level cash advance mapping and clearing out any partially mapped advances.