Microsoft Dynamics Business Central Sync Issue | Your accounting provider does not have {currency} as a currency. Please add the currency and try again.

Dynamics BC requires multi-currency to be enabled at the company and vendor level to post foreign-currency bills. If BC isn’t configured for that vendor’s currency, BC will usually reject or coerce values on import.

At this time, the Dynamics <> Ramp integration does not support paying a bill in foreign currency and then syncing it in USD.

Company-level setup

• Add the currency
  • BC uses ISO codes for foreign currencies.
  • Search “Currencies” and ensure your foreign currency exists. If not, create it and set:
    • Code: (e.g., EUR, GBP)
    • Description: Name of the currency
    • Decimal places: Typically 2
• Maintain exchange rates
  • Open “Currency Exchange Rates” for your foreign currency.
  • Add an exchange-rate line with a valid Starting Date and Relational Exch. Rate Amt / Exchange Rate Amt .
  • If posting across multiple dates, add rates covering those dates or enable your exchange-rate service.
• Configure FX posting accounts
  • Search “Adjust Exchange Rates” and ensure:
    • Realized and Unrealized Gains and Losses accounts are set in General Posting Setup or in the Currency card.
    • Schedule periodic “Adjust Exchange Rates” runs if you keep foreign-currency AP/Bank open.
• Bank accounts
  • If you will pay from a foreign-currency-denominated bank:
    • Go to Bank Accounts , choose the paying account, and set Currency Code = foreign currency .
  • If you will pay from a USD (or other) bank:
    • You can still post foreign-currency bills. BC will convert on payment date using your rates.
• Posting dates
  • Confirm General Ledger Setup and your User Setup allow posting dates for both the bill date and the payment date coming from Ramp.

Vendor-level setup

• Set the vendor’s currency
  • Open the vendor card for the bill’s supplier.
  • Set Currency Code = foreign currency . This drives the bill’s transaction currency.
• Check posting groups
  • Vendor Posting Group and General Business Posting Group should map correctly in General Posting Setup so purchases and payables post without errors.

What you should see after sync

• Bills created in Ramp in foreign currency will post in that currency on the vendor ledger in BC when the vendor has Currency Code = foreign currency and the currency is configured with current rates.
• Payments posted from a non-foreign currency bank will use your exchange rate on the payment date and recognize any realized FX differences to your configured accounts.
• Payments from a foreign currency bank account will keep the bank and payment in that currency.