You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/07/25 12:22:20 UTC
[jira] [Commented] (FINERACT-61) Incorrect penalty and fee charges
amount inserted into the "m_loan_arrears_aging" table
[ https://issues.apache.org/jira/browse/FINERACT-61?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15391800#comment-15391800 ]
ASF GitHub Bot commented on FINERACT-61:
----------------------------------------
GitHub user emmanuelnnaa opened a pull request:
https://github.com/apache/incubator-fineract/pull/184
commit for FINERACT-61 (Incorrect penalty and fee charges amount inserted into the 'm_loan_arrears_aging' table)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/emmanuelnnaa/incubator-fineract FINERACT-61
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-fineract/pull/184.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #184
----
commit 31a3d16170f06055f1741a299e17d42849d26dcb
Author: Emmanuel Nnaa <em...@musoni.eu>
Date: 2016-07-25T12:20:31Z
commit for FINERACT-61 (Incorrect penalty and fee charges amount inserted into the 'm_loan_arrears_aging' table)
----
> Incorrect penalty and fee charges amount inserted into the "m_loan_arrears_aging" table
> ---------------------------------------------------------------------------------------
>
> Key: FINERACT-61
> URL: https://issues.apache.org/jira/browse/FINERACT-61
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Emmanuel Nnaa
> Assignee: Markus Geiss
> Priority: Minor
>
> The "waived charges amount" and "written-off charges amount" are not deducted from the charges amount when calculating the "penalty charges overdue" or "fee charges overdue".
> *Example:*
> The "fee charges overdue" query should be:
> {code}
> SUM(ifnull(mr.fee_charges_amount, 0) - ifnull(mr.fee_charges_writtenoff_derived, 0) - "
> + "ifnull(mr.fee_charges_waived_derived, 0) - ifnull(mr.fee_charges_completed_derived, 0))
> {code}
> and not:
> {code}
> SUM((ifnull(mr.fee_charges_amount,0) - ifnull(mr.fee_charges_completed_derived, 0)))
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)