web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Adding currency fields...
Small and medium business | Business Central, N...
Suggested Answer

Adding currency fields to Detail Trial Balance RDLC report

(1) ShareShare
ReportReport
Posted on by Hagru 368
Hello!
 
I want to add three fields to the default RDLC report Detail Trial Balance.
The fields I want to add are the following: 
- Currency Code
- Currency Exchange Rate
- Currency Sum
 
I want these per line in the Detail Trial Balance.
 
I guess I would like to add them through AL.
 
How do I go about adding fields to the RDLC report and make the correct calculations on the values?
Categories:
Dynamics 365 Business Central
  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at
    The currency information is not stored on the G/L entries except from if you used additional reporting currency.
    Currency information is typically stored for customer ledger entries, vendor ledger entries and bank transactions where you have a bank account that is not in your local currency.
    If you simply post a transaction using two or more G/L account no currency information is saved in the system,
    So it will be a lot of work to achieve what you try to do,
    I will recommend you find another way to report what you need to report.
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,698 Moderator on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans