Tax amount must not be subtracted from Principal Balance in Oracle Loans
For example, in our Amortization table you can see that Amount Paid is 4689.86 and Amount Due is 4225.10 for every period.
Amount Paid is wrong, because the Invoices are including Tax. Tax shouldn’t be subtracted from Principal Balance.
I mean, Principal Balance has being subtracted 4689.86 instead 4225.10, for each period.
For each invoice, these are the amounts:
Transaction Amount: 4689.86 = Lines Amount: 4225.1 + Tax Amount: 464.76
Only Lines amount should be subtracted from Principal Balance, not Lines plus Tax amounts.
Thanks in Advance.