How To Fix G00774 - Dimension &1: No document type exists for calculating retained earnings

SAP Error Message - Details

• Message type: E = Error

• Message class: G00 - SAP Consolidation

• Message number: 774

• Message text: Dimension &1: No document type exists for calculating retained earnings

What causes this issue?

In Global Settings (in transaction CXB3), you have activated the use of
<LS>line items in S/4 HANA</> with an effective from fiscal year that is
no later than the fiscal year in the current parameter environment.
In this case, the system requires a separate document type for posting
the retained earnings for integrated consolidation units (for example,
when reading from the universal document). You must define the separate
document type for reported financial data (that is, with posting level
zero) and with the <LS>calculation of retained earnings</> business
application.
However, there is no such document type in view &V1&.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

In transaction CXER, define a document type with the following
properties:
Posting level zero (reported financial data)
Business application <LS>calculation of retained earnings</>
No calculation of deferred taxes
No automatic document reversal

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message G00774 - Dimension &1: No document type exists for calculating retained earnings ?

  The SAP error message G00774 indicates that there is an issue with the configuration of document types related to retained earnings in the system. This error typically arises during the year-end closing process when the system attempts to calculate retained earnings but cannot find a valid document type for this calculation.
  Cause:
  
  Missing Document Type: The primary cause of this error is that there is no document type defined for retained earnings in the system. This can happen if the configuration for financial accounting (FI) is incomplete or if the document type was inadvertently deleted or not set up correctly.
  Incorrect Configuration: The document type for retained earnings may not be properly assigned in the configuration settings, or the settings may not align with the fiscal year variant being used.
  Fiscal Year Variant Issues: If the fiscal year variant is not correctly configured, it may lead to issues in determining the appropriate document type for retained earnings.
  
  Solution:
  To resolve the G00774 error, follow these steps:
  
  
  Check Document Type Configuration:
  
  Go to the SAP transaction code OBY6 (or navigate through the menu: SPRO > Financial Accounting > General Ledger > Master Data > Document Types).
  Verify that the document type for retained earnings (usually "RE" or similar) is defined and active.
  If it is missing, create a new document type for retained earnings.
  
  
  
  Assign Document Type:
  
  Ensure that the document type for retained earnings is assigned to the appropriate company code and fiscal year variant.
  Check the settings in OBY6 to ensure that the document type is linked to the correct account types.
  
  
  
  Review Fiscal Year Variant:
  
  Check the fiscal year variant settings in OB29 to ensure that it is correctly configured and that it corresponds to the document type settings.
  
  
  
  Run Year-End Closing Again:
  
  After making the necessary changes, attempt to run the year-end closing process again to see if the error persists.
  
  
  
  Consult Documentation:
  
  If you are unsure about the configuration steps, refer to SAP documentation or consult with your SAP FI consultant for guidance.
  
  
  
  Related Information:
  
  Transaction Codes: 
  
  OBY6: Configuration of document types.
  OB29: Configuration of fiscal year variants.
  
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional guidance.
  Testing: After making changes, it is advisable to test the configuration in a development or test environment before applying it to the production system.
  
  By following these steps, you should be able to resolve the G00774 error and successfully calculate retained earnings in your SAP system.