Dynamics Community Forum Thread Details

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

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.