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 / Small and medium business | Business Central, N... / Need to close my retai...
Small and medium business | Business Central, N...
Suggested Answer

Need to close my retained earnings account by selected dimension

(0) ShareShare
ReportReport
Posted on by Inkey Solutions 2,100

Hi All,

I need to close my retained earnings account by selected dimension, But In business central I can see the debits/credits the income and expense accounts appropriately and includes for each account and includes the property code [dimension] and owner code[dimension] that is closed by dimension but there is only one entry to the retained earnings account. There needs to be an entry to the retained earning account for every property that includes the appropriate owner code as well.  Is there any way to achieve this?

Thank You.

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 414 on at

    You can use this option to mention dimensions

    pastedimage1678864193093v1.jpeg

  • Inkey Solutions Profile Picture
    Inkey Solutions 2,100 on at

    raibilalhaider  I have already use them.

  • Bilal Haider Profile Picture
    Bilal Haider 414 on at

    May be then I do not understand your question. Do you want to split the balancing entry to retained earning account based on dimension?

  • Inkey Solutions Profile Picture
    Inkey Solutions 2,100 on at

    Yes

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 414 on at

    As per my knowledge its not possible on retained earning side.

    There is an addon Plexada BuildingBlocks that I have not used, but that may have this functionality.

    As per this post community.dynamics.com/.../720713

  • Inkey Solutions Profile Picture
    Inkey Solutions 2,100 on at

    How do I obtain the Addon?

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 414 on at

    As I told I got its info from the link I pasted.

    You can try another way:

    - Close Income statement with Dimension.

    - Remove the Retained earning entry

    - Export the remaining entries to excel

    - Change the account no to retained earning account on all lines

    - Change the amounts sign

    - Import it back to NAV in same journal

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

    Hi,

    run the Close income statement and mark in this field : Details.

    Then also select the dimension code.

    pastedimage1678873235239v1.png

  • Bilal Haider Profile Picture
    Bilal Haider 414 on at

    Great KasparsSemjonovs

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans