web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Financial Reporting
Small and medium business | Business Central, N...
Suggested Answer

Financial Reporting

(0) ShareShare
ReportReport
Posted on by Dustin Anderson 15

Hello Everyone,

In Financial Reporting there's a way to set up columns as CM, CM - 1, CM - 2, and so on if we wish to see the data of the previous month and so based on the Date filter.

 Can we add a date filter as well in this Column Header so that instead of showing CM, CM - 1 System also displays the actual date of the data its displaying?

Any suggestion or advice is welcomed. 

Version - Business Central On Cloud

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,305 Super User 2025 Season 2 on at
    RE: Financial Reporting

    Hi, as far as I know it doesn't work, maybe customization can do it, sorry I haven't tried it.

    More details: https://yzhums.com/1846/

    Hopefully other experts can give you better advice.

    Thanks.

    ZHU

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,748 Super User 2025 Season 2 on at
    RE: Financial Reporting

    Usually this type of report is created so that Column names You set up as January, february etc.. and for the date filter You select whole year.

    Otherwise to have dynamic column names is not possible - only solution would be to set Period as columns

  • Suggested answer
    Dustin Anderson Profile Picture
    Dustin Anderson 15 on at
    RE: Financial Reporting

    Thank you Zhu - I know this is not possible in BC, NAV it was customizable but BC is quiet tough to modify base Financial Report to play with these captions.

  • Suggested answer
    Dustin Anderson Profile Picture
    Dustin Anderson 15 on at
    RE: Financial Reporting

    Thank you, I know this is not possible, was just checking if anyone has achieved this in BC.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans