SAP Knowledge Base Article - Public

2932634 - Clearing ID # in Accounts Receivable - Line Items report

Symptom

Clearing ID is showing as # in the Accounts Receivable - Line Items report (Report ID FINGLAU08_Q0001) against the Customer Invoice ID.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Receivables work center.
  2. Go to the Reports -> List sub view.
  3. Select Accounts Receivable - Line Items report.
  4. Filter mandatory details and add Customer Invoice ID and Clearing ID fields.

You will notice that the Clearing ID is showing as # for the customer invoices which are already paid.

Cause

Clearing ID is captured at the Source Document ID level.

Resolution

In the data selection, you need to remove Customer Invoice ID field and add Source Document ID.

This way you can see the Clearing ID per invoice, having the Clearing ID itself indicates that this invoice is cleared.

Keywords

clearing id #; not assigned; Accounts Receivable - Line Items; FINGLAU08_Q0001 , KBA , SRD-FIN-ACR , Receivables , Problem

Product

SAP Business ByDesign all versions