SAP Knowledge Base Article - Public

2736346 - Unbalanced Cash Cash Reconciliation Report

Symptom

You observe that there is an Absolute Difference in the Cash Reconciliation Report.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics Work Center.
  2. Go to Design Reports view.
  3. Open the Cash Reconciliation Report.
  4. Give the Selection Parameters.

You observe that there is an absolute difference which is not balanced.

Cause

The Creation or Last change date times to be tracked in order to look for the sequence of events that happen together.

For Example:

Bank Statement(Bank Statement ID)  for Bank Account: (Bank Account Number) (Creation Date time:02/03/2017 02:13 AM).

The Bank Credit Advice (Bank Credit Advice Number) is indeed confirmed. Check the Document Flow and click on Allocation (Respective Allocation Number), Changed On: 05/04/2017 01:48 AM, Click on its Journal Entry: (Journal Entry ID), Reversal Journal Entry ID: (Reversal Journal Entry ID) (Creation Date: : 05/04/2017 01:48 AM).

Here Source Document Type = Tax Due Payment, Source Document ID: (Source Document ID Number). Click on this document link (Document ID), it opens Tax Payment Request (Tax Payment Request Number) which is in Canceled status and this is why you see the Reversal Journal Entry: (Reversal Journal Entry ID).

Now, in the Allocation (Allocation ID), click on Payment Clearing ID, it opens Tax Payment (Tax Payment Number) which was also created on: 05/04/2017 01:48 AM. This
means that when the above Tax Due Payment was canceled at 05/04/2017 01:48 AM, the Reversal Journal Entry (Reversal Journal Entry ID) is created and this follow-up In Preparation document was created.

Resolution

You would need to post this to get the Cash Reconciliation green.

Keywords

Cash Reconciliation Report, Absolute Differences, Unbalanced Cash Cash Reconciliation Report , KBA , AP-PAY , Payment Processing , Problem

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902 ; SAP Business ByDesign 1905 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0