Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

closing income statement for multiple dimensions

(0) ShareShare
ReportReport
Posted on by

I have multiple dimensions representing an entities or divisions in NAV for profit and loss and balance sheets.

I need to close the fiscal year and transfer the P & L items to retained earnings for each entity.

How do I proceed with this?  When I tried to do it - i see that  the P&L amounts will be posting to one Retained earnings account for all entities. I want to have each entity's P&L amounts post to its own retained earnings account.

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: closing income statement for multiple dimensions

    Thank you. This would be the solution for us. How do we obtain the AddOn?  We're in the USA.

  • Verified answer
    Jens Glathe Profile Picture
    6,092 on at
    RE: closing income statement for multiple dimensions

    There are several issues here. Post contribution by dimension combination - this is not supported on the retained earnings side. And, as expexted, no account by dimension combination.

    Now, one general consideration. There are many possible dimension combinations, if you can post contribution by dimension combination, they can likewise be on one retained earnings account - they will be separated by the dimension combinations on the entries anyway. If this is enough for your reporting needs, then you can use our AddOn (Plexada BuildingBlocks), which has a Close Income Statement batch that does contribution by dimenion combination postings. If you need separate accounts, some additional coding on the base of this logic needs to be done, but with the AddOn you're already at 90% of the way.

  • Verified answer
    ManishS Profile Picture
    80 on at
    RE: closing income statement for multiple dimensions

    I don't think its possible, you can close the income statement dimension wise but that will effect only one retained account and not multiple retained account.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans