Re: [Mifos-users] Issues in interest recalculation

2016-12-26 Thread Adi Raju
Hi Sander, Regarding interest calculation in excel: I need all the loan product parameters to be able to derive the proper interest. Can you reproduce it on demo server and give me loan id? Regarding loaned 333: Issue is self-explanatory, since no repayments transactions are there, the interest

Re: [Mifos-users] Issues in interest recalculation

2016-12-23 Thread Sander van der Heyden
Hi Adi, We are wondering whether you had a chance to look at the interest calculation excel? We are still unable to reconcile amounts for subsequent instalments. In addition we've also started seeing more problems with loans that are prepaid significantly early on in the schedule, unfortunately I

Re: [Mifos-users] Issues in interest recalculation

2016-12-15 Thread Sander van der Heyden
Hi Adi, Was wondering if you had seen my previous mail? In addition we've also got an issue when backdating the interest recalculation loans that have compounding on Interest enabled, and use the "Same as repayment period" compounding type for interest and principal. This sample loan (https://dem

Re: [Mifos-users] Issues in interest recalculation

2016-12-13 Thread Sander van der Heyden
Hi Adi, Thanks for your feedback, but not sure whether we can make this calculation work, see attached excel using the same logic. It works fine for working out instalment one, but does leave us with a 0.4 difference on the second instalment compared to today's schedule. Could you let me know wher

Re: [Mifos-users] Issues in interest recalculation

2016-12-11 Thread Adi Raju
Interest calculation on future dates will be based on the assumption that payment has been made up-to-date and assuming no arrears. Interest on the unpaid or compounded amount will be calculated and provided as part of schedule only till as of that day. So in the example, EMI is due on 1st Dec

Re: [Mifos-users] Issues in interest recalculation

2016-12-09 Thread Sander van der Heyden
Hi Adi, Thanks for your feedback, makes sense on the early payments and I agree the duplicate instalments is a bug. Looks like the holiday/workingdays config is ignored for that bit. However I think we'll indeed need to introduce this in the payment schedules as well. In addition I found another s

Re: [Mifos-users] Issues in interest recalculation

2016-12-07 Thread Adi Raju
Hi Sander PSB Regards, Adi Raju Principal Architect, Conflux Technologies Pvt Ltd Address: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, Karnataka, 560043 INDIA Disclaimer: The information contained in this e-mail message and any files/attachment transmitted with it is c

Re: [Mifos-users] Issues in interest recalculation

2016-12-07 Thread Sander van der Heyden
Hi Adi, Thanks for your feedback. I already left some test cases on the demo (but have updated the same product in between so you'll need to check the derived data for these). I'll work on some more cases that we've seen locally tomorrow, but these are the ones that were already there. *Incorrec

Re: [Mifos-users] Issues in interest recalculation

2016-12-07 Thread Adi Raju
Hi Sander, Interest recalculation is allowed only when "Calculate interest for exact days in partial period" is enabled in product definition. Consider the scenario: holidays calendar is empty, all days are considered working days and payments are always on time, you will see the interest applie

[Mifos-users] Issues in interest recalculation

2016-12-05 Thread Sander van der Heyden
Hi All, We've been doing a relatively extensive round of testing on interest recalculation loans and found the following issues (on demo.openmf.org). All of the cases below have: - Interest recalculation on - Interest calculation = same as repayment period - Amortization set to Equal instalments -