Retained Earnings GL Account Code not appearing in Management Reporter

(0) Share

Report

Posted on by Community Member

Hello, I designed a balance sheet report on management reporter using reporting to show two companies report. But one of the companies is not showing value of the retained earning while the other is showing. Please what can I do to resolve this issue. Thank you.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

sueconrod 337 on at

Like (0)

Report

1. do the 2 companies have the exact same chart of accounts

2. Did you list all of the accounts in the row format and is the Retained earnings account listed.

3. For Retained earnings on the balance sheet if you accounts are 1000 Assets, 2000 Liabilities, 3000 Owner's Equity/Retained Earnings, 4000-9999 Net Income. Are you listing a line that shows 4000:9000 which would be your retained earnings for the present year or your net income?

Great Plains does not close to a retained earnings account until the year end when it will take all your P&L accounts and close to retained earnings. Therefore, you need to setup all your P&L accounts on one row to get your monthly net income that at the end of the year would be your retained earnings.

Hope this helps

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am having the same issue. I can see the account balance correctly in GP, but nothing is pulling onto my balance sheet report in Management Reporter. Suggested answer below does not help.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Is this the first year of this company? If yes, when you entered the initial balances, did you post an entry to Retained Earnings, or did you let the company update it from a close? Are you using multi-currency? Is the Retained Earnings account set to the Account Category of Retained Earnings?

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, first year; I let the company update it from a close and we are using multi-currency. Category is set to Retained Earnings.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at

Like (0)

Report

Are you using Data Mart or Legacy as the integration to GP? If Data Mart, I would try rebuilding it per this link - www.dynamicsgpinsights.com/.../missing-values-rebuild-your-data-mart-in-management-reporter-2012

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hello all,

I have been able to resolve the issue.

The two companies In the reporting tree have different functional currency.

The resolution was to add a Currency Display of ‘FUNCTIONAL’ to the Column Definition. And it displayed the retained earning.

Thank you

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Yep,

I've run into this before. I used a different solution, but I'm going to go back and see if this would have corrected my issue too. Thanks for following up with the answer!

Kind regards,

leslie

Was this reply helpful? Yes No
DLashua 650 on at

Like (0)

Report

I am having a similar problem. I have a functional currency of Euro and a reporting currency of US. If I have one column showing Euros and one showing USD. However, the Retained Earnings account shows the Euros, but zero for USD. It is not pulling the information from the year end closings that have gone into the account. I also have a net income line for this years earnings for my 4000-9999 accounts. That seems to be fine. How can I get my retained earnings to translate?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@Dlashua

Did you select any currency under currency filter.

If you do, you might just remove it.

And run the report again.

I hope this help.

Kemi Akintayo

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

No manual transactions should be posted to retained earnings. MR will not include these manual transactions in the balance sheet. You can set the display currency to the accounting currency in column definition but this will still be a problem if you need to report retained earnings in reporting currency.

It is suggested you bring on opening balances to a retained earnings adjustment account in the income statement and run year end, moving the balance to the balance sheet without manually posting.

This will sort the issue out - tested it.

Was this reply helpful? Yes No