[
http://mifosforge.jira.com/browse/MIFOSBI-217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau updated MIFOSBI-217:
-----------------------------
Fix Version/s: (was: Mifos BI 1.2)
> Branch Progress report showing reversed loans in the arrears area
> -----------------------------------------------------------------
>
> Key: MIFOSBI-217
> URL: http://mifosforge.jira.com/browse/MIFOSBI-217
> Project: mifos business intelligence
> Issue Type: Bug
> Components: Reports
> Reporter: Jeff Brewster
> Assignee: mifosdeveloperqueue
>
> Binny reported this behavior first in issue MIFOS-3986. Splitting off into a
> new issue.
> After the reversal of the loan disbursals, loans still show up in the branch
> progress report as "loans in arrears".
> The reversal was done on 21-Oct. And on the report for 22-Oct (i.e. after the
> batch jobs ran for 21-Oct night), these loans are still being shown as "In
> Arrears" in the report.
> Results of queries executed:
> mysql> select count(distinct customer_id) "Client in arrears" from
> loan_arrears_aging l
> where l.customer_id in
> (select c.CUSTOMER_ID from CUSTOMER c ,office o
> where c.BRANCH_ID = o.OFFICE_ID and c.discriminator="client"
> and o.display_name="Bavla");
> -------------------
> Client in arrears
> -------------------
> 7
> -------------------
> 1 row in set (0.00 sec)
> mysql> select count "Loan in arrears" from loan_arrears_aging l
> where l.customer_id in
> (select c.CUSTOMER_ID from CUSTOMER c ,office o
> where c.BRANCH_ID = o.OFFICE_ID and c.discriminator="client"
> and o.display_name="Bavla");
> -----------------
> Loan in arrears
> -----------------
> 7
> -----------------
> 1 row in set (0.00 sec)
> mysql> select sum(COALESCE(overdue_principal,0)) as "Amount in Arrears"
> from loan_arrears_aging l where l.customer_id in
> (select c.CUSTOMER_ID from CUSTOMER c ,office o
> where c.BRANCH_ID = o.OFFICE_ID and c.discriminator="client"
> and o.display_name="Bavla");
> -------------------
> Amount in Arrears
> -------------------
> 1400.0000
> -------------------
> 1 row in set (0.00 sec)
> mysql> select sum(COALESCE(unpaid_principal,0)) as "Outstanding in Arrears"
> from loan_arrears_aging l where l.customer_id in
> (select c.CUSTOMER_ID from CUSTOMER c ,office o
> where c.BRANCH_ID = o.OFFICE_ID and c.discriminator="client"
> and o.display_name="Bavla");
> ------------------------
> Outstanding in Arrears
> ------------------------
> 48000.0000
> ------------------------
> 1 row in set (0.00 sec)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
