web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Income Statement Finan...
Small and medium business | Business Central, N...
Suggested Answer

Income Statement Financial Report, Business Central

(5) ShareShare
ReportReport
Posted on by CU20112316-1 265
Is there any way to manually override the default setting on the dates so that the report reads accurately and doesn't show variances in the check column?  When we run a report for a certain date range, that should be the only information that populates and that we are checking against. 
Categories:
Dynamics 365 Business Central
I have the same question (1)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,055 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.
    Dynamics 365 Business Central: Can we change default options/filters on the request page of Report???
     
    Thanks.
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 12,803 Super User 2026 Season 1 on at
    Hello,
     
    Financial reports in BC always follow your column layout, not just the date filter.
    To make the Income Statement respect only the date range you enter (and remove Check variances), you must edit the column layout so each column uses Net Change + Date Filter, with no extra date formulas or comparison columns.
    That’s the only way to “override” the behavior.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,732 Super User 2026 Season 1 on at
    Hello,
     
    To ensure reports only show data for the specified date range and avoid variances in the check column, you need to override default date formulas by applying explicit date filters on the report request page and aligning column definitions or account schedules with the same date range (e.g., 01/01/2025..31/01/2025).
     
    If variances persist, review and replace any default comparison formulas in the layout with fixed date filters or customize the report to ignore system defaults, so it strictly uses the user-defined date range for accurate reporting.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans