Dynamics Community Forum Thread Details

Showing balance in the financial report of previous two consecutive year

Hi Members,

I would like to know how to display the data for a consecutive two years in the financial report. Consider that I am trying to print a Balance sheet / Income statement for this financial year. While printing this report, I need the data to be printed for the previous year too. (E.g, If am trying to print the report for the year 2023, the data must get printed for the previous year too and if I am trying to print the report for the financial year 2022, the report must have the date for the previous year i.e 2021 automatically.)

When I am trying to print for any of the fincianial year as mentioned above, the remaining columns must not contain any values. But now when I am trying to print the report, I am getting values in all three years.

I had attached the screenshot below this for your better understanding. Here I had given the period ending date as 31-Dec-2022 for which I need the values for the year 2022 and its previous year. But here, I am getting the values for the current year (2023) too, which is not required as per my requirement.