[
http://mifosforge.jira.com/browse/MIFOS-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=57918#action_57918
]
johnwoodlock commented on MIFOS-2914:
-------------------------------------
Probably need more information on what Naganand was looking to move forward (be
it table or report/ mifos or GK customised).
He's my understanding (I might need some gaps filled in).
GK doesn't use the mifos Branch Report. GK uses their own branch report that
reads data that they extract themselves into their own database called
warehouse. The mifos branch report batch task has not run at GK since 4th May
2009.
It is the mifos branch report batch task that puts data into a table called
'batch_loan_arrears_aging'. The table 'batch_loan_arrears_aging' does having
ageing buckets like shown above but it is a branch level report and doesn't get
into client/loan/installment level detail.
There is a loan level table called 'loan_arrears_aging' but that doesn't have
ageing buckets... it just says how many days in arrears the loan is and stores
various overdue and unpaid amounts.
> Aging in Arrears table inaccurate
> ---------------------------------
>
> Key: MIFOS-2914
> URL: http://mifosforge.jira.com/browse/MIFOS-2914
> Project: mifos
> Issue Type: Bug
> Components: Database
> Reporter: emilytucker
> Assignee: johnwoodlock
> Priority: Critical
> Fix For: Shamim D
>
>
> According to Naganand the summary table in Mifos, Aging in Arrears (not sure
> the exact table name), is not being populated correctly.
> Scenario: Client has a weekly loan that has 3 missed installments of 100Rs
> each. The most overdue installment is 3 weeks late, the more recently missed
> installment is a few days late.
> Expected: In the aging in arrears table, these values should be populated
> like this:
> 1-7 Days in areas: 100Rs
> 7-14 days in arrears: 100Rs.
> 14-21 days in arrears: 100
> Actual
> 1-7 Days in areas: 0
> 7-14 days in arrears: 0.
> 14-21 days in arrears: 300
> Basically ALL overdue installments are appears in the aging bucket of the
> oldest/most late installment.
--
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
------------------------------------------------------------------------------
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
