You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Jun King Miñon <ju...@pearlpay.io> on 2019/07/04 08:27:28 UTC
Re: [Mifos-users] Rounding off: Installment Due is always a whole number
Hi Deepak/Santosh,
Thanks for your prompt responses. Yes, I have already done that but it
throws an exception/validation that it should be greater than 0:
[image: image.png]
Also checking the code, this is set to Integer type thus, 0.01 will also
not work. Cheers!
Regards,
Jun King P. Miñon
Consultant Software Engineer
Core Banking Solutions
On Thu, Jul 4, 2019 at 4:23 PM Santosh Math <sa...@confluxtechnologies.com>
wrote:
> Hi Jun,
> Keep 'Instalment in Multiple of' as 0 and try again.
>
>
> On Thu, Jul 4, 2019 at 1:41 PM Jun King Miñon <ju...@pearlpay.io> wrote:
>
>> Hi Everyone,
>>
>> I am currently doing a gap analysis with our client's current loan
>> products. I am just comparing some values and one thing I found out is the
>> rounding-off in Mifos when it comes to installment. I hope someone can
>> point me in the right direction on this.
>>
>> For example, I have this scenario:
>>
>> *Loan Principal - 1,000,000*
>> * Annual Interest - 16%*
>> * Loan Term - 60 months (repay every 30 days)*
>>
>> Theoretically, I shoulld have below computation where my installment due
>> for each period is *24,318.06*
>>
>> [image: image.png]
>>
>> However, on Mifos - the installment due was rounded of to *24,318 - *although
>> negligible, the longer the term the higher the discrepancy will be.
>>
>> [image: image.png]
>>
>> This can be due to the currency setting that I set out on my loan product
>> template, see below. Now the question is, there is no way for the field
>> Installment in multiples of to be zero or lower thus will always remove the
>> decimal places. Is this correct? Or is there a way to solve this via system
>> configuration?
>>
>> [image: image.png]
>>
>> Thanks again in advance and cheers!
>>
>>
>> Regards,
>>
>> Jun King P. Miñon
>> Consultant Software Engineer
>> Core Banking Solutions
>>
>>
>> PEARLPAY INC.
>>
>> 2nd Floor, 22 The Jupiter Center, Jupiter Street, Makati, 1209 Metro
>> Manila, Philippines
>>
>> https://www.pearlpay.com
>> https://www.linkedin.com/company/pearlpay
>> https://www.facebook.com/PearlPayOFFICIAL
>>
>> This email and any files transmitted with it are confidential and
>> intended solely for the use of the individual or entity to whom they are
>> addressed. If you have received this email in error please notify the
>> system manager. This message contains confidential information and is
>> intended only for the individual named. If you are not the named addressee
>> you should not disseminate, distribute or copy this e-mail. Please notify
>> the sender immediately by e-mail if you have received this e-mail by
>> mistake and delete this e-mail from your system. If you are not the
>> intended recipient you are notified that disclosing, copying, distributing
>> or taking any action in reliance on the contents of this information is
>> strictly prohibited. WARNING: Computer viruses can be transmitted via
>> email. The recipient should check this email and any attachments for the
>> presence of viruses. The company accepts no liability for any damage caused
>> by any virus transmitted by this email. E-mail transmission cannot be
>> guaranteed to be secure or error-free as information could be intercepted,
>> corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.
>> The sender therefore does not accept liability for any errors or omissions
>> in the contents of this message, which arise as a result of e-mail
>> transmission. Our company accepts no liability for the content of this
>> email, or for the consequences of any actions taken on the basis of the
>> information provided, unless that information is subsequently confirmed in
>> writing. If you are not the intended recipient you are notified that
>> disclosing, copying, distributing or taking any action in reliance on the
>> contents of this information is strictly prohibited. Any views or opinions
>> presented in this email are solely those of the author and do not
>> necessarily represent those of the company. Employees of the company are
>> expressly required not to make defamatory statements and not to infringe or
>> authorize any infringement of copyright or any other legal right by email
>> communications. Any such communication is contrary to company policy and
>> outside the scope of the employment of the individual concerned. The
>> company will not accept any liability in respect of such communication, and
>> the employee responsible will be personally liable for any damages or other
>> liability arising.
>>
>
>
> --
> Thanks & Regards
>
> Santosh Math
>
> *QA Engineer*
>
> *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>*
> | *Office*: +91-080-41208662 |
>
> *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block,
> Bengaluru, Karnataka, 560043 INDIA
> _______________________________________________
> Mifos-users mailing list
> Mifos-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
--
PEARLPAY INC.
2nd Floor, 22 The Jupiter Center, Jupiter Street,
Makati, 1209 Metro Manila, Philippines
https://www.pearlpay.com
<https://www.pearlpay.com>
https://www.linkedin.com/company/pearlpay
<https://www.linkedin.com/company/pearlpay>
https://www.facebook.com/PearlPayOFFICIAL
<https://www.facebook.com/PearlPayOFFICIAL/>
This email and any files
transmitted with it are confidential and intended solely for the use of the
individual or entity to whom they are addressed. If you have received this
email in error please notify the system manager. This message contains
confidential information and is intended only for the individual named. If
you are not the named addressee you should not disseminate, distribute or
copy this e-mail. Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and delete this e-mail from your
system. If you are not the intended recipient you are notified that
disclosing, copying, distributing or taking any action in reliance on the
contents of this information is strictly prohibited. WARNING: Computer
viruses can be transmitted via email. The recipient should check this email
and any attachments for the presence of viruses. The company accepts no
liability for any damage caused by any virus transmitted by this email.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message,
which arise as a result of e-mail transmission. Our company accepts no
liability for the content of this email, or for the consequences of any
actions taken on the basis of the information provided, unless that
information is subsequently confirmed in writing. If you are not the
intended recipient you are notified that disclosing, copying, distributing
or taking any action in reliance on the contents of this information is
strictly prohibited. Any views or opinions presented in this email are
solely those of the author and do not necessarily represent those of the
company. Employees of the company are expressly required not to make
defamatory statements and not to infringe or authorize any infringement of
copyright or any other legal right by email communications. Any such
communication is contrary to company policy and outside the scope of the
employment of the individual concerned. The company will not accept any
liability in respect of such communication, and the employee responsible
will be personally liable for any damages or other liability arising.
Re: [Mifos-users] Rounding off: Installment Due is always a whole number
Posted by Jun King Miñon <ju...@pearlpay.io>.
Hi Santos/Deepak,
It is now working. What I did is to remove the input and did not enter a 0
value - thus returning a *NULL* for which, will then be ignored by the
rounding machinery.
I got confused on the required * part thus, having an issue at first. :)
[image: image.png]
Regards,
Jun King P. Miñon
Consultant Software Engineer
Core Banking Solutions
On Thu, Jul 4, 2019 at 4:27 PM Jun King Miñon <ju...@pearlpay.io> wrote:
> Hi Deepak/Santosh,
>
> Thanks for your prompt responses. Yes, I have already done that but it
> throws an exception/validation that it should be greater than 0:
>
> [image: image.png]
>
>
> Also checking the code, this is set to Integer type thus, 0.01 will also
> not work. Cheers!
>
>
> Regards,
>
> Jun King P. Miñon
> Consultant Software Engineer
> Core Banking Solutions
>
>
> On Thu, Jul 4, 2019 at 4:23 PM Santosh Math <
> santosh@confluxtechnologies.com> wrote:
>
>> Hi Jun,
>> Keep 'Instalment in Multiple of' as 0 and try again.
>>
>>
>> On Thu, Jul 4, 2019 at 1:41 PM Jun King Miñon <ju...@pearlpay.io> wrote:
>>
>>> Hi Everyone,
>>>
>>> I am currently doing a gap analysis with our client's current loan
>>> products. I am just comparing some values and one thing I found out is the
>>> rounding-off in Mifos when it comes to installment. I hope someone can
>>> point me in the right direction on this.
>>>
>>> For example, I have this scenario:
>>>
>>> *Loan Principal - 1,000,000*
>>> * Annual Interest - 16%*
>>> * Loan Term - 60 months (repay every 30 days)*
>>>
>>> Theoretically, I shoulld have below computation where my installment
>>> due for each period is *24,318.06*
>>>
>>> [image: image.png]
>>>
>>> However, on Mifos - the installment due was rounded of to *24,318 - *although
>>> negligible, the longer the term the higher the discrepancy will be.
>>>
>>> [image: image.png]
>>>
>>> This can be due to the currency setting that I set out on my loan
>>> product template, see below. Now the question is, there is no way for the
>>> field Installment in multiples of to be zero or lower thus will always
>>> remove the decimal places. Is this correct? Or is there a way to solve this
>>> via system configuration?
>>>
>>> [image: image.png]
>>>
>>> Thanks again in advance and cheers!
>>>
>>>
>>> Regards,
>>>
>>> Jun King P. Miñon
>>> Consultant Software Engineer
>>> Core Banking Solutions
>>>
>>>
>>> PEARLPAY INC.
>>>
>>> 2nd Floor, 22 The Jupiter Center, Jupiter Street, Makati, 1209 Metro
>>> Manila, Philippines
>>>
>>> https://www.pearlpay.com
>>> https://www.linkedin.com/company/pearlpay
>>> https://www.facebook.com/PearlPayOFFICIAL
>>>
>>> This email and any files transmitted with it are confidential and
>>> intended solely for the use of the individual or entity to whom they are
>>> addressed. If you have received this email in error please notify the
>>> system manager. This message contains confidential information and is
>>> intended only for the individual named. If you are not the named addressee
>>> you should not disseminate, distribute or copy this e-mail. Please notify
>>> the sender immediately by e-mail if you have received this e-mail by
>>> mistake and delete this e-mail from your system. If you are not the
>>> intended recipient you are notified that disclosing, copying, distributing
>>> or taking any action in reliance on the contents of this information is
>>> strictly prohibited. WARNING: Computer viruses can be transmitted via
>>> email. The recipient should check this email and any attachments for the
>>> presence of viruses. The company accepts no liability for any damage caused
>>> by any virus transmitted by this email. E-mail transmission cannot be
>>> guaranteed to be secure or error-free as information could be intercepted,
>>> corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.
>>> The sender therefore does not accept liability for any errors or omissions
>>> in the contents of this message, which arise as a result of e-mail
>>> transmission. Our company accepts no liability for the content of this
>>> email, or for the consequences of any actions taken on the basis of the
>>> information provided, unless that information is subsequently confirmed in
>>> writing. If you are not the intended recipient you are notified that
>>> disclosing, copying, distributing or taking any action in reliance on the
>>> contents of this information is strictly prohibited. Any views or opinions
>>> presented in this email are solely those of the author and do not
>>> necessarily represent those of the company. Employees of the company are
>>> expressly required not to make defamatory statements and not to infringe or
>>> authorize any infringement of copyright or any other legal right by email
>>> communications. Any such communication is contrary to company policy and
>>> outside the scope of the employment of the individual concerned. The
>>> company will not accept any liability in respect of such communication, and
>>> the employee responsible will be personally liable for any damages or other
>>> liability arising.
>>>
>>
>>
>> --
>> Thanks & Regards
>>
>> Santosh Math
>>
>> *QA Engineer*
>>
>> *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>*
>> | *Office*: +91-080-41208662 |
>>
>> *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block,
>> Bengaluru, Karnataka, 560043 INDIA
>> _______________________________________________
>> Mifos-users mailing list
>> Mifos-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>
>
--
PEARLPAY INC.
2nd Floor, 22 The Jupiter Center, Jupiter Street,
Makati, 1209 Metro Manila, Philippines
https://www.pearlpay.com
<https://www.pearlpay.com>
https://www.linkedin.com/company/pearlpay
<https://www.linkedin.com/company/pearlpay>
https://www.facebook.com/PearlPayOFFICIAL
<https://www.facebook.com/PearlPayOFFICIAL/>
This email and any files
transmitted with it are confidential and intended solely for the use of the
individual or entity to whom they are addressed. If you have received this
email in error please notify the system manager. This message contains
confidential information and is intended only for the individual named. If
you are not the named addressee you should not disseminate, distribute or
copy this e-mail. Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and delete this e-mail from your
system. If you are not the intended recipient you are notified that
disclosing, copying, distributing or taking any action in reliance on the
contents of this information is strictly prohibited. WARNING: Computer
viruses can be transmitted via email. The recipient should check this email
and any attachments for the presence of viruses. The company accepts no
liability for any damage caused by any virus transmitted by this email.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message,
which arise as a result of e-mail transmission. Our company accepts no
liability for the content of this email, or for the consequences of any
actions taken on the basis of the information provided, unless that
information is subsequently confirmed in writing. If you are not the
intended recipient you are notified that disclosing, copying, distributing
or taking any action in reliance on the contents of this information is
strictly prohibited. Any views or opinions presented in this email are
solely those of the author and do not necessarily represent those of the
company. Employees of the company are expressly required not to make
defamatory statements and not to infringe or authorize any infringement of
copyright or any other legal right by email communications. Any such
communication is contrary to company policy and outside the scope of the
employment of the individual concerned. The company will not accept any
liability in respect of such communication, and the employee responsible
will be personally liable for any damages or other liability arising.