How To Fix FIRU_VAT123 - Total of Sales Ledger VAT (&2) not equal to total of sections 1-7 (&1)

SAP Error Message - Details

• Message type: E = Error

• Message class: FIRU_VAT - VAT Russia S/4HANA

• Message number: 123

• Message text: Total of Sales Ledger VAT (&2) not equal to total of sections 1-7 (&1)

What causes this issue?

Your VAT Return data is inconsistent: the total amount of VAT due for
the Sales Ledger must equal the total amount of sections 2, 3, 4 and 6
of the VAT Return.
Total amount of VAT due for the Sales Ledger items = lines 260+270 of
section 9 (and lines 340+350 of section 9.1 in case of Corrective VAT
Return)
Total amount of the main section = total of line 060 of section 2 of
each document + line 118 of section 3 + lines 050+080 of section 4 +
lines 050+130 of section 6

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?

Please check your data and start again.

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 FIRU_VAT123 - Total of Sales Ledger VAT (&2) not equal to total of sections 1-7 (&1) ?

  The SAP error message FIRU_VAT123 indicates a discrepancy between the total VAT amount recorded in the Sales Ledger and the total VAT amounts calculated in sections 1-7 of the VAT return. This error typically arises during the VAT return preparation process when the system detects that the totals do not match, which can lead to compliance issues.
  Cause:
  
  Data Entry Errors: Incorrect entries in the sales invoices or VAT postings can lead to mismatches.
  Missing Transactions: Some sales transactions may not have been included in the VAT return.
  Incorrect VAT Codes: Using the wrong VAT codes on invoices can result in incorrect VAT calculations.
  Timing Differences: Transactions recorded in different periods may not align with the VAT return period.
  Manual Adjustments: Manual adjustments made to VAT amounts may not have been reflected in the Sales Ledger.
  
  Solution:
  
  Review Transactions: Check all sales transactions for the relevant period to ensure they are correctly recorded and that the VAT amounts are accurate.
  Reconcile VAT Accounts: Perform a reconciliation of the VAT accounts to identify any discrepancies between the Sales Ledger and the VAT return sections.
  Check VAT Codes: Ensure that the correct VAT codes are used for all transactions and that they are properly configured in the system.
  Adjust Entries: If any errors are found, make the necessary adjustments to the entries in the Sales Ledger or the VAT return.
  Consult Reports: Use SAP reports (like the VAT report or the Sales Ledger report) to analyze the data and identify where the discrepancies are occurring.
  Run the VAT Return Program Again: After making corrections, re-run the VAT return program to see if the totals now match.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to VAT reporting.
  Configuration Settings: Review the configuration settings for VAT in the SAP system to ensure they are set up correctly.
  User Documentation: Refer to user manuals or training materials for guidance on proper VAT handling in SAP.
  Consult with Finance Team: Collaborate with the finance or accounting team to ensure that all relevant transactions are accounted for and that the VAT return is accurate.
  
  By following these steps, you should be able to identify and resolve the issue causing the FIRU_VAT123 error message.