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 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

I have the same question (0)
  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    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

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    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
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

    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.

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 NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans