Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management reporter de...
Finance | Project Operations, Human Resources, ...
Answered

Management reporter department wise report for a range of period

(0) ShareShare
ReportReport
Posted on by JasdeepSingh 192

Hi everyone,

I am configuring a financial report in D365 F&O wherein I want data of 2 Departments column wise and data has to be of a range of period.

I have 2 questions:

1. In my column definition Under Admin column I have put dimension filter like below:

pastedimage1611309262103v1.pngpastedimage1611309703473v5.pngpastedimage1611309337569v3.png

My question is from where these Departments are coming in Totaling account(where do we specify these departments are totaling and why only 2 departments not all are coming)

How it will be different than if I put department through Individual or range option?

2. How to run a report for a range of dates since D365 only asks for a report date while running. Example- If I want to run the report for 4 months or for 7 months. And in that case, How will be my column definition configured.

  • JasdeepSingh Profile Picture
    JasdeepSingh 192 on at
    RE: Management reporter department wise report for a range of period

    Hi Ludwig,

    Thanks for your responses, I have verified both answers of my questions.

    Thanks a lot!!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management reporter department wise report for a range of period

    Hi Jasdeep,

    The 'dynamic' comes into the report if you refer to a base period / year.

    The first screenprint shows this where you can find a reference to the "base" year in the year line.

    If you run the report then you select the base period and base year when you run the report and this selection ensures that you see "dynamic" data for the periods selected.

    here is another screenprint that illustrates the base year / period fields that you select when generating a report.

    www.bing.com/.../search

    Best regards,

    Ludwig

  • JasdeepSingh Profile Picture
    JasdeepSingh 192 on at
    RE: Management reporter department wise report for a range of period

    Hi Ludwig,

    Thanks, This is a static solution. The examples are of year end report but my question is if it is possible to specify the date range dynamically while running the report . Since I see the single report run date from D365 application I can enter only single date.

    And what is the significance of DD if format of date entered is (MM/DD/YYYY) since in column definition MM is Period and YYYY is Fiscal year.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management reporter department wise report for a range of period

    Hi,

    Here is an example how such a setup for different periods can be made

    www.bing.com/.../search

    Another example that covers multiple periods is illustrated here:

    www.bing.com/.../search

    Best regards,

    Ludwig

  • JasdeepSingh Profile Picture
    JasdeepSingh 192 on at
    RE: Management reporter department wise report for a range of period

    Hi Ludwig,

    Yes ofcourse totalling accounts are put in row definition, I was just curios to know why only 2 departments are visible in totalling accounts. Anyways, I have put department filter using dimension filter in column definition.

    What about my second question? How can we run the report for a range of period through D365 F&O, in that case how my column definition will be comfigured?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management reporter department wise report for a range of period

    Hi,

    Why do you need the totaling account in the column definition setup?

    I would expect that all accounts including total accounts are setup in the row definition and that the departments are specified as filters in the column definition.

    Best regards,

    Ludwig

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,349 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,029 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans