Announcements
Hi:
What formula would I use in the Column Layout Setup of an Account Schedule to display "2022" as that column's header, instead of having to hard-code "2022" manually.
And, where would that formula reside in the Column Layout Setup?
Thanks!
John
I believe you cannot use formula in column header. Hence, you need to define a general term that does not need change such as Current Year or Previous Year
Hi, It is not recommended to add years there, because you can filter different years in your filter conditions, so you only need to add months, such as jan, feb, mar...
Using Period Formulas:
https://docs.microsoft.com/en-us/dynamics365/business-central/bi-how-work-account-schedule#comparing-accounting-periods-using-period-formulas
https://dynamicsnavfinancials.com/account-schedule-formulas/
https://www.youtube.com/watch?v=FvF4AGt9K84
Hope this will help.
Thanks.
ZHU
We're working on a projected pro forma statement. The five column headers and elements of time are 2022, 2023, 2024, 2025, and 2026, respectively.
Does that make a difference?
Hi
What you want to do make sense. But it is no standard way to do that dynamically. For sure you can have that then go back and change to 2023, 2024, etc
The other way is that you have it Current year, 1 year, 2 year, etc. This way no change in header required.
In Column Layout Setup, if you simply enter "CURRENT YEAR", etc. as the column description, does it display the year when the report is printed or does it display "CURRENT YEAR"?
It will be "Current Year" it will not print the year or anything else. Header does not support any formula.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 580 Super User 2026 Season 1
YUN ZHU 462 Super User 2026 Season 1
Grigorios Mavrogeorgis 272 Super User 2026 Season 1
