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

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

(2) Share

Report

Posted on by AndreaNardiello

127

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 (3)

Answers (0)

AndreaNardiello 127 on at

Like (1)

Report

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

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

Like (1)

Report

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

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 127 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No