Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Unanswered

Business central not showing data by quarter

Posted on by 19
How  to show quarterly data in Business Central?
 
For example, when I enter Q1 or Q2 in formula , it still does produce any values for that time period.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 1,487 on at
    Business central not showing data by quarter
    Hi, in this video they show the step by step process. hope it will help you: https://www.youtube.com/watch?v=hFSrDHFrBU8
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,480 Super User 2024 Season 2 on at
    Business central not showing data by quarter
    It looks like you didn't create a fiscal year (Accounting Periods)? The FY keyword has no effect if the current year has not been created.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 21,699 Super User 2024 Season 2 on at
    Business central not showing data by quarter
    I'm using the Comparison Period Formula field, you're trying to enter in the Comparison Date Formula field. If you don't see the Comparison Period Formula field, personalize and add it to the page.  
     
  • NZ-06081612-0 Profile Picture
    NZ-06081612-0 19 on at
    Business central not showing data by quarter
    @valentin,
     
    thank you tried that but it gives the following error:
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 21,699 Super User 2024 Season 2 on at
    Business central not showing data by quarter
    Try the following in your column definition, in the Comparison Period Formula field. When you run the financial statement, in the date filter enter the year you want to run it for i.e. enter january 1 2023..december 31 2023 to run it for 2023
     
     
  • NZ-06081612-0 Profile Picture
    NZ-06081612-0 19 on at
    Business central not showing data by quarter
    @valentin,
     
    in here:
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 21,699 Super User 2024 Season 2 on at
    Business central not showing data by quarter
    Please clarify where you're using this formula.
  • NZ-06081612-0 Profile Picture
    NZ-06081612-0 19 on at
    Business central not showing data by quarter
    @valentin yes and the fiscal years are already set up.  any suggestions? 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 21,699 Super User 2024 Season 2 on at
    Business central not showing data by quarter
    Can you provide more information, are you running a report and using Q1 in the date formula field? If so which report? Or is it somewhere else. Also, do you have accounting periods set up?
     

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans