Symptom
You checked the Cash - Open Items report and noticed that it shows an open amount for a journal entry of type Techn. Clearing of Bank Clearing Account. You checked the payment allocation related to this journal entry and see that it is posted.
You wish to understand why it still shows as an open amount in the Cash - Open Items report.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Open the Cash - Open Items report.
- Apply the relevant selection criteria and execute the report.
You see that the report shows an amount as open item, corresponding to a journal entry type Techn. Clearing of Bank Clearing Account
You checked the corresponding payment allocation and the allocated payment and see that they are Posted and Completed respectively. You wish to understand why the amount still shows as open.
Cause
The amount shows as open, since one of the journal entry lines have no clearing details. You can check that by opening the journal entry and referring to the item's Details section (for both credit and debit sides). You notice that one of the sides does not have the 'Clearing for Document ID' reference.
In this case, the payment allocation allocated the amount with a bank advice, which in turn has a tax authority as business partner. Since the payer/payee is a tax authority, the amount gets allocated to 8 - Tax payables or receivables and a tax payment is automatically created.
This tax payment remains In Preparation, hence the amount still shows as open in the Cash report.
Resolution
You need to post the tax payment accordingly. You can find the related tax payment as follows:
- Go to Tax Management work center.
- Go to Tax Payment view.
- Check the In Preparation tax payments by the amount and company.
- Once you find the payment, you need to post it against a tax return and accept any differences, if any.
Keywords
Tax Payment. Payment Allocation. Tax Management. , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To