You’re offline. This is a read only version of the page.
I would like to create a Balance Sheet and Income Statement showing 12 columns (one for each month). I'm having trouble configuring the columns. I have 12 columns on my report now, but they're all repeating the same numbers. How do I get the first column to show January, and the next February, etc. Also, how do I get the column headers to automatically show the last day of the month? I don't want to have to update the column headers every year? All of this was super easy in QBooks, but near impossible in Business Central. I can't believe it's really that difficult. Please help?
Hi, you should set this in Comparison Period Formula field, not Comparison Date Formula.
It is hidden in standard BC.
PS: This is also mentioned in the link I shared.
Hope this helps.
Thanks.
ZHU
Thanks for trying ZHU - but the FY[1], FY[2] . . . doesn't work - it throws an error. I saw and read the same page you posted with all the formulas and that must be old because it's not working.
Hi, please usng FY[*] in Comparison Period Formula.
Here is an example, https://www.youtube.com/watch?v=FvF4AGt9K84
Hope this helps.
Thanks.
ZHU
I found a similar post here
#1
André Arnaud de Cal...
291,965
Super User 2025 Season 1
#2
Martin Dráb
230,817
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
