web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Help Needed: Balance S...

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

Answered

Help Needed: Balance Sheet Report Filter Issue in Business Central

(8) Share

Report

Report

Posted on by Jeel P

49

Hi everyone,

Is there anyone who can help me configure the Balance Sheet financial report in Business Central?

Requirement:

I want to view my Balance Sheet for a specific period — e.g., 3 months or 5 months (like Jan to May). I’ve applied a date filter in the report options (e.g., 01/01/25..05/31/25), but the report still shows data for all other months (with the same values repeated across each column).

I’m using a customized row and column definition, but the filter doesn’t seem to affect the output as expected.

Has anyone faced this before, or can they guide me on how to fix this?

Feel free to connect with me on LinkedIn: https://www.linkedin.com/in/jeel-paun

Thanks in advance!

— Jeel Paun

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (3)

Sort by

Verified answer

Andrés Arias 5,157 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

You can check the following links to validate the column and filter settings for the months.

https://www.youtube.com/watch?v=X__ZWvMNrfg

https://learn.microsoft.com/en-us/dynamics365/business-central/bi-design-financial-reports#when-to-use-a-comparison-period-formula-and-comparison-date-formula-in-a-column-definition

https://cetastech.com/how-to-use-comparison-period-and-date-formulas-in-business-central-financial-reporting

If you have any questions, let me know.

Regards,

Andres

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 26,790 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

D365 Business Central: Account Schedule Filters and Dimensions

Dynamics 365 Business Central AS 101 Lesson 10: Comparison Period v. Comparison Date — Kerry Peters

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

YUN ZHU 100,974 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, You can refer to the following two standard reports

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Ewon Tan 83 on at

Like (1)

Report
Copy link

Link copied!

hi Expert,

I did try out but it seem still facing the same issue as Jeel's facing.

Example: date filtering select between July and august and click recalculate but the results of sept till november value still showing.

May I know when and how to select the date filter and view by.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,086 Super User 2026 Season 1

#2

YUN ZHU 1,290 Super User 2026 Season 1

#3

AndrewThomas81 1,218

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans