SAP Knowledge Base Article - Public

3301249 - Cash - Open Items Report Shows Open Amount for a Techn. Clearing of Bank Clearing Account Journal Entry

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

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Open the Cash - Open Items report.
  4. 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:

  1. Go to Tax Management work center. 
  2. Go to Tax Payment view.
  3. Check the In Preparation tax payments by the amount and company.
  4. 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

Product

SAP Business ByDesign all versions