Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Financial Reporting

Posted on by 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

  • 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.

  • 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
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 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
    YUN ZHU Profile Picture
    YUN ZHU 73,333 Super User 2024 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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans