[
http://mifosforge.jira.com/browse/MIFOS-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jbrewster updated MIFOS-2645:
-----------------------------
Status: Verified (was: Resolved)
> overdue amount calculation is excluding the partial amount paid in Loan
> arrears aging batch job
> -----------------------------------------------------------------------------------------------
>
> Key: MIFOS-2645
> URL: http://mifosforge.jira.com/browse/MIFOS-2645
> Project: mifos
> Issue Type: Bug
> Components: Batch jobs
> Affects Versions: Release 1.4
> Reporter: Kay Chau
> Assignee: Van Mittal-Henkle
> Priority: Critical
> Fix For: Gazelle C
>
>
> From Praveen:
> Batch Job Loan Arrears Aging: the overdue amount calculation is excluding the
> partial amount paid for the loan & taking the whole due amount as the overdue
> amount.
> Issue1: in the batch job process the records generating in the
> "loan_arrears_aging" table is not supporting for loan partial payment.
> As we know, to calculate "overdue_principal" & "overdue_interest" field in
> "loan_arrears_aging" table the calculation is happening from "Loan_Schedule"
> table.
> In case of partial payment the "PAYMENT_STATUS" will remain as Zero(0). & due
> to this the overdue calculation is not calculation properly in the batch job
> process.
> May be in the batch job the overdue calculation is happening as below.
> Overdue_principal= sum(principal) where action_date<current_date and
> PAYMENT_STATUS=0 (overdue_principal ).
> Overdue_interest= sum(interest) where action_date<current_date and
> PAYMENT_STATUS=0 (overdue_interest).
> By doing below calculation this can be corrected.(currently we are managing
> by manually running the script with below calculation to get the correct
> overdue amount).
> Overdue_principal= sum(principal-principal_paid) where
> action_date<current_date and PAYMENT_STATUS=0 (this gives the
> overdue_principal for all the default accounts).
> Overdue_interest= sum(interest) where action_date<current_date and
> PAYMENT_STATUS=0 (this gives the overdue_interest for all the default
> accounts).
--
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
