Skip to main content

Notifications

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

Why dont the date range work in the financial report? Is there an alternative way ?

Posted on by 175

Hi ALL, 

Why dont the date range work in the financial report? Is there an alternative way?

Regards, 

Manjunath Dhanapal

  • Suggested answer
    RE: Why dont the date range work in the financial report? Is there an alternative way ?

    Hi

    To get a date range put double dots (..) in between the dates you want to filter.

    pastedimage1681067306915v1.png

  • Suggested answer
    Shawnsauve Profile Picture
    Shawnsauve 1,089 on at
    RE: Why dont the date range work in the financial report? Is there an alternative way ?

    The date range may not be working in the financial report due to a few possible reasons. It could be that the report is not configured to accept date range parameters, or that the date format used in the report parameters is different from the date format used in the system.

    To troubleshoot the issue, you can try the following:

    1. Check the report design and parameters: Ensure that the report is configured to accept date range parameters, and that the date format used in the report parameters matches the date format used in the system.

    2. Check the data source: Verify that the data source for the report is pulling the correct data based on the selected date range.

    3. Check the report filter: Make sure that there are no filters applied to the report that would prevent data within the selected date range from appearing in the report.

    4. Check the system date format: Confirm that the date format used in the system matches the date format used in the report parameters.

    If you are unable to resolve the issue with the date range, you can consider using an alternative approach such as creating a custom query or report that pulls data based on a specific date range. Another option could be to export the data to Excel and use Excel's filtering and sorting capabilities to analyze the data based on a specific date range.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 72,941 Super User 2024 Season 2 on at
    RE: Why dont the date range work in the financial report? Is there an alternative way ?

    Hi, if you mean Date Filter, this should work, you can check the standard reports.

    pastedimage1680826796194v1.png

    pastedimage1680826808989v2.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Why dont the date range work in the financial report? Is there an alternative way ?

    hi

    can you send a screenshot?

    DAniele

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans