[
http://mifosforge.jira.com/browse/MIFOSBI-146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=63103#action_63103
]
johnwoodlock commented on MIFOSBI-146:
--------------------------------------
hi Kay, Binny
I think what is being asked for in this issue is to be able to do a 'group
level' collection sheet report for MFI's that have set the configuration option
center_hierarchy to false. So, the same as the standard col sheet but for
where 'groups' are the top of the customer hierarchy. The current standard col
sheet report assumes a 'kendra' (center), group, client hierarchy. Also it
doesn't handle savings or loan/customer period fees (it does handle disbursal
fees). Below is a note I made last time I tweaked the performance. Am I right
so far in the above?
"Query for Collect Sheet Report. Really a loan report as no
savings or
customer charges are involved. Its a complicated query that
contains a
number of assumptions that seem to be GK related (e.g. no group
loans). However, GK have their own version of the report and
the sql
GK use is an amended version of the query below. The query is
made up
of 4 "sub-queries". For performance reasons each subquery uses
similar
criteria to restrict searches to just those active clients that
match
the input meeting date. i.e. there's a bit of duplication but
it was
needed for speed. This out of the box mifos collection sheet
report
may be reviewed from a functional perspective."
> Fix Collection Sheet report to work with centers off
> ----------------------------------------------------
>
> Key: MIFOSBI-146
> URL: http://mifosforge.jira.com/browse/MIFOSBI-146
> Project: mifos business intelligence
> Issue Type: Story
> Components: Reports
> Reporter: Kay Chau
> Assignee: johnwoodlock
> Fix For: Mifos BI 1.0 - Iteration 14, Mifos BI 1.0
>
>
> Current collection sheet report that ships with Mifos only works with centers
> off. Fix report to have Group instead Center dropdown as a parameter, and no
> mention of groups in the report.
--
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
------------------------------------------------------------------------------
Forrester recently released a report on the Return on Investment (ROI) of
Google Apps. They found a 300% ROI, 38%-56% cost savings, and break-even
within 7 months. Over 3 million businesses have gone Google with Google Apps:
an online email calendar, and document program that's accessible from your
browser. Read the Forrester report: http://p.sf.net/sfu/googleapps-sfnew
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
