[
http://mifosforge.jira.com/browse/MIFOS-2863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=57488#action_57488
]
jbrewster commented on MIFOS-2863:
----------------------------------
Added link to previously reported issue - MIFOS-2681.
Some comments on attached document:
1. Loans at risk comment says "All clients in arrears should be at risks. Why
only 6 when at lot is found on the other side so with the amount" - The loans
at risk columns match the 12+ weeks in arrears values shows in the table just
below. I think these numbers are accurate.
2. Regarding the totals of aging of loans in arrears values not matching the
Loans in arrears totals, I see the same issue with "Pasay Branch" on test
server - ci.mifos.org:8085/mifos. I'm attaching the queries that I believe
are used in this report for each column. These queries need to be investigated
for accuracy.
3. Branch staffing number not showing all staff appears to be unique to SECDEP.
test server shows all staff - I'll attach pdf to this issue.
4. "Total amount of this column should be the same with the amount in arrears"
- these run different queries, see below. If these should be changed to be the
same information, the report need to be modified:
3.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="PASSI")
11.select sum(COALESCE(l.overdue_principal,0)) as ArrearsAmount from
loan_arrears_aging l
where l.customer_id in
(select distinct c.CUSTOMER_ID from CUSTOMER c ,office o,account acc
where c.BRANCH_ID = o.OFFICE_ID
and c.CUSTOMER_ID=acc.CUSTOMER_ID
and acc.account_state_id=9
and o.display_name="PASSI")
> Branch Progress Report has several incorrect values
> ---------------------------------------------------
>
> Key: MIFOS-2863
> URL: http://mifosforge.jira.com/browse/MIFOS-2863
> Project: mifos
> Issue Type: Bug
> Components: Reports Module
> Reporter: emilytucker
> Priority: Major
> Attachments: Branch Progress Report.doc
>
>
> See attached report from Secdep. There are several problems:
> (*) Number of staff not displaying correctly
> (*) The arrears break-down by staff is not correct-- it also doesn't add up
> to the total arrears in the upper section of the report
> (*) Summary of amount of loans and # of clients in arrears does not match the
> arrears aging table.
--
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
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
