Order or Invoice Fails: There Is No Currency Exchange Rate Within the Filter
There is no Currency Exchange Rate within the filter. Filters: Currency Code: EURWhat It Means
Business Central cannot convert a foreign-currency document into local currency (LCY) because it finds no usable exchange rate for that currency. Creating the sales document (or posting it) stops. Integrations that push documents into BC report this as a sync error.
Root Cause
Every foreign currency on a document needs a row on the 'Currency Exchange Rates' page with a Starting Date on or before the document date. The error appears when no such row exists: the currency was just enabled, rates were never loaded, the rate service stopped, or the only rate starts after the order date. azurecurve reports a second cause: a stray 'Relational Currency Code' on the exchange rate row makes BC look for a rate that does not exist. For Shopify, Microsoft Learn says the shop's Currency Code 'must have exchange rates configured'; with Currency Handling = 'Presentment Currency' each order uses the customer's checkout currency, so every currency you sell in through Shopify Markets needs rates. Related trap (BCApps issue #13518, open): if the presentment currency does not exist in BC at all, the connector logs a warning and creates the document in local currency with the foreign amounts, so there is no error and the amounts are wrong.
Step-by-Step Fix
- Note the currency code in the filter text of the message (for example 'Currency Code: EUR') and the document date of the failed order.
- Search for 'Currencies', select that currency, and choose 'Exchange Rates'.
- Add a row with a Starting Date on or before the document date, and fill in 'Exchange Rate Amount' and 'Relational Exch. Rate Amount'.
- If a row exists but has a 'Relational Currency Code' you did not intend, clear that field (the cause azurecurve found).
- Create or post the document again (for Shopify: 'Create Sales Document' on the Shopify Order card).
- Permanent fix: set up a service on the 'Currency Exchange Rate Services' page, turn on 'Enabled', and run 'Update Exchange Rates' on a schedule so rates load before orders arrive.
- For Shopify with Currency Handling = Presentment Currency: make sure every Shopify Markets currency exists in BC with rates. Check old Shopify-created documents for foreign orders that came in with a blank Currency Code (issue #13518).
Verification Steps
Sources & References
- https://support.ramp.com/microsoft-dynamic-business-central-sync-error-there-is-no-currency-exchange-rate-within-the-filter-filters-currency-code-currency
- https://azurecurve.co.uk/2025/01/error-entering-sales-invoice-in-microsoft-dynamics-365-business-central-there-is-no-currency-exchange-rate-within-the-filter
- https://learn.microsoft.com/en-us/dynamics365/business-central/finance-how-update-currencies
- https://learn.microsoft.com/en-us/dynamics365/business-central/shopify/synchronize-orders
- https://github.com/microsoft/BCApps/issues/13518
- https://github.com/microsoft/BCApps/blob/e48e2d94b13dc61a88b9a1811732ca4fbc36e6c2/src/Apps/W1/Shopify/App/src/Order%20handling/Codeunits/ShpfyProcessOrder.Codeunit.al#L130-L134
Early Access · 30-Day Sandbox Pilot
Stop Order Sync Failures Before Customers Notice
The Order Flow Doctor monitors Microsoft Dynamics 365 Business Central order flows across Shopify, EDI (TrueCommerce, SPS), 3PLs, and carriers. Get automated root-cause diagnosis and one-click fixes.