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 <[email protected]> wrote: > From: Van Mittal-Henkle <[email protected]> > Subject: Re: [Mifos-users] More than 7 digits before the decimal > To: "A good place to start for users or folks new to Mifos." > <[email protected]> > 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 > [email protected] > > > > -----Original Message----- > > From: Sam Birney [mailto:[email protected]] > > Sent: Thursday, January 07, 2010 12:36 PM > > To: [email protected] > > 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" <[email protected]> > > 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 > > > [email protected] > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Udai Gupta [mailto:[email protected]] > > > > 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 > > > > [email protected] > > > >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- > > [email protected]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 > > [email protected] > > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
