Thanks, Keith and Ramya, My thoughts were the same. A database script to to do this. We need to do this retrospectively. And either refund the excess money collected till date or adjust it with the next dues. That makes such a script a little bit more complicated. And this would need to be tested thoroughly to ensure that past repayments, accounting entries, data warehouse reports etc. are handled correctly. Kinda risky - is what I would say for me. I do not understand the database structure well enough to try a stunt like this.
Hi Ramya, Even though logically reverse and redo seems to be related, these two functions are not related. You reverse a disbursal using an account number and redo based on a customer. So practically you can "redo" a "fresh" loan in Mifos. This is pretty useful at times. If the past installments are to remain unchanged, (i.e interest dues for the past installments are to remain as the same - based on old interest rate), then there is no option but to close and create new accounts. If we redo the loan, then the interest gets recalculated for all installments, including past installments. For now, I am going to suggest to do this reversal and redo one-by-one as I think that is the less risky option. Thanks Binny On Mon, Aug 22, 2011 at 1:16 PM, Keith Woodlock <keithwoodl...@gmail.com>wrote: > Binny, > > As you guessed, theirs no support for this in mifos at present. you > could do this update at the 'database level' writing a script to > update all active loans (setting interest rate to latest value) and > only update loan schedules from a certain date. > > Keith. > > On Sat, Aug 20, 2011 at 4:32 AM, Binny Gopinath > <binny.gopin...@gmail.com> wrote: > > Hi all, > > > > One of my clients want to change their interest rate (from 15.46% flat, > to > > 13.04 flat). This is a change across the organization for one of their > loan > > product and needs to be applied to all active loans also. > > > > I have 2 questions: > > > > a) > > > > Old installments remain unchanged and new installments will have the > revised > > interest rate, (i.e. for 10,000 loan, old installments have the interest > as > > 30 and any future installments will have interest as 26): Can Mifos > handle > > such a scenario? My guess is it cannot. Have any of you faced this issue > and > > if yes, is there a workaround? - > > The only thing I can think of is to one-by-one close all existing loans > with > > "closed-rescheduled" status. Make a note of the principal outstanding > before > > closing and to create new loans based on this amount. This will be very > > painful for the MFI staff and also may show a very skewed data in their > > reports. > > > > b) > > > > If old installments also are to change with the new interest rate, then > we > > could use "reverse loan disbursal" and "redo loan disbursal" features. Is > > that correct? Is there a way to do this in bulk, rather than one loan at > a > > time? > > > > -- > > Thanks and Regards > > Binny Gopinath Sreevas > > > > > > > ------------------------------------------------------------------------------ > > Get a FREE DOWNLOAD! and learn more about uberSVN rich system, > > user administration capabilities and model configuration. Take > > the hassle out of deploying and managing Subversion and the > > tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 > > _______________________________________________ > > Mifos-users mailing list > > Mifos-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > > > ------------------------------------------------------------------------------ > uberSVN's rich system and user administration capabilities and model > configuration take the hassle out of deploying and managing Subversion and > the tools developers use with it. Learn more about uberSVN and get a free > download at: http://p.sf.net/sfu/wandisco-dev2dev > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users >
------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
