Multi-Currency Payments with Business Central
Modified on Mon, 28 Sep at 2:18 PM
Overview
Business Central companies can invoice customers in foreign currencies. Benji Pays reads the invoice currency, the customer's currency code and your company's local currency (LCY) from Business Central, charges the customer through a gateway configured for that currency, and converts the amounts it posts using the exchange rates stored in Business Central. This article lists what you must set up and what to expect.
What you need in Business Central and Benji Pays
| Requirement | Where | Why Benji Pays needs it |
|---|---|---|
| An exchange rate for every foreign currency you invoice in | Business Central: Currencies > Exchange Rates | Benji Pays reads the rate in effect on the posting date and stops the payment if there is none |
| Rates stated against your local currency | Same screen: Relational Currency Code blank or equal to LCY | Benji Pays cannot convert a rate stated against a third currency |
| The Currency Code on each customer card set correctly (blank for LCY customers) | Business Central: Customer Card | Business Central copies it onto journal lines; Benji Pays reads it before posting |
| A payment gateway with a Payment Account and Refund Account mapped for each currency you collect | Benji Pays: Settings > Payment Gateway Settings | Clearing and refund accounts are looked up by gateway currency |
| A Cash Receipt Journal assigned to each gateway | Benji Pays: Settings > Business Central Settings | Payment lines are written to that journal |
Benji Pays clearing accounts created from the gateway settings are named per currency, for example BPCLR-USD, and only appear in the dropdown for that currency. Any other Business Central G/L account is listed for every currency, so pick carefully.
How amounts are converted
A payment can involve up to three currencies: the currency the customer was charged in (the gateway currency), the invoice (document) currency, and your local currency. Benji Pays converts between them using the Business Central rate for the posting date, then posts the journal line in the currency Business Central expects for that customer. The transaction detail records what happened, for example:
- "Posted payment to Business Central as CAD 130.00 (USD 100.00 at the Business Central exchange rate 1.3) for INV-1001."
- "Converted surcharge amount from USD 3.00 to CAD 3.90 at the Business Central exchange rate 1.3."
Surcharge lines post to a G/L account, which Business Central always keeps in your local currency, so a surcharge you see in the invoice currency in Benji Pays is posted in LCY in Business Central.
The amounts shown to your customer on Pay Now links, in the Customer Portal and on receipts are in the invoice currency. Only the accounting entry is converted.
Deposits in a foreign currency
A deposit taken in a gateway currency different from the customer's currency is converted at posting in the same way. The unapplied payment on the customer's ledger is in the customer's currency. Apply it in Business Central as usual.
Errors and how to fix them
Benji Pays never posts a guessed amount. If it cannot convert, the payment is not applied in Business Central and the transaction shows one of these messages:
| Message | Cause | Fix |
|---|---|---|
| Business Central has no USD exchange rate effective on 2026-08-27. Add the rate in Business Central under Currencies > Exchange Rates and retry. | No rate row with a starting date on or before the posting date | Add or back-date the rate in Business Central, then retry the payment |
| Business Central's USD exchange rate is stated against EUR instead of CAD. Update the rate in Business Central and retry. | The rate's Relational Currency Code is a third currency | Change the rate to be stated against your local currency, or add an LCY row |
| BC surcharge clearing account is not configured. Configure the refund/clearing account for this gateway currency in gateway settings. | The gateway has no Refund Account mapped for the currency | Map the Refund Account for that currency in Payment Gateway Settings |
When a rate is missing, the card or bank charge may already have succeeded. Check the transaction result: if the processor approved the charge but the accounting step failed, fix the rate in Business Central, then record the payment manually in Business Central or contact support to have Benji Pays re-apply it.
Voids and refunds
Reversals and refunds post the exact amount that was originally posted, so a void nets to zero in Business Central even if the rate has changed since. Refunds against a credit memo use the credit memo's currency.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article