You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Bharath Gowda <bg...@mifos.org> on 2020/05/25 07:36:24 UTC
Re: [Mifos-users] Managing previously created savings accounts settings
Hi Joseph,
Hope you are doing all good
I would like to clarify the current behavior of savings accounts in
Fineract 1.x. Savings accounts have several table columns similar to those
of the savings product instance. This is done so that the individual
savings accounts previously created are not affected by any changes to the
savings product settings. This is the current behavior of the system right?
That is Right, changes made at the product level will not have any impact
on already created savings accounts.
Now what if I want to change a setting of a savings product (i.e. change
the compounding period, the interest rate, the interest calculation basis
etc.) is there currently a way that I can do this and have it affect all
related savings accounts? Or do I need to update the settings of all the
savings accounts individually?
Currently, there is no option to change those parameters to the
existing saving accounts. any changes you make at the product level will
have an impact only on newly created accounts.
you can try changing the parameters (i.e. change the compounding period,
the interest rate, the interest calculation basis etc.) at the Account
level, However, we recommend you test the scenarios on couple of accounts
first to see if it meets your requirement before doing it for all loans.
Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019636073
http://mifos.org <http://facebook.com/mifos>
<http://www.twitter.com/mifos>
On Thu, May 21, 2020 at 7:51 PM Joseph Cabral <jo...@gmail.com>
wrote:
> Hi again Fineract Team,
>
> I would like to clarify the current behavior of savings accounts in
> Fineract 1.x. Savings accounts have several table columns similar to those
> of the savings product instance. This is done so that the individual
> savings accounts previously created are not affected by any changes to the
> savings product settings. This is the current behavior of the system right?
>
> Now what if I want to change a setting of a savings product (i.e. change
> the compounding period, the interest rate, the interest calculation basis
> etc.) is there currently a way that I can do this and have it affect all
> related savings accounts? Or do I need to update the settings of all the
> savings accounts individually?
>
> Regards,
>
> Joseph
> _______________________________________________
> Mifos-users mailing list
> Mifos-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
Re: [Mifos-developer] [Mifos-users] Managing previously created
savings accounts settings
Posted by Joseph Cabral <jo...@gmail.com>.
HI Barath and Abiy,
Thank you for your feedback and hope you are doing good as well. Ok so it
seems that if we want to change the settings of the individual savings
accounts we have to do it for each one. I think we need to create a batch
job that will run end of day that will be responsible for updating the
savings accounts settings.
Thanks again for your help.
Regards,
Joseph
On Mon, May 25, 2020 at 4:31 PM A A <ab...@gmail.com> wrote:
> Dear Joseph,
>
> You can try selecting the saving product and update the parameters that
> you are using. You may get the values from the newly created product and
> update it in the database. I have tested this and its been working fine.
>
> connect to your database and issue this query.
>
> SELECT * FROM `alphabank-default`.`m_savings_account`;
> UPDATE `alphabank-default`.`m_savings_account` SET
> `nominal_annual_interest_rate`='NEW_VALUE' WHERE `id`>=1;
>
> Do the same for the remaining tables.
>
> Regards,
> Abiy A.
>
>
> On Mon, May 25, 2020 at 11:02 AM Bharath Gowda <bg...@mifos.org> wrote:
>
>> Hi Joseph,
>>
>> Hope you are doing all good
>>
>> I would like to clarify the current behavior of savings accounts in
>> Fineract 1.x. Savings accounts have several table columns similar to those
>> of the savings product instance. This is done so that the individual
>> savings accounts previously created are not affected by any changes to the
>> savings product settings. This is the current behavior of the system right?
>>
>> That is Right, changes made at the product level will not have any impact
>> on already created savings accounts.
>>
>> Now what if I want to change a setting of a savings product (i.e. change
>> the compounding period, the interest rate, the interest calculation basis
>> etc.) is there currently a way that I can do this and have it affect all
>> related savings accounts? Or do I need to update the settings of all the
>> savings accounts individually?
>>
>> Currently, there is no option to change those parameters to the
>> existing saving accounts. any changes you make at the product level will
>> have an impact only on newly created accounts.
>> you can try changing the parameters (i.e. change the compounding period,
>> the interest rate, the interest calculation basis etc.) at the Account
>> level, However, we recommend you test the scenarios on couple of accounts
>> first to see if it meets your requirement before doing it for all loans.
>>
>>
>>
>> Regards,
>> Bharath
>> Lead Implementation Analyst | Mifos Initiative
>> Skype: live:cbharath4| Mobile: +91.7019636073
>> http://mifos.org <http://facebook.com/mifos>
>> <http://www.twitter.com/mifos>
>>
>>
>> On Thu, May 21, 2020 at 7:51 PM Joseph Cabral <jo...@gmail.com>
>> wrote:
>>
>>> Hi again Fineract Team,
>>>
>>> I would like to clarify the current behavior of savings accounts in
>>> Fineract 1.x. Savings accounts have several table columns similar to those
>>> of the savings product instance. This is done so that the individual
>>> savings accounts previously created are not affected by any changes to the
>>> savings product settings. This is the current behavior of the system right?
>>>
>>> Now what if I want to change a setting of a savings product (i.e. change
>>> the compounding period, the interest rate, the interest calculation basis
>>> etc.) is there currently a way that I can do this and have it affect all
>>> related savings accounts? Or do I need to update the settings of all the
>>> savings accounts individually?
>>>
>>> Regards,
>>>
>>> Joseph
>>> _______________________________________________
>>> Mifos-users mailing list
>>> Mifos-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>
>> Mifos-developer mailing list
>> mifos-developer@lists.sourceforge.net
>> Unsubscribe or change settings at:
>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
>
Re: [Mifos-developer] [Mifos-users] Managing previously created
savings accounts settings
Posted by A A <ab...@gmail.com>.
Dear Joseph,
You can try selecting the saving product and update the parameters that you
are using. You may get the values from the newly created product and update
it in the database. I have tested this and its been working fine.
connect to your database and issue this query.
SELECT * FROM `alphabank-default`.`m_savings_account`;
UPDATE `alphabank-default`.`m_savings_account` SET
`nominal_annual_interest_rate`='NEW_VALUE' WHERE `id`>=1;
Do the same for the remaining tables.
Regards,
Abiy A.
On Mon, May 25, 2020 at 11:02 AM Bharath Gowda <bg...@mifos.org> wrote:
> Hi Joseph,
>
> Hope you are doing all good
>
> I would like to clarify the current behavior of savings accounts in
> Fineract 1.x. Savings accounts have several table columns similar to those
> of the savings product instance. This is done so that the individual
> savings accounts previously created are not affected by any changes to the
> savings product settings. This is the current behavior of the system right?
>
> That is Right, changes made at the product level will not have any impact
> on already created savings accounts.
>
> Now what if I want to change a setting of a savings product (i.e. change
> the compounding period, the interest rate, the interest calculation basis
> etc.) is there currently a way that I can do this and have it affect all
> related savings accounts? Or do I need to update the settings of all the
> savings accounts individually?
>
> Currently, there is no option to change those parameters to the
> existing saving accounts. any changes you make at the product level will
> have an impact only on newly created accounts.
> you can try changing the parameters (i.e. change the compounding period,
> the interest rate, the interest calculation basis etc.) at the Account
> level, However, we recommend you test the scenarios on couple of accounts
> first to see if it meets your requirement before doing it for all loans.
>
>
>
> Regards,
> Bharath
> Lead Implementation Analyst | Mifos Initiative
> Skype: live:cbharath4| Mobile: +91.7019636073
> http://mifos.org <http://facebook.com/mifos>
> <http://www.twitter.com/mifos>
>
>
> On Thu, May 21, 2020 at 7:51 PM Joseph Cabral <jo...@gmail.com>
> wrote:
>
>> Hi again Fineract Team,
>>
>> I would like to clarify the current behavior of savings accounts in
>> Fineract 1.x. Savings accounts have several table columns similar to those
>> of the savings product instance. This is done so that the individual
>> savings accounts previously created are not affected by any changes to the
>> savings product settings. This is the current behavior of the system right?
>>
>> Now what if I want to change a setting of a savings product (i.e. change
>> the compounding period, the interest rate, the interest calculation basis
>> etc.) is there currently a way that I can do this and have it affect all
>> related savings accounts? Or do I need to update the settings of all the
>> savings accounts individually?
>>
>> Regards,
>>
>> Joseph
>> _______________________________________________
>> Mifos-users mailing list
>> Mifos-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>
> Mifos-developer mailing list
> mifos-developer@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer