Hello Riki, The feature request for this is mentioned below - http://mifosforge.jira.com/browse/MIFOS-1537. Please feel free to add comments to this issue. I've gone ahead and added the information you mentioned below to this issue.
Jeff >-----Original Message----- >From: Riki Kurniawan [mailto:riki_kurnia...@yahoo.com] >Sent: Monday, January 11, 2010 12:07 PM >To: A good place to start for users or folks new to Mifos. >Subject: Re: [Mifos-users] More than 7 digits before the decimal > >I'm new in this list, where is the request to put more than 7 digits >before the decimal should be submitted? > >In Indonesian Rupiah currency, 7 digits before the decimal is a problem >because 9999999.999 rupiahs (about 1000 USD) is a very small amount and >easily achieved in calculations. Adding 4 to 5 more digits before the >decimal is more suitable in our currency ( datatype: DECIMAL(14,3) or >DECIMAL(15,3) ) so it can coupe up to 99999999999.999(ninety nine >billionths plus plus) rupiahs which is about 10000000 (10 millions) USD. > >--- On Mon, 1/11/10, Van Mittal-Henkle <va...@grameenfoundation.org> >wrote: > >> From: Van Mittal-Henkle <va...@grameenfoundation.org> >> Subject: Re: [Mifos-users] More than 7 digits before the decimal >> To: "A good place to start for users or folks new to Mifos." <mifos- >us...@lists.sourceforge.net> >> Date: Monday, January 11, 2010, 11:42 AM >> Hi Sam, >> >> Increasing the upper limit on values that can be stored in >> the database has not been requested until now, so it is not >> on our schedule. If there is a need to increase this >> upper limit, please request it so we can estimate it and see >> how it would affect the Gazelle C release schedule. >> >> --Van >> >> ---- >> Van Mittal-Henkle >> Mifos Software Developer >> Grameen Foundation >> va...@grameenfoundation.org >> >> >> > -----Original Message----- >> > From: Sam Birney [mailto:sam.bir...@gmail.com] >> > Sent: Thursday, January 07, 2010 12:36 PM >> > To: mifos-users@lists.sourceforge.net >> > Subject: Re: [Mifos-users] More than 7 digits before >> the decimal >> > >> > >> > Hi Van, >> > >> > do you know if a fix for that is scheduled along with >> the currency >> > denominated >> > accounts work? >> > >> > thanks, >> > Sam >> > >> > On Jan 6, 8:06 am, "Van Mittal-Henkle" <va...@grameenfoundation.org> >> > wrote: >> > > Hi Maina, >> > > >> > > Yes, as Udai points out, the main constraint is >> that the database >> > schema >> > > currently has an upper limit of 7 digits to the >> left of the decimal. >> > So >> > > to allow larger loan amounts we would have to >> change the schema >> > (along >> > > with some places in the code). >> > > >> > > --Van >> > > >> > > ---- >> > > Van Mittal-Henkle >> > > Mifos Software Developer >> > > Grameen Foundation >> > > va...@grameenfoundation.org >> > > >> > > >> > > >> > > >> > > >> > > > -----Original Message----- >> > > > From: Udai Gupta [mailto:mailt...@gmail.com] >> > > > Sent: Wednesday, January 06, 2010 8:02 AM >> > > > To: A good place to start for users or folks >> new to Mifos. >> > > > Subject: Re: [Mifos-users] More than 7 >> digits before the decimal >> > > >> > > > Hi Maina, >> > > >> > > > This is a issue that 7 is a hardcoded value >> in the code, the >> > > > configuration property is not working for >> now. >> > > >> > > >http://mifosforge.jira.com/browse/MIFOS-1537 >> > > >> > > > To fix this issue and support 10 digits >> before decimal we might >> > have >> > > > to, >> > > > - change in schema to have DECIMAL(13,3) >> (10 before decimal + 3 >> > after >> > > > decimal). >> > > > - remove the hardcoded value and use the >> values from configuration >> > > > files >> > > > - put validation for configuration file (at >> startup) not to have >> > > > digitbeforedecimal more than 10 set by >> user. >> > > >> > > > Udai >> > > >> > > >> --------------------------------------------------------------------- >> > -- >> > > >> > > > ------- >> > > > This SF.Net email is sponsored by the >> Verizon Developer Community >> > > > Take advantage of Verizon's best-in-class >> app development support >> > > > A streamlined, 14 day to market process >> makes app distribution fast >> > > and >> > > > easy >> > > > Join now and get one step closer to millions >> of Verizon customers >> > > >http://p.sf.net/sfu/verizon-dev2dev >> > > > >> _______________________________________________ >> > > > Mifos-users mailing list >> > > > mifos-us...@lists.sourceforge.net >> > > >https://lists.sourceforge.net/lists/listinfo/mifos-users >> > > >> > > >> --------------------------------------------------------------------- >> > ------ --- >> > > This SF.Net email is sponsored by the Verizon >> Developer Community >> > > Take advantage of Verizon's best-in-class app >> development support >> > > A streamlined, 14 day to market process makes app >> distribution fast >> > and easy >> > > Join now and get one step closer to millions of >> Verizon >> > customershttp://p.sf.net/sfu/verizon-dev2dev >> > > _______________________________________________ >> > > Mifos-users mailing list >> > > Mifos- >> > >us...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo >> > /mifos-users >> > >> > >> ---------------------------------------------------------------------- >- >> > ------- >> > This SF.Net email is sponsored by the Verizon >> Developer Community >> > Take advantage of Verizon's best-in-class app >> development support >> > A streamlined, 14 day to market process makes app >> distribution fast and >> > easy >> > Join now and get one step closer to millions of >> Verizon customers >> > http://p.sf.net/sfu/verizon-dev2dev >> > _______________________________________________ >> > Mifos-users mailing list >> > Mifos-users@lists.sourceforge.net >> > https://lists.sourceforge.net/lists/listinfo/mifos-users >> >> ---------------------------------------------------------------------- >-------- >> This SF.Net email is sponsored by the Verizon Developer >> Community >> Take advantage of Verizon's best-in-class app development >> support >> A streamlined, 14 day to market process makes app >> distribution fast and easy >> Join now and get one step closer to millions of Verizon >> customers >> http://p.sf.net/sfu/verizon-dev2dev >> _______________________________________________ >> Mifos-users mailing list >> Mifos-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> > > > > > > > >------------------------------------------------------------------------ >------ >This SF.Net email is sponsored by the Verizon Developer Community >Take advantage of Verizon's best-in-class app development support >A streamlined, 14 day to market process makes app distribution fast and >easy >Join now and get one step closer to millions of Verizon customers >http://p.sf.net/sfu/verizon-dev2dev >_______________________________________________ >Mifos-users mailing list >Mifos-users@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
