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

Adjust Exchange Rate with custom accounts

(5) Share

Report

Posted on by TB-28100618-0

127

Is there a way to use custom accounts when adjusting exchange rates instead of the system’s default Realized/Unrealized Gains and Losses accounts?

I have added a list of custom accounts on the Currency Card, as shown below. My intention is to have the Adjust Exchange Rates process post entries to these custom accounts.

However, the issue is that the adjustment entries are summarized into the last custom account ledger entry, rather than being posted separately for each individual custom account.

I would like the exchange rate adjustment to create ledger entries per account, not as a summarized posting.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Pallavi Phade 4,392 on at

Like (0)

Report
Copy link

Link copied!

Namaste @TB-28100618-0

Since its standard behaviour , we need to be very cautious while developing customization wrt Financial module . I would recommend two options since I have not implemented this .

Option A

Let system post the entries. You create custom script to reverse the entries and post into Custom Accounts . This will not interrupt standard flow .

Option B

Check below event in codeunit if you can customize and replace account while creating those entries.

Please check in sandbox . test for all scenarios .

Warm Regards

Pallavi Phade

www.linkedin.com/in/pallaviphade131116

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,689 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

No Its not, system will always entertain Realized/Unrealized Gains and Losses accounts.

I wont even recommend to alter the posting groups or the accounting stuffs, I will suggest to handle the same however best possible way.

Problem is not altering the posting accounts , issue will be you need to invest a lot more time to understand the entire impact and any loose ends will be a nightmare on these areas.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 6,747 on at

Like (1)

Report
Copy link

Link copied!

Hello ,

this is not supported out of the box. Currency Posting Setup only controls which G/L accounts are used for realized/unrealized gains and losses; the Adjust Exchange Rates process always summarizes postings (per currency/posting group) by design. Adding multiple custom accounts will not force separate ledger entries—BC will still collapse them into a single posting. There is no standard setting to change this behavior. If you truly need per-account entries, it requires AL customization of the Adjust Exchange Rates posting logic, which is complex and risky. Best practice is to keep summarized postings and analyze details using dimensions or account structure instead.

Regards,

Oussama

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,930 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

What if you modify the default Realized/Unrealized Gains and Losses accounts before posting, and then modify them back after posting?
This should be a relatively simple solution.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No