If a loan payment is missed, the evening batch jobs moves the loan into "Active in Bad Standing" and fills the arrears data for that loan into the loan_arrears_ageing table. If a full payment is made on the next day, the system immediately moves the loan back into "Active in Good Standing"-- however the arrears information still remains in the loan_arrears_ageing table until the batch job that runs that night at midnight. This means that any arrears reports that are run in the afternoon (ie, prior to the midnight batch job) will incorrectly show these fully paid loans to still be in arrears.

Recommendation: At the time a loan is moved from "Active in Bad Standing" to "Active in Good Standing", the arrears information should be removed from the loan_arrears_aging table.

-- Main.emilytucker - 06 Mar 2007

Placed in Issue tracker --abensinger, Wed, 17 Oct 2007 04:06:02 -0700 reply

To update this issue, please use https://mifos.dev.java.net/issues/show_bug.cgi?id=1473