Multisource Exchange Rate Management · Dynamics 365 Finance & SCM
Daily exchange rates that import themselves, and stop for a human when something looks wrong.
F&O Multisource Exchange Rate connects Dynamics 365 Finance & Operations to public exchange rate APIs, starting with the Bank of Canada. Each run checks rates against the last ones stored, holds unusual movements for approval and leaves a full audit trail.
- Bank of Canada ready
- Any JSON or XML rate API
- Tolerance and approval
- Built on standard F&O import
| Pair | Previous | Source | Move | Decision |
|---|---|---|---|---|
| USD/CAD | 1.3712 | 1.3698 | −0.10% | Imported |
| EUR/CAD | 1.4921 | 1.4921 | 0.00% | Unchanged |
| GBP/CAD | 1.7410 | 1.8102 | +3.97% | Held |
| CAD/USD | 0.7293 | 0.7300 | +0.10% | Inverse |
| MXN/CAD | 0.0741 | — | — | Missing |
Illustration shows example data.
From public feed to posted rate, with checks in between
- 1
Fetch
Calls the provider over HTTPS for the date range, with timeouts and automatic retries.
- 2
Map
Reads the JSON or XML response into currency pairs and dates using the profile's mapping.
- 3
Validate
Checks freshness, conflicts, existing rates and the movement against the previous rate.
- 4
Import
Passes accepted rates to the standard Import currency exchange rates process.
- 5
Reconcile
Confirms what was actually stored, sets the final run status and emails the result.
Built for treasury and finance teams who can't afford a bad rate
- Providers
Bank of Canada in one click
Create a ready-made profile for the Bank of Canada Valet daily rates. It starts disabled with inactive pairs, so you choose exactly which currencies to bring in.
- Providers
Any public rate API
Configure other JSON or XML feeds without code: URL templates with date and currency tokens, record and field paths, date formats, and encrypted API keys sent as a header or query parameter.
- Rates
Direct, inverse and cross rates
Import the quoted pair as published, store its inverse, or derive a cross rate through a base currency. Rate units (for example per 100) and decimals are handled per profile.
- Controls
Movement tolerance and approval
Rates that move more than your tolerance are held. Reviewers approve them, override the final rate with a note, or dismiss them so they're never stored.
- Controls
Stale, missing and conflicting data
Publications older than your limit are refused, expected pairs that don't arrive are flagged, conflicting quotes are rejected, and existing rates are only replaced when you allow it.
- Safety
Preview and test connection
See what a profile would propose for a date range, or check the latest publication and response mapping, without storing a single rate.
- Audit
Complete run history
Each import, preview and test is logged with its counts, HTTP status, redacted request URL, payload hash, every pair's decision and who resolved held rates.
- Alerts
Reconciliation and email alerts
A follow-up step confirms which rates F&O stored, sets the final status, and emails a summary of imported, unchanged, held, rejected and missing rates.
- Platform
Native to Finance & Operations
Providers appear in the standard Import currency exchange rates process and its batch scheduling. Profiles can be moved between environments with data entities.
Two roles, so the person who sets it up isn't the one who approves exceptions
Exchange rate API administrator
Sets up API profiles and currency pairs, runs connection tests and previews, and schedules imports and reconciliation.
Exchange rate API reviewer
Reviews run history and approves, overrides or dismisses rates held by the tolerance check.
Multisource Exchange Rate Management at a glance
- Platform
- Dynamics 365 Finance & Supply Chain Management
- Status
- Available
- Supported versions
- Dynamics 365 Finance & Operations. Supplied as a deployable package for your version.
- Deployment
- Deployable package applied through Lifecycle Services or the Power Platform admin center, sandbox first.
- Documentation
- Setup guide and reference
- Licensing
- Contact us for licensing and pricing
- Microsoft Marketplace
- Contact us for access
The illustration on this page uses example data. Request a demo to see the product with scenarios like yours.
Still keying in exchange rates every morning?
Let's set up an automated, reviewed rate feed for your currencies.