Additional Reporting Currency in Financial Reports

(1) Share

Report

Posted on by Tris15

488

Hi All

Is there any standard way of adding an additional reporting currency to a financial report's column definition - I know I can view the amounts in the additional reporting CCY, but I want to view both the LCY and additional CCY on the financial report.

Regards,

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Yi Yong 2,736 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Tris,

You are right on using the 'Show Amounts in Add. Reporting Currency'. The standard does not have a function on the column definition to present the value in LCY or Add. CCY.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,220 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

unfortunately, the additional currency is not available out of box to be used as a column. Maybe you could resort to a customization.

Jun Wang

Was this reply helpful? Yes No
Suggested answer

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

Like
a
(1)

Report
Copy link

Link copied!

This is a situation when third party reporting services such as Jet Reports or Power BI would be good to use, as this is a limitation in Business Central Financial Reporting.

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
Verified answer

YUN ZHU 102,540 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Unfortunately, as far as I know this needs to be customized, or use external tools as Valentin mentioned, but it is possible that additional development of Odata or APIs will be required. but you can try it.

Thanks.
ZHU

Was this reply helpful? Yes No