Core BC / Currency Shopify / integration order in foreign currency → BC Sales Header (Currency Code, Currency Exchange Rates) Ramp KB (BC sync error: There is no Currency Exchange Rate within the filter. Filters: Currency Code: {currency}); azurecurve (same error on sales invoice entry); Microsoft Learn: Synchronize and fulfill sales orders (shop currency must have exchange rates); BCApps issue #13518

Order or Invoice Fails: There Is No Currency Exchange Rate Within the Filter

Raw System Error String
There is no Currency Exchange Rate within the filter. Filters: Currency Code: EUR

What 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

  1. Note the currency code in the filter text of the message (for example 'Currency Code: EUR') and the document date of the failed order.
  2. Search for 'Currencies', select that currency, and choose 'Exchange Rates'.
  3. Add a row with a Starting Date on or before the document date, and fill in 'Exchange Rate Amount' and 'Relational Exch. Rate Amount'.
  4. If a row exists but has a 'Relational Currency Code' you did not intend, clear that field (the cause azurecurve found).
  5. Create or post the document again (for Shopify: 'Create Sales Document' on the Shopify Order card).
  6. 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.
  7. 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

How to verify: The document is created or posts. Its 'Currency Code' is the foreign currency, and the 'Currency Factor' on the header is not blank.

Sources & References

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.

We respect your privacy. No spam. You will only be contacted when pilot slots open for your stack.