[
http://mifosforge.jira.com/browse/MIFOS-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau updated MIFOS-4018:
----------------------------
Fix Version/s: Elsie F
Assignee: mifosdeveloperqueue
Fix this when we move to Pentaho
> Branch Progress report showing reversed loans in the arrears area
> -----------------------------------------------------------------
>
> Key: MIFOS-4018
> URL: http://mifosforge.jira.com/browse/MIFOS-4018
> Project: mifos
> Issue Type: Bug
> Components: Reports Module
> Affects Versions: Release 1.6.1
> Reporter: jbrewster
> Assignee: mifosdeveloperqueue
> Fix For: Elsie F
>
>
> 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
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
