web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics GP (Archived) / Management Reporter GP...
Microsoft Dynamics GP (Archived)

Management Reporter GP - Create nn income statement by departments

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have created individual income statements for each department in my organization. These individual statements have modified the row definitions of our main I/S to included only the desired departments (we have a three digit serial in our account structure for departments).

The column definitions of our reports allow us for period analysis, so that we can compare the base month to others. 

I am interested in creating a report that has each of the departments as a column for the desired period only. Is there any way I can do that?

Thank you all for your help.

Thank you!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Annette_Brown Profile Picture
    Annette_Brown on at

    Yes!  

    But you will probably need to use a row definition that does NOT include the department dimension, or at least has all the departments if you need the departments to be on different lines. (You need to be able to pull all the departments with a single row definition)  

    Then, in the column definition you have a dimension filter on each FD column type.  You can filter each FD column to only pull a specified department or grouping of departments. 

    So lets say you have 4 departments you want to see side by side.

    You would create 4 FD columns that had exactly the same Fiscal year, Period and Periods covered, then use the dimension filter to identify which departments to group in each column. 

    column-example.png

  • Ovi1Ken0vi Profile Picture
    Ovi1Ken0vi 15 on at

    Annette,

    I am the OP and somehow i wasn't able to access the account with which i posted the question. I think it had something to do with changing jobs and the original account being linked to an account that was disabled after the transition.

    Anyways, i wanted to say that your answer was spot on and thank you very much or your help!

    Best!

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans