[
http://mifosforge.jira.com/browse/MIFOS-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jakub Sławiński moved MIFOSBI-217 to MIFOS-5401:
------------------------------------------------
Component/s: (was: Reports)
Reports Module
Key: MIFOS-5401 (was: MIFOSBI-217)
Project: mifos (was: mifos business intelligence)
> Branch Progress report showing reversed loans in the arrears area
> -----------------------------------------------------------------
>
> Key: MIFOS-5401
> URL: http://mifosforge.jira.com/browse/MIFOS-5401
> Project: mifos
> Issue Type: Bug
> Components: Reports Module
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://mifosforge.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
