You observe that there is an Absolute Difference in the Cash Reconciliation Report.
SAP Business ByDesign
Reproducing the Issue
Go to Business Analytics Work Center.
- Go to Design Reports view.
- Open the Cash Reconciliation Report.
- Give the Selection Parameters.
You observe that there is an absolute difference which is not balanced.
The Creation or Last change date times to be tracked in order to look for the sequence of events that happen together.
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.
You would need to post this to get the Cash Reconciliation green.
Cash Reconciliation Report, Absolute Differences, Unbalanced Cash Cash Reconciliation Report , KBA , AP-PAY , Payment Processing , Problem