Receipt Settlement
There is a situation as follows,
Customer A gives an advanced payment of 1 million to it's supplier B & the receipt is recorded as an unapplied receipt. The customer decides to stop doing business with B, but B doesn't refund the 1 million as a company policy. Therefore A finds a customer(C) of B & negotiates with C to do business with B. When C is doing business with B, C has to pay up to 1 million to A in order to cover his advanced payment made to B. ( B is also agreed to this process).
How can we handle this process in Oracle?