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
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
