How to exclude old unreconciled transactions from the Cash In Transit Report

Summary:

We have just implemented the Oracle Fusion Cash Management Cloud Service module recently but our Oracle Fusion Payables and Payments Cloud Service, in addition to GL,AR, and FA module, have been in use since 2017. There are old ap payments and AR receipts that were created prior the enablement of the Cash Management module and the bank reconciliation feature. The AR receipts have status "Cleared" because the receipt class clearing method is set to "Directly" that made the ar receipts to not require clearing via the bank reconciliation in the CM module. On the other hand, the old ap payments