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

Hi, Readers.
Today I would like to briefly talk about how to change the exchange rate on each journal line.
If you trade in different currencies, you need to keep track of the changes in currency exchange rates. Business Central helps you manage and update the exchange rates manually or automatically and set up a currency exchange rate service.

More details: Dynamics 365 Business Central: Automate Currency Exchange Rate Updates (Currency Exchange Rate Services and Transformation Rules)

Generally, we maintain the valid exchange rate in Currencies and then automatically calculate it in the document or journal. For example, the Currency Code below is JPY:
Currency Exchange Rates – JPY: 0.5805 (Relational Exch. Rate Amount)

Sales Order:

General Journal:

Currency Factor = 100/Relational Exch. Rate Amount

PS: The Currency Factor field cannot be edited.

Did you know that this exchange rate can be changed during a transaction? For example, in Sales Order or General Journal.

It’s very simple. There is an AssistEdit button behind the Currency Code field.
PS: Dynamics 365 Business Central: TableRelation, Enum/Option, Lookup and AssistEdit – What’s the difference on the page (UI)

After clicking, the Change Exchange Rate page will be opened, and we can modify Relational Exch. Rate Amount.

For example,

The Currency Factor will also be recalculated.

PS: When Currency Code is empty, the exchange rate cannot be modified.

The new exchange rate will be used after posting.

Posted Sales Invoice:

Customer Ledger Entries:

The same is true for General Journal, Payment Journal, Cash Receipt Journal and other functions.

Great, this can be used for some special cases. Give it a try!!!😁

PS:
1. Dynamics 365 Business Central: How to disable Application of Ledger Entries in Different Currencies (Appln. between Currencies)

2. If you want to disable this feature, you can refer to the following method
Dynamics 365 Business Central: How to easily hide/disable the AssistEdit button – Customization

3. Important: Currencies in Business Central

Do not create the local currency code both in the General Ledger Setup and in the Currencies page. This will create confusion between the blank currency and the LCY code in the currency table, and bank accounts, customers or vendors might accidentally be created, some with the blank currency and some with the LCY code.

END

Hope this will help.

Thanks for reading.

ZHU