web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Year-end close batch journal not generating retained earnings by dimension journal lines.

(0) ShareShare
ReportReport
Posted on by 20

Hello,

It worked fine last year, but this time after closing the period and having selected the single dimension code we use, the batch journal that generates leaves the global dim blank for Retained Earning.   All other journal lines as would expect, multiple lines for each account as the income/expense account are zeroed out. We should be showing five entries for RE for each profit center (global DIM 1) that we account for.

Please help, statements are due to the bank this week and it'll look amatuer not to have prior year income closed out the balance sheet.

Todd

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    TWBlaisdell Profile Picture
    on at
    Re: Year-end close batch journal not generating retained earnings by dimension journal lines.

    Hello Todd,

    Thank you for posting on the Community Forum.  The process for posting Retained Earnings by Dimension would be managed through a manual breakout of the entry by Dimension.  The Close Income Statement process in Dynamics NAV generates the Income Statement Account reversal by Dimension. However, the Retained Earnings offset is in total.  It would appear that a user did this manual breakout last year or possibly your partner created some type of modification to calculate the Retained Earnings breakout.

    I hope this helps provide guidance to move forward.

    Thanks

    Tom

  • Community Member Profile Picture
    on at
    RE: Year-end close batch journal not generating retained earnings by dimension journal lines.

    We have one another option (in the report request page). “Post To Retained Earnings Acc.”

    -         If we select DETAILS in this option then

                                    There will NOT be one balancing line for Retained Earnings.

                                    Instead Each Income statement journal line will have its balancing account (Single Lines Balancing).

                                                    So, In This case Retained earnings will be created for each income statement journal line in GL Entry.

                                                    Each Retained Earning line in the GL Entity will be assigned an dimension value also(from income statement lines).

                                                    Hence Each Retained earning Line will have the dimension.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans