[
http://mifosforge.jira.com/browse/MIFOSBI-217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau moved MIFOS-4018 to MIFOSBI-217:
-----------------------------------------
Component/s: (was: Reports Module)
Reports
Fix Version/s: (was: Elsie F)
Mifos BI 1.2
Affects Version/s: (was: Release 1.6.1)
Key: MIFOSBI-217 (was: MIFOS-4018)
Project: mifos business intelligence (was: mifos)
> 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: jbrewster
> Assignee: mifosdeveloperqueue
> Fix For: Mifos BI 1.2
>
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
