12
When closing the income statement by dimension, there is only one entry to the Retained Earnings account. Some of my customers actually want to keep the dimension break-out in their retained earnings.

The current work around is to allow BC to generate the Close Income Statement General Journal rows. Then, delete the row for Retained Earnings, copy the remaining rows to Excel, change the account number on all rows to the retained earnings account, multiply the line amount on all rows by -1, paste the new rows to BC and then post.

It would be great if Business Central could do this for them.
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team

Comments

M

I agree this needs to be automatically done by business unit, at least.

Category: Financial Management

M

Yes, please include the Business Unit as well as dimensions for the consolidation company so that the retained earnings can be split by entity.

Category: Financial Management

M

We need this enhancement to enable the roll up to retained earnings

Category: Financial Management

M

The Close Income Statement for Retained Earnings also is imperative with Business Unit Codes in the Consolidation Company to retain a balanced Trial Balance By Business Unit Code. However, the Close Income Statement process in the system does not automatically break out the Retained Earnings By Business Unit Code. This has been a significant weakness in design because it requires a manual reclassification of the Retained Earnings by Business Unit Code. There needs to be code to either automate this process during the Close Income Statement or there needs to be some sepearate Action to calculate Net Income/Loss By Business Unit after the original Close Income Statement process is run. Otherwise, the end result generated by the system is an imbalanced By-Business Unit Code Trial Balance.

Category: Financial Management