Small and medium business | Business Central, N...

Change Spot Rate on Payment

(6) Share

Report

Posted on by Carol M

We use Multi Currency for about 6 Vendors, In GP I can change the exchange rate on the spot. Now we are in BC and As the Bank will give us different rates for payments on the same day. How can I change the rate on a payment by payment.

Thank you

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

AndrewThomas81 518 on at

Like (0)

Report
Copy link

Link copied!

Sure, when you enter the payment journal you will select currency, and the currency amount (amount) which will calculate the amount (LCY) based on the exchange rate effective for the posting date.

Just overtype the amount (LCY) based on the amount indicated by the bank.

Kind Regards

Andrew Thomas
https://www.usebusinesscentral.com/
https://www.youtube.com/@usebusinesscentral

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,319 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can change it in two places: click the elipsis (3 dots) by the currency code field and in the page that opens you can change the exchange rate in there, or overwrite the amount (lcy) field as mentioned

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Rajvi Shah 152 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You can change the exchange rate for particular payment at the time of payment in the journal by clicking on the three dots in the currency code field.

By changing the value in exchange rate you can change the difference in Amount [LCY] and Amount [FCY].

Thanks,

Rajvi Shah

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,898 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Carol M,

There are two ways you can do this.

1 - On the any Journal beside the Currency code field, you will find 3 dots (AssistEdit Button), click on it, it will open the window to allow you to modify the exchange rate on the transaction level.

2 - Enter the Amount and then Amount (LCY) manually. This will auto calculate the rate and update on line.

Note: Exchange rate factor i.e. 1/Exch.Rate, can go upto max 14 decimal, at the end it will round off. So be careful to check preview posting so to avoid posting any incorrect entries due to rounding.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards,

Dhiren.

LinkedIn - https://www.linkedin.com/in/ca-dhiren-nagar-5079081b2/

Blog - https://dhirennagar.blogspot.com/

Was this reply helpful? Yes No
Carol M 79 on at

Like (0)

Report
Copy link

Link copied!

Thank you All for your answers very helpful :)

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,324 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

Dynamics 365 Business Central: Change the exchange rate on each journal line/document

https://yzhums.com/58019/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 13,323 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Yes in BC you can handle this payment by payment by changing the Currency Factor on the Payment Journal line, so you don’t need to change the day’s exchange rate for everyone. Enter the vendor, currency, and amount on the journal line, then overwrite the Currency Factor with the bank’s actual rate for that specific payment; BC will use that rate for that one transaction and post any difference to realized gain/loss. If the field won’t let you change it, check the currency setup because Fix Exchange Rate Amount can stop manual changes on documents and journal lines.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No