How To Fix G0786 - Read from universal document: specification of effective year incorrect

G0786 - Overview

• Message type: E = Error

• Message class: G0 - Messages for SAP Consolidation

• Message number: 786

• Message text: Read from universal document: specification of effective year incorrect

What causes this issue?

You have selected the <LS>Read from Universal Document</> data transfer
method on the <LS>Data Collection</> tab page for consolidation unit
&V1& and specified &V2& as the effective year for using this data
transfer method.
The effective year must <ZH>not</> be earlier than the effective year
that you specified for the <LS>Reading from Universal Document Is Active
</> indicator in the data stream for integration (transaction CXN4) for
the same consolidation type, dimension, and version.
For the current consolidation type, dimension, and version, the
effective year for the <LS>Reading from Universal Document Is Active</>
indicator is the fiscal year &V3&.

System Response

The settings for consolidation unit &V1& are inconsistent and cannot be
saved.

How to fix this error?

Specify the fiscal year &V3&, or a later fiscal year, as the effective
year for using the <LS>Read from Universal Document</> data transfer
method for consolidation unit &V1&.
In the effective year, you first need to set the data transfer method
for the consolidation unit to <LS>Read from Universal Document</> (that
is, <ZH>before</> you execute the balance carryforward). Once you have
done this, a "traditional" data collection method (real-time update,
rollup, periodic extract, flexible upload, manual data entry) can <ZH>no
longer</> be used for the reported data of this consolidation unit (this
also applies to fiscal years before the effective year).

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

G0786 - Details

• The SAP error message G0786, which states "Read from universal document: specification of effective year incorrect," typically occurs when there is an issue with the effective year specified in a universal document. This error can arise in various contexts, such as when dealing with document management, archiving, or when trying to access specific data that is time-sensitive.
  Causes:
  
  Incorrect Effective Year: The effective year specified in the document or transaction does not match the expected or valid range of years in the system.
  Data Inconsistency: There may be inconsistencies in the data stored in the database, such as missing or corrupted records.
  
  Configuration Issues: The system configuration related to document management or archiving may not be set up correctly.
  Versioning Problems: If the document has multiple versions, the system may be trying to access a version that is not valid for the specified year.
  
  Solutions:
  
  Check Effective Year: Verify the effective year specified in the document or