How To Fix MQ791 - Retained earnings are not defined in selected item table

SAP Error Message - Details

• Message type: E = Error

• Message class: MQ - Messages for Euro Changeover Package

• Message number: 791

• Message text: Retained earnings are not defined in selected item table

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message MQ791 - Retained earnings are not defined in selected item table ?

  The SAP error message MQ791, which states "Retained earnings are not defined in selected item table," typically occurs in the context of financial accounting and reporting, particularly when dealing with the configuration of retained earnings accounts in the system.
  Cause:
  This error usually arises due to one of the following reasons:
  
  Missing Configuration: The retained earnings account has not been defined in the relevant item table for the company code or the specific financial statement version you are working with.
  Incorrect Settings: The settings for the retained earnings account may be incorrectly configured or not aligned with the financial statement version being used.
  Data Inconsistency: There may be inconsistencies in the master data or configuration settings that prevent the system from recognizing the retained earnings account.
  
  Solution:
  To resolve the MQ791 error, you can follow these steps:
  
  
  Check Configuration:
  
  Go to the SAP Customizing Implementation Guide (IMG) and navigate to Financial Accounting (New) > General Ledger Accounting (New) > Master Data > G/L Accounts > Preparation > Define Retained Earnings Account.
  Ensure that the retained earnings account is defined for the relevant company code and that it is correctly assigned to the appropriate item table.
  
  
  
  Verify Financial Statement Version:
  
  Check the financial statement version you are using and ensure that the retained earnings account is included in the version. You can find this under Financial Accounting (New) > General Ledger Accounting (New) > Reports > Financial Statements > Define Financial Statement Versions.
  
  
  
  Review G/L Account Master Data:
  
  Ensure that the G/L account designated as the retained earnings account is correctly set up in the master data. You can check this by navigating to Financial Accounting (New) > General Ledger Accounting (New) > Master Data > G/L Accounts > Display.
  
  
  
  Run Year-End Closing:
  
  If you are in the process of running a year-end closing, ensure that all necessary configurations and postings have been completed before executing the closing process.
  
  
  
  Consult Documentation:
  
  Review SAP documentation or consult with your SAP support team for any specific configurations or requirements related to your version of SAP.
  
  
  
  Related Information:
  
  Transaction Codes: You may find it useful to use transaction codes such as OB53 (to define retained earnings accounts) and OB58 (to define financial statement versions).
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional guidance on configuration.
  User Roles: Ensure that you have the necessary authorizations to make changes to financial configurations in SAP.
  
  If the issue persists after following these steps, it may be beneficial to engage with your SAP support team or a consultant who specializes in SAP Financial Accounting for further assistance.