Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Adding currency fields...
Small and medium business | Business Central, N...
Unanswered

Adding currency fields to Detail Trial Balance RDLC report

(1) ShareShare
ReportReport
Posted on by Hagru 219
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:
Business Central
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,051 Super User 2024 Season 1 on at
    Adding currency fields to Detail Trial Balance RDLC report
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    Adding currency fields to Detail Trial Balance RDLC report
    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.

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans