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

v27 Financial Reports - Drill-down on calculated amounts not filtering on the G/L Accounts Totaling

(6) Share

Report

Posted on by AndreaNardiello

150

Hi everyone,

is anyone else encountering the issue in the Financial Reports when, clicking on the drill-down in the rows, the system is not filtering anymore based on the Totaling?

In this instance, the system shows the whole Charts of Accounts even if the amount is correctly based only on the G/L Accounts defined in the row definition.

Drill-down on the "Balance" shows the following:

I thought it was a 27.0 issue, but the problem still exists also in the 27.1.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

AndreaNardiello 150 on at

Like (4)

Report
Copy link

Link copied!

Further investigation...

I tried in the Cronus and it seems that the issue exists when the Financial Report has a Row Analysis View Name configured.

There's an example in the Cronus company named REVENUES:

No matter if the analysis view has the following filters:

when drilling down all the G/L Accounts are shown.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/bi-troubleshoot-financial-reports

1 people found this reply helpful.

Was this reply helpful? Yes No
AndreaNardiello 150 on at

Like (3)

Report
Copy link

Link copied!

This is not helping unfortunately.

The thing is that when you have an Analysis view configured on a Financial Report, the drill-down action is not passing the Totaling filters to the Chart of Accounts (Analysis View) page. I don't know honestly if this is a v27 issue or it's always been like that.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,808 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

It’s a bug in BC 27.0/27.1, drill-down ignores the row’s Totaling and shows the entire COA.

Your setup is fine; Microsoft must fix it.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
AR-26010908-0 16 on at

Like (0)

Report
Copy link

Link copied!

Any idea when Microsoft will fix it?

Was this reply helpful? Yes No