Additional Reporting Currency in Financial Reports

(1) Share

Report

Posted on by Tris15

400

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)

Suggested answer

Yi Yong 2,557 Super User 2025 Season 2 on at

Like (0)

Report

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,202 Super User 2025 Season 2 on at

Like (1)

Report

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 31,428 Super User 2025 Season 2 on at

Like (1)

Report

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 95,597 Super User 2025 Season 2 on at

Like (1)

Report

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