How To Fix G0795 - Upload file contains data records for multiple fiscal years

SAP Error Message - Details

• Message type: E = Error

• Message class: G0 - Messages for SAP Consolidation

• Message number: 795

• Message text: Upload file contains data records for multiple fiscal years

What causes this issue?

You execute the flexible upload in the following scenario:
In the upload method, you have specified the <LS>Cumulated</> input
type.
The upload file contains data records for multiple fiscal years.
This scenario can cause data inconsistency because the system does not
execute a balance carryforward when executing the flexible upload for
multiple fiscal years.

System Response

The system issues a warning in the flexible upload log.

How to fix this error?

When executing the cumulated upload, use only upload data that contains
the data records for a single fiscal 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message G0795 - Upload file contains data records for multiple fiscal years ?

  The SAP error message G0795, which states "Upload file contains data records for multiple fiscal years," typically occurs during the upload of financial data into the SAP system. This error indicates that the file you are trying to upload contains records that span multiple fiscal years, which is not allowed in certain financial processes.
  Cause:
  
  Multiple Fiscal Years in Data: The upload file includes data entries that belong to different fiscal years. For example, if you are trying to upload data for the fiscal year 2023, but the file also contains records for 2022 or 2024, this error will occur.
  Incorrect File Format: The file may not be formatted correctly, leading to misinterpretation of the fiscal year data.
  Data Preparation Issues: The data may not have been properly filtered or prepared before the upload, resulting in mixed fiscal year entries.
  
  Solution:
  
  Check the Upload File: Open the upload file and verify that all records belong to the same fiscal year. Remove any records that do not match the intended fiscal year.
  Filter Data: If you are using a spreadsheet application (like Excel), apply filters to ensure that only the relevant fiscal year data is included in the upload file.
  Reformat the File: Ensure that the file is in the correct format as required by SAP. This may include checking delimiters, headers, and data types.
  Use SAP Tools: If available, use SAP tools or transaction codes (like LSMW or BAPIs) that can help in uploading data while ensuring compliance with fiscal year constraints.
  Test Upload: Before performing a full upload, conduct a test upload with a small subset of data to ensure that the issue is resolved.
  
  Related Information:
  
  SAP Documentation: Refer to the official SAP documentation for guidelines on data uploads and fiscal year handling.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as LSMW (Legacy System Migration Workbench) or others that may be used for data uploads.
  Consult with SAP Support: If the issue persists, consider reaching out to SAP support or your internal SAP team for further assistance.
  
  By ensuring that your upload file contains data for only one fiscal year and is formatted correctly, you should be able to resolve the G0795 error.