Subtracting Cash-in-Transit from Bank Balance

Summary:Hello,

My clients want to have an updated bank balance in Cash Management, showing the cash-in-transit position subtracted from that bank balance. This is relevant as the clients need to see the bank balance with the cash-in-transit amounts subtracted from it to understand the real balance and have a clear idea of how much money they have in their bank accounts.

I have checked, and from my understanding, there is no standard function to check this. They want the cash-in-transit amounts to be reflected in the outflows on the Cash Position page so they can see the balance with the subtraction of the amount in transit from the bank balance. Is there a way to this or is there any other Oracle recommendation to understand the bank balance without the Cash-in-transit amounts?