SAP Knowledge Base Article - Public

3631190 - Total Credit and Debit balances discrepancy in Statutory Journal Report - Italy

Symptom

Credit and debit balances are not correct in the statutory journal report - Italy.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the General ledger work center.
  2. Go to the Statutory reports sub view.
  3. Navigate to the relevant run ID.
  4. Select printed results.
  5. Scroll down to the last document pdf.
  6. Select that and check the details, there is a the slight difference in the debit and credit values.

For Example:

Debit --> 5.880.496.166,86 EUR
Credit --> 5.880.496.233,54 EUR
There is a difference --> 6,668 EUR

(Here Debit and Credit values is being taken for example)

Cause

  • While drilling down the Journal entries report, there is this particular Journal Entry 'ABC' is having the Reversal Journal Entry 'DEF' and the credit and debit amounts for the Journal Entry 'ABC' are not equal, causing the difference in final credit and debit values.
  • In the Journal Entry 'ABC' line items, the total amount for the GL account 1 is greater than the amount in the G/L account 2 causing the difference between these credit and debit values of statutory journal report - Italy.
  • The inconsistency is happening in the system due to the mismatch in amounts within the G/L accounts and the same values been passed on to the Reversal Journal entries.
  • (Here ABC and DEF refers to Journal Entry ID)

Resolution

  1. In the Journal Italy report, the journal entry line items are fetching from the FIA_ACCOUNTING_DOCUMENT Business Object, and there is no filter condition in the Journal Italy report code and there is no code logic to delete the journal entry line items from the backend.
  2. As this issue is occurring in the system due to the Reversal Journal Entries with the GL accounts 1 and 2 of the Journal entry 'ABC'.
  3. Create a new run by excluding these GL accounts 1 and 2. 
  4. After excluding these GL accounts, the total credit amount and total debit amounts are equal in output file. 

See Also

Refer to: https://itsm.services.sap/kb_view.do?sysparm_article=KB0872010

Refer to: KBA 3212434 - Journal - Italy: PDF File Is Missing

Refer to: Statutory Reports Quick Guide

Refer to: Quick Guide for Journal Reporting – Italy

Keywords

credit, debit, statutory journal report, Italy, discrepancy, reversal journal entry, GL accounts, inconsistency, balance, correction, General Ledger. , KBA , SRD-FIN-GL , General Ledger , Problem

Product

SAP Business ByDesign all versions