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 NAV (Archived) / Account Schedule - Inc...
Microsoft Dynamics NAV (Archived)

Account Schedule - Income Statement by Department

(0) ShareShare
ReportReport
Posted on by Scott_NAVUser 70

I currently have an account schedule for a consolidated income statement. I'd now like to create a more detailed income statement by department so I see the income statement by line of business. My NAV departments are 05XXXXXX, 10XXXXXX, and 20xxxxxx. How do I create these separate columns to pull the income statements for each of the departments?

Desired Layout of Account Schedule:

Column A: These are my income statement rows (Revenue, COGS, SG&A, etc).

Column B: I want this to be the income statement activity for all departments that start with 05

Column C: I want this to be the income statement activity for all departments that start with 10

Column D: I want this to be the income statement activity for all departments that start with 20

Column E: I want this column to total columns B:D.

*This post is locked for comments

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Account Schedule - Income Statement by Department

    If you use dimensions, you can use global dimensions totaling and next two dimensions totaling in Column Layout setup. If you want to use other dimensions, you need to link Analysis View Name (with different dimensions) to colimn layout.

    If you use business units in consolidation, you can use BU totaling at the same place.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Account Schedule - Income Statement by Department

    Hi,

    oh, I didn't notice the "consolidated" on the first read... This would be case D. Department equals Business Unit, right? Well then you have a field called "Business Unit Totaling" in the column layout which is the right one for the department totalings and the formula.

    with best regards

    Jens

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Account Schedule - Income Statement by Department

    Hi,

    this is possible, but how depends a little on how your department code is retained in the G/L entries.

    A. Global dimension 1 or 2 - easiest. You can build the account schedule on the g/l entries.

    B. Some other dimension: You need to define an analysis view for the department code first. The analysis view can contain up to 4 dimensions. It can be updated in real-time (at every post), but this will come with a performance hit for all posting transactions. You can build the account schedule on the analysis view.

    C. Extra field in the G/L entries (nothing is impossible ;): You need to customize the account schedule functionality accordingly before you can use it.

    Assuming that you have a good setup and your column layout line contains a field called "Department Totaling" (either being one of the dimension totaling fields, or an aditional one), you can place your totalings for the departments there. Column E is a formula and adds up columns B..C. This should be the same for all three variants.

    with best regards

    Jens

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February 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... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans