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

Standard Income Statement – Year-wise column definition not working when changing year dynamically

(5) Share

Report

Posted on by CU27011410-0

Hi Team,

I have created a new Column Definition in the standard Income Statement (Financial Report) to display data year-wise. When I set the Date Filter as 01/01/26..12/31/26, the report generates correctly and shows data from 2016 to 2026 as per the column definition, with each year column displaying correct values.

However, when I try to change the year dynamically, for example 01/01/18..12/31/24 or 01/01/20..12/31/22, the report does not adjust the columns year-wise. It always considers the current year (2026) and calculates all columns based on that year only.

My expectation is that if I run the report for 2018–2024, the columns should dynamically display 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024, with each column containing data only for its respective year.

Is this a standard limitation of Financial Reports in Business Central, where year-wise columns cannot be generated dynamically based on the selected date range?

Please confirm if this is expected behavior or if there is any standard way to achieve this.

Thanks.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,794 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi,

In Microsoft Dynamics 365 Business Central, Financial Reports are driven by static Column Definitions, not by runtime date logic. you need to
Create separate Column Definitions such as:

IS_LAST_3_YEARS

IS_LAST_5_YEARS

IS_2018_2024

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,208 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

There's a new feature that makes the column headers dynamic. What version of BC are you using? More info here - Use enhanced Financial Reporting | Microsoft Learn

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
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, In addition, this is how the standard is done.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,965 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Yes, this is expected standard behavior in Business Central Financial Reports. Column Definitions using Comparison Date Formula (-1Y, -2Y, CY, etc.) are always calculated relative to the “current year” derived from the Date Filter end date, not dynamically rebuilt based on the selected range. In your case, the column layout is effectively anchored to 2026, so even if you run the report for 2018–2024, BC still evaluates columns as offsets from the current year logic, not as “one column per year in the filter.” Financial Reports simply do not support dynamic generation of year columns based on a variable date range. To achieve truly dynamic year-wise columns, you’d need either multiple fixed column definitions, Analysis Views, or Power BI; there is no standard Financial Report setup that does this automatically.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,898 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Your report setup is correct.

However when you run the report in the date filter you only need to apply filter of one year only. Your year can be any 2026, or 2024. Make sure that filter that you apply is of the last year you want to see. For e.g. if you want to see 2018 - 2024, in date filter write 01/01/24..12/31/24.

Also the number of columns and the heading of columns are not dynamic. It is fixed by what you setup in column definition in Column header field.

Microsoft is in the process of releasing a feature which will give dynamic Column header based on date/period. This will also not make number of columns dynamic, just the headers. Here is the feature details - https://learn.microsoft.com/en-gb/dynamics365/release-plan/2025wave2/smb/dynamics365-business-central/use-enhanced-financial-reporting

Regards,

Dhiren.

Was this reply helpful? Yes No