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
- Go to the Receivables work center.
- Go to the Reports -> List sub view.
- Select Accounts Receivable - Line Items report.
- 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
SAP Knowledge Base Article - Public