In the Accounts Receivable - Open Items Report shows those items which are still open in the customer account monitor but you observe that the Clearing Date shows for instance 12-31-9999 against these open item invoices. Ideally if the open item has clearing then it should never be shown in this report and you do not know the reason why it shows clearing date and the items against it
Reproducing the Issue
- In the Receivables work center navigate to the Reports-List view
- Open the Accounts Receivable - Line Items report
- Maintain the mandatory variable fields as well as the select the customer to check opem items
- From Not Currently Shown, select Clearing Date and click on Move to Rows
You will observe that against the open items you will see the clearing date as 12-31-9999
When we get an open item in accounting - the system sets the clearing date to XX-XX-XXXX. When the open item is cleared, this date is reset to the date of clearing.
The Current system behavior is that, whenever you post a invoice by default the clearing date of 12-31-9999 is set by the system. This date is an indication that the invoice is yet to be cleared and is not the actual clearing date.
Upon clearing the invoice, then this invoice item is not shown in this report and the clearing date 12-31-9999 is reset to the date of actual clearing/payment date of the invoice
KBA , SRD-CC , Cross Components , How To