Hello Nazeer, Thank you very much for your input. I will consider the Jira option.
Regards, Chris On Fri, Jan 20, 2017 at 5:55 PM, Shaik Nazeer < nazeer.sh...@confluxtechnologies.com> wrote: > Yes, customer identifiers will be added after creating a client and there > is no option to create a data table with unique column definition so that > it will be linked to client entity data table check. > > You can raise an enhancement ticket in Jira. I hope some community member > implements this task. > > > > Thanks, > > Nazeer > > Principal Architect, Conflux Technologies Pvt Ltd > <http://www.confluxtechnologies.com/> > > Address: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, > Karnataka, 560043 INDIA > > [image: unnamed] > > Disclaimer: The information contained in this e-mail message and any > files/attachment transmitted with it is confidential and for the sole use > of the intended recipient(s) or entity identified. If you are not the > intended recipient, please email: supp...@confluxtechnologies.com and > destroy/delete all copies and attachment thereto along with the original > message. Any unauthorized review, use, disclosure, dissemination, > forwarding, printing or copying of this email or any action taken in > reliance on this e-mail is strictly prohibited and is unlawful. The > recipient acknowledges that Conflux Technologies Private Limited or its > subsidiaries and associated companies are unable to exercise control or > ensure or guarantee the integrity of/over the contents of the information > contained in e-mail transmissions. Before opening any attachments, please > check. > > > > *From:* Christopher Stewart [mailto:christopher.mckenzie.stew...@gmail.com] > > *Sent:* 20 January 2017 12:06 > *To:* A good place to start for users or folks new to Mifos. > *Cc:* dev (dev@fineract.incubator.apache.org); Rajan Maurya > *Subject:* Re: [Mifos-users] Creating unique external ID in mifos x > > > > Hi Nazeer, > > > > I require the national ID to be mandatory when creating a new client. > Right now a client can be created without an identifier even though it is > unique. > > > > Rgds > > > > Chris > > > > On Jan 20, 2017 11:11 AM, "Nazeer Shaik" <nazeer.shaik@ > confluxtechnologies.com> wrote: > > National ID should be part of the customer identifier and it is already > unique. > Can you explain bit more why it should be part of entity data table check? > > > Thanks, > Nazeer > > *Principal Architect, **Conflux Technologies Pvt Ltd > <http://www.confluxtechnologies.com/>* > > *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 confidential and for the sole use > of the intended recipient(s) or entity identified. If you are not the > intended recipient, please email: supp...@confluxtechnologies.com and > destroy/delete all copies and attachment thereto along with the original > message. Any unauthorized review, use, disclosure, dissemination, > forwarding, printing or copying of this email or any action taken in > reliance on this e-mail is strictly prohibited and is unlawful. The > recipient acknowledges that Conflux Technologies Private Limited or its > subsidiaries and associated companies are unable to exercise control or > ensure or guarantee the integrity of/over the contents of the information > contained in e-mail transmissions. Before opening any attachments, please > check. > > > > On Fri, Jan 20, 2017 at 10:27 AM, Christopher Stewart < > christopher.mckenzie.stew...@gmail.com> wrote: > > Hello all, > > > > I have a request to ensure that the national ID be a unique and mandatory > field for all clients. So when a client is created this should be verified. > > I looked at the entity data table check feature but it does not verify the > entry is unique. > > > > I'm sure this is not a unique requirement and hope someone can help me > out. > > > > Thanks in advance > > > > Chris > > > > On Jan 11, 2017 1:59 AM, "Rajan Maurya" <rajanmaurya...@gmail.com> wrote: > > Hi Christopher, > > > > App code base has changed a lot and working fine. > > I have emailed you the latest APK please check and we are going to > release the app very soon on play store. > > > > > On Tue, Jan 10, 2017 at 3:07 PM, Christopher Stewart < > christopher.mckenzie.stew...@gmail.com> wrote: > > Hi, > > Has anyone managed to connect and use the mifos Android client > successfully? > > I see many posts regarding connection failures and I myself are getting the > 'there was some issue processing your request' error. > > My mifos instance is hosted on an ip address and not domain name. Ex: > 204.xxx.xxx.xxx/#/ port 80. > > The isn't version is 3 and I have the November 2016 version of mifos > running. > > Any help would be greatly appreciated. > > Thanks in advance > > Chris > > On Dec 23, 2016 7:48 PM, "Sander van der Heyden" < > sandervanderhey...@musonisystem.com> wrote: > > 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 cannot test > this on the demo as the ability to create new loans seems to be broken > right now. > > Thanks, > Sander van der Heyden > > > > On 15 December 2016 at 11:16, Sander van der Heyden < > sandervanderhey...@musonisystem.com> wrote: > > > 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://demo.openmf.org/#/loanaccount/333/disburse) > cannot > > be disbursed as a result of an EMI error: > > > *error.msg.loanschedule.emi.amount.must.be.greter.than.interest*, when > > > > you disburse with date of 1st of October. > > > > If you try to disburse as per 1st of November then it does work fine, > > which leads me to believe there is an issue in the error handling around > > compounding for backdated loans. As there are no params on a loan level, > > that we can adjust to not trigger interest recalculation when disbursing > > I'm not sure how to get around this one? > > > > Thanks, > > Sander > > > > > > > > > > Sander van der Heyden > > > > CTO Musoni Services > > > > > > > > > > > Mobile (NL): +31 (0)6 14239505 <+31%206%2014239505> > > Skype: s.vdheyden > > Website: musonisystem.com > > Follow us on Twitter! <https://twitter.com/musonimfi> > > Postal address: Hillegomstraat 12-14, office 0.09, 1058 LS, Amsterdam, > > The Netherlands > > > > > On 13 December 2016 at 08:52, Sander van der Heyden < > > sandervanderhey...@musonisystem.com> wrote: > > > >> 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 > >> where we are going wrong, or whether this is actually a bug? > >> > >> Thanks, > >> Sander > >> > >> > >> > >> On 12 December 2016 at 06:20, Adi Raju <adi.raju@confluxtechnologies. > com> > >> wrote: > >> > >>> 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 and 2nd Jan. No repayment is made as of today > >>> (12/12). > >>> So interest calculation will be as follows: > >>> Interest on compounded amount as of 1 Dec for 11 days (1st to 12th of > >>> dec) > >>> Plus > >>> Interest on amount as per original schedule for 21 days (13th dec to > 2nd > >>> of jan) > >>> > >>> As and when interest recalculation job runs every day, interest will be > >>> revised to include calculations as of that day. > >>> > >>> 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 confidential and for the sole > use > >>> of the intended recipient(s) or entity identified. If you are not the > >>> intended recipient, please email: supp...@confluxtechnologies.com and > >>> destroy/delete all copies and attachment thereto along with the > original > >>> message. Any unauthorised review, use, disclosure, dissemination, > >>> forwarding, printing or copying of this email or any action taken in > >>> reliance on this e-mail is strictly prohibited and is unlawful. The > >>> recipient acknowledges that Conflux Technologies Private Limited or its > >>> subsidiaries and associated companies are unable to exercise control or > >>> ensure or guarantee the integrity of/over the contents of the > information > >>> contained in e-mail transmissions. Before opening any attachments, > please > >>> check. > >>> > >>> > >>> > >>> -----Original Message----- > >>> From: Sander van der Heyden [mailto:sandervanderheyden@ > musonisystem.com] > >>> Sent: 09 December 2016 22:08 > >>> To: dev@fineract.incubator.apache.org > >>> Cc: A good place to start for users or folks new to Mifos. > >>> Subject: Re: Issues in interest recalculation > >>> > >>> 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 strange scenario which is: https://demo.openmf.org/#/view > >>> loanaccount/321 > >>> > >>> Can you explain to me how the calculation for the interest for the 2nd > >>> instalment is made, so the first instalment which was due 8 days ago > is now > >>> overdue by 8 days and interest (should have) compounded as well. > However I > >>> cannot work out the formula used to get to that amount of interest, > when > >>> running the same example for a loan just 1 day overdue, I was able to > work > >>> out the amount, but only as long as I calculated 2 extra days. Is > there any > >>> docs on this on the wiki (I could not spot them). > >>> > >>> Thanks, > >>> Sander > >>> > >>> > >>> > >>> Sander van der Heyden > >>> > >>> CTO Musoni Services > >>> > >>> > >>> > >>> > >>> Mobile (NL): +31 (0)6 14239505 <+31%206%2014239505> > >>> Skype: s.vdheyden > >>> Website: musonisystem.com > >>> Follow us on Twitter! <https://twitter.com/musonimfi> Postal address: > >>> Hillegomstraat 12-14, office 0.09, 1058 LS, Amsterdam, The Netherlands > >>> > >>> On 8 December 2016 at 06:23, Adi Raju <adi.raju@confluxtechnologies. > com> > >>> wrote: > >>> > >>> > 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 confidential and for the sole > >>> > use of the intended recipient(s) or entity identified. If you are not > >>> > the intended recipient, please email: support@confluxtechnologies. > com > >>> > and destroy/delete all copies and attachment thereto along with the > >>> > original message. Any unauthorised review, use, disclosure, > >>> > dissemination, forwarding, printing or copying of this email or any > >>> > action taken in reliance on this e-mail is strictly prohibited and is > >>> > unlawful. The recipient acknowledges that Conflux Technologies > Private > >>> > Limited or its subsidiaries and associated companies are unable to > >>> > exercise control or ensure or guarantee the integrity of/over the > >>> > contents of the information contained in e-mail transmissions. Before > >>> > opening any attachments, please check. > >>> > > >>> > > >>> > > >>> > > >>> > -----Original Message----- > >>> > From: Sander van der Heyden > >>> > [mailto:sandervanderhey...@musonisystem.com] > >>> > Sent: 07 December 2016 22:24 > >>> > To: dev@fineract.incubator.apache.org > >>> > Cc: A good place to start for users or folks new to Mifos. > >>> > Subject: Re: Issues in interest recalculation > >>> > > >>> > 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. > >>> > > >>> > > >>> > *Incorrect interest in Loan Schedule for first instalment when making > >>> > an early payment* See https://demo.openmf.org/#/viewloanaccount/302, > >>> > where you see 3.85 of interest paid on the summary and loan > >>> > transactions, yet the > >>> > 3.85 is still due on the instalment and if you look at the schedule > >>> > via the API is reported as outstanding interest (which the > transaction > >>> > has already paid). > >>> > > >>> > [Adi] In case of interest recalculation enabled loans, there is no > way > >>> > to realise a complete EMI components whose due date is in the future. > >>> > Any early payments gets adjusted to the principal, and hence there > >>> > will be some interest component which will remain due as of the > future > >>> > due date. From calculations or schedule point of view the early paid > >>> > amount is completely getting adjusted to Principal and interest is > >>> pending. > >>> > Repayment strategy decides the splitting of components in a > >>> transaction. > >>> > Looks like the repayment strategy needs a correction not to consider > >>> > the interest component in case of early payment. > >>> > > >>> > *Interest recalculation causes incorrect schedule with duplicate > >>> > instalments* For the daily loans with duplicate instalments see: > >>> > https://demo.openmf.org/#/viewloanaccount/304, where you can see > that > >>> > 2 payments fall due on the same day. If you undo disburse the loan > and > >>> > preview the schedule before disbursement you'll not see duplicate > >>> > payments on the same day. > >>> > [Adi] As I see original schedule is fine, but during repayments some > >>> > duplicates are seen. This is definitely a bug. > >>> > > >>> > Thanks, > >>> > Sander > >>> > > >>> > > >>> > > >>> > > >>> > Sander van der Heyden > >>> > > >>> > CTO Musoni Services > >>> > > >>> > > >>> > > >>> > > >>> > Mobile (NL): +31 (0)6 14239505 <+31%206%2014239505> > >>> > Skype: s.vdheyden > >>> > Website: musonisystem.com > >>> > Follow us on Twitter! <https://twitter.com/musonimfi> Postal > address: > >>> > Hillegomstraat 12-14, office 0.09, 1058 LS, Amsterdam, The > Netherlands > >>> > > >>> > On 7 December 2016 at 11:20, Adi Raju > >>> > <adi.r...@confluxtechnologies.com> > >>> > wrote: > >>> > > >>> > > 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 applied equally with interest rate 1% considering > >>> > > 12%pa interest with monthly payment period. > >>> > > > >>> > > In case there is any date difference due to holidays/working days > >>> > > consideration or early payments etc, the calculation happens as > >>> follows: > >>> > > Assume installment is falling on 1st Feb, but due to holiday the > >>> > > installment is postponed to 2nd Feb and consider 12%pa interest > rate. > >>> > > Interest for the whole month of Jan is calculated at 1% and > interest > >>> > > for the 1 additional day in Feb is calculated as 1%*(1/28). > >>> > > For the installment on 1st Mar, interest is calculated as > 1%*(27/28) > >>> > > would be used. > >>> > > This is how the current interest recalculation happens to make sure > >>> > > the interest is collected for each and every day. > >>> > > And partial interest for any day is calculated based on the number > >>> > > of days in the loan installment period. > >>> > > > >>> > > I am unable to reproduce other issues that you have mentioned. > Looks > >>> > > like they are linked to some other factors as well. If you can > >>> > > reproduce them on demo.openmf.org and provide with loan ids or > >>> > > relevant details, we can get back with clarifications or verify if > >>> > > it is > >>> > really a bug. > >>> > > > >>> > > 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 confidential and for the > >>> > > sole use of the intended recipient(s) or entity identified. If you > >>> > > are not the intended recipient, please email: > >>> > > supp...@confluxtechnologies.com and destroy/delete all copies and > >>> > > attachment thereto along with the original message. Any > unauthorised > >>> > > review, use, disclosure, dissemination, forwarding, printing or > >>> > > copying of this email or any action taken in reliance on this > e-mail > >>> > > is strictly prohibited and is unlawful. The recipient acknowledges > >>> > > that Conflux Technologies Private Limited or its subsidiaries and > >>> > > associated companies are unable to exercise control or ensure or > >>> > > guarantee the integrity of/over the contents of the information > >>> > > contained in e-mail transmissions. Before opening any attachments, > >>> please check. > >>> > > > >>> > > > >>> > > > >>> > > > >>> > > -----Original Message----- > >>> > > From: Sander van der Heyden > >>> > > [mailto:sandervanderhey...@musonisystem.com] > >>> > > Sent: 05 December 2016 17:06 > >>> > > To: dev@fineract.incubator.apache.org; A good place to start for > >>> > > users or folks new to Mifos. > >>> > > Subject: Issues in interest recalculation > >>> > > > >>> > > 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 > >>> > > - Advance payments set to Reduce EMI Amount > >>> > > - No grace periods > >>> > > - No sliding interest rates, or multi-disbursements > >>> > > - No fixed EMI amounts > >>> > > > >>> > > I've not yet created JIRA items on it, because I was wondering > >>> > > whether other people had seen these and there was a work-around by > >>> > > specifying the right params? Also when trying to debug some of this > >>> > > I think the calculations have now been made so incredibly complex > >>> > > that it is very hard to fix some of these without creating other > >>> bugs in exchange. > >>> > > > >>> > > *Daily interest on Same as Repayment period* On monthly loans, even > >>> > > though same as repayment period is selected, the interest > >>> > > calculation seems to happen on a daily basis. We see jumps up and > >>> > > down in the schedule, which should not happen especially before any > >>> > > payments are made, as in that case the interest calculation should > >>> > > be identical for each month (we are using same as repayment period) > >>> > > and therefore the interest amount should always drop month over > >>> > > month, with principal > >>> > going up. > >>> > > > >>> > > *Incorrect interest in Loan Schedule for first instalment when > >>> > > making an early payment* When setting up any interest recalculation > >>> > > loan, and making an early payment on the first instalment, this > >>> > > updates the schedule with all of it going to principal, leaving the > >>> > > interest outstanding. However the actual transaction does split > part > >>> > > of it to interest and so does the loan summary. > >>> > > In subsequent instalments this no longer happens. > >>> > > > >>> > > *Interest recalculation causes incorrect schedule with duplicate > >>> > > instalments* > >>> > > On a daily loan, when an installment was originally due on a > weekend > >>> > > day, it get's pushed forward, skipping that day correctly. However > >>> > > in recalculation this is no longer happening therefore introducing > 2 > >>> > > installments on the same date one with a 0 length. So what happens > >>> > > is pre-correction you have an instalment on the 3rd of December, > >>> > > then one on the 5th (skipping sunday). After the payment and > >>> > > recalculation it has 2 instalments due on the 5th, one with 0 days > >>> and no interest. > >>> > > > >>> > > *Single instalment loans do not recalculate* When a loan with 1 > >>> > > instalment is created and the client prepays on that one > instalment, > >>> > > interest is not recalculated. > >>> > > > >>> > > *Early payment of all principal throws an EMI error* When repaying > >>> > > the full principal due on the loan in an early instalment it throws > >>> > > an EMI error, which should not happen, there is still a bit of > >>> > > interest to pay, but no more principal. This means the schedule > >>> > > should just show that interest remaining (or close the loan as > there > >>> is no interest). > >>> > > > >>> > > > >>> > > Thanks, > >>> > > Sander > >>> > > > >>> > > > >>> > > >>> > > >>> > >>> > >> > > > > ------------------------------------------------------------ > ------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today.http://sdm.link/intel > _______________________________________________ > Mifos-users mailing list > mifos-us...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > > -- > > *Thanks* > > *Namaste* > > > > Rajan Maurya > > Contact Number : +91 9015090523 <+91%2090150%2090523> > > Github: https://github.com/therajanmaurya > > College: Cluster Innovation Centre, University of Delhi > > Student : B.Tech. (Information Technology & Mathematical Innovations) > > > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > > _______________________________________________ > Mifos-users mailing list > mifos-us...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > mifos-us...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > mifos-us...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > >