Symptom
The Accounts Receivable - Open Items report is showing already cleared invoices.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to Receivables work center.
- Select Reports > List view
- Find the report Accounts Receivable - Open Items and click it.
- Enter mandatory details like Company, Set of Books, Key Date and Customer details.
You will find that already cleared invoice is appearing in this report.
Cause
If the key date used in the report is before to the payment posting date used for clearing the invoice then the invoice will continue to show in this report until the key date used is changed to any date on/after payment posting date.
Resolution
The report is working fine. The Accounts Receivable -Open Items report shows the documents only until the key date. Example: If the customer invoicing is payment posting date is 31.01.2018. So when the report is run with key date before to 31.01.2018 then the open amount will be shown in the report as the payment is still not posted. If the key date is changed to 31.01.2018, then there won't be any open items in the report as payment posting date is 31.01.2018.
Keywords
open items in accounts receivable - open items report, cleared invoices appearing in accounts receivable open items report. , KBA , cleared invoice in ar open items report , accounts receivable open items report , SRD-FIN-ANA , Analytics Content , Problem