[
http://mifosforge.jira.com/browse/MIFOS-1986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=57916#action_57916
]
johnwoodlock commented on MIFOS-1986:
-------------------------------------
Still working on this one but decided to stop and take some advice. It kind of
hits the loan jackpot in that it runs the gamut of schedules, account
transactions, loan summaries and status change. I'm changing the title of this
issue based on what I've come across so far.
Help Moving Forward
-------------------
This particular issue is very much an edge case and it might be sensible to
delay full fix of this until post-Shamimd as the fix is a bit risky.
However, I don't want to back away from it. Now that I've got my head around
most of this I'd really like to see it through (this fix and associated issues)
with the help of whatever comes out a review by Emily, Kay or whoever knows how
it should be. So, all in all, I think I need help in what to do moving forward.
Summary
-------
When a repaid (status 6) loan is 'adjusted' from the loan details page the loan
is reopened. Mifos reverses the last payment + changes the status.
Problem
-------
No problem at all where the last installment has been 'normally' repaid (just
by itself).
The problem arises if the 'repay loan' (early repayment) link is used and there
existed 'future' installments.
The 'repay loan' functionality doesn't include interest, fees and penalties
associated with future installments in the 'repay' total (fair enough).
Unfortunately, as it processes each future installment to mark it paid, it
doctors the 'original installment amount' for interest, fees and penalties so
that it make the amount equal to its equivalent 'amount paid' value (usually
zero).
When the account is reopened... any interest, fees and penalties that used to
be included in the schedule for future installments are lost.
Fix
---
I'm currently coding/testing the following.
1. Change the processing of future installments so that when they are marked
paid the original figures are not touched.
2. In the reopening process, adjust the loan summaries original amounts back to
what they were (they are also doctored during 'repay loan')
Concerns
--------
Might be reports or extracts that I'm not aware of that pick up the 'original
installment amounts' of paid installments instead of their paid equivalents
assuming that they must be the same value.
Might be mifos functionality that does same and I miss it in my impact analysis
because its a big & central area.
There are a couple of related issues (below).
Main Related Issue
------------------
'repay loan' behaves differently to 'apply payment'. If you put the amount
used in 'repay loan' into the 'apply payment' value it doesn't fully pay off
the loan. 'apply payment' does cater for prepayments but not in the same way
as 'repay loan'.
Small Related Issue
-------------------
"Repayment Schedule" page doesn't show penalties - "Next installment details"
page does though.
> Interest gets calculated for only the first installment after repaid loan is
> reopened.
> --------------------------------------------------------------------------------------
>
> Key: MIFOS-1986
> URL: http://mifosforge.jira.com/browse/MIFOS-1986
> Project: mifos
> Issue Type: Bug
> Components: Loan Account
> Affects Versions: Release 1.1
> Environment: Platform: All, OS: All
> Reporter: arpita_a
> Assignee: johnwoodlock
> Priority: Critical
> Fix For: Shamim D
>
> Attachments: actual repayment schedule.doc, expected repayment
> schedule.doc
>
>
> Hi,
> Steps to repro:
> 1. Log into http://testgreen.mifos.org:9002/green2
> 2. Search for Loan Account # 000100000000337.
> (The loan is a weekly declining balance loan for groups with no fees or grace)
> 3. Click on the search result.
> 4. On the loan account information page, click on "View Repayment Schedule".
> Actual: only the first installment has interest. All other installments only
> have the Principal amount.
> Expected: the type of interest is "Declining Balance". Accordingly, interests
> should be there in all the installments.
> Plz see the attachments for more details.
> Operating System / Arch / Version Windows 2003 / x86 / 5.2
> Java Vendor / Version Sun Microsystems Inc. / 1.5.0_12
> Database Vendor / Version MySQL / 5.0.45-community-nt
> Database Driver / Version MySQL-AB JDBC Driver / mysql-connector-java-5.1.5 (
> Revision: ${svn.Revision} )
> Application Server Apache Tomcat/6.0.16
> Mifos Database Version 197
> Subversion Revision Number 13132
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
