How to migrate invoices with installments
we need to migrate receivable transactions (loans) with installments from legacy system.
In Oracle R12.1.3. we have already defined standard split payment terms eg. 6 Monthly Installments, 12 Monthly Installments etc.
The problem is that some invoices have balances not equal to the installments schedule because of payment delays or overpay.
Ex. :
There was loan for 1000 in legacy system with schedule 100 x 10 months.
There was 5 Receipts in legacy system but not 5 x 100.
Suppose we have balance to migrate 550 .
We need to have the same schedule like in legacy system, and the difference add or subtract to last installment.
In above example