How To Fix FINS_RECON791 - &1: There is no reversal line item in table ANEP

SAP Error Message - Details

• Message type: E = Error

• Message class: FINS_RECON - SAP S/4HANA Finance Migration: Reconciliation

• Message number: 791

• Message text: &1: There is no reversal line item in table ANEP

What causes this issue?

The reversal line item is missing for a reversed line item.
There is also a difference between the total of the line items and that
of the totals table.

System Response

The system checks whether the reversal line item also exists for a
reversed line item.
Example: A line item with <AB>ANEP-LNRAN</> = ?04711? must exist for a
line item with <AB>ANEP-LNSAN</> = ?04711?.
For the migration, these line items with inconsistent reversal
information are handled as follows:
If the total of line items, including the line item with inconsistent
reversal information, matches that of the totals table, the item is
migrated without the reversal information.
The line item is <ZH>not</> migrated if there is a difference between
the total of the line items, including the line item with inconsistent
reversal information, on the one hand and that of the totals table on
the other hand. If the line item is the only cause of the difference,
follow-on errors will <ZH>no longer</> occur.
The check takes place for all reversed or reversal line items (
<AB>ANEP-LNSAN</> <> ?00000? and <AB>ANEP-LNSAN</> <> ?99999?) if there
is a difference for the corresponding fixed asset between the total of
the line items and the totals table in the fiscal year.
Line items for which the check is not successful are <ZH>not</>
migrated.
This is logged with an information message for closed fiscal years and
with a warning message for fiscal years that are <ZH>not</> closed.

How to fix this error?

For closed fiscal years, reporting and reconciliation with the general
ledger are based on the values of the totals table. The line item is
therefore migrated so that the values of the totals table are
regenerated.
You should analyze the problem for fiscal years that are <ZH>not</>
closed in order to determine whether the inconsistent line item must be
included in the total or not.

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 FINS_RECON791 - &1: There is no reversal line item in table ANEP ?

  The SAP error message FINS_RECON791 indicates that there is no reversal line item in the asset accounting table ANEP. This error typically occurs when you are trying to reverse an asset transaction, but the system cannot find the corresponding reversal entry in the asset history.
  Cause:
  
  Missing Reversal Entry: The most common cause is that the reversal entry for the asset transaction you are trying to reverse does not exist in the ANEP table.
  Incorrect Transaction Type: The transaction type used for the reversal may not be set up correctly or may not correspond to a valid reversal entry.
  Data Inconsistency: There may be inconsistencies in the asset accounting data, possibly due to manual changes or data migration issues.
  Transaction Not Posted: The original transaction may not have been posted correctly, leading to the absence of a reversal entry.
  
  Solution:
  
  Check the Original Transaction: Verify that the original asset transaction was posted correctly and that it has a corresponding reversal entry.
  Review Transaction Types: Ensure that the transaction type used for the reversal is configured correctly in the system. You can check this in the configuration settings for asset accounting.
  Use Transaction Code AW01N: You can use the transaction code AW01N to view the asset and check the history for any missing entries.
  Repost the Original Transaction: If the original transaction is missing or incorrect, you may need to repost it to create the necessary entries for reversal.
  Consult with SAP Support: If the issue persists, it may be beneficial to consult with SAP support or your internal SAP team for further investigation and resolution.
  
  Related Information:
  
  ANEP Table: This table contains line items for asset accounting. Understanding its structure and the relationships with other tables (like ANEA for asset history) can help in troubleshooting.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as AW01N (Asset Explorer) and AB08 (Reverse Asset Transaction) for managing asset transactions.
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional guidance on handling asset reversals.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.