[
http://mifosforge.jira.com/browse/MIFOS-3479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59490#action_59490
]
johnwoodlock commented on MIFOS-3479:
-------------------------------------
Release E work
--------------
Jakub fixed the part where the account closed_date is not undone in MIFOS-3287
I had done some related work in MIFOS-1986 and also was interested in Sam's
issue because I too am looking at account status changes for the datawarehouse
work. So, I checked out the situation.
I will put in a test and fix to ensure the account_status_change_history is
correct (its a small piece of work now that I've done the impact analysis).
Sam's Open Question on which date to use to close an account still remains.
Another Open Question is whether an attempt should be made to clean up
historical account_status_change_history data (there may be very few). Haven't
really thought about how hard/easy that might be... something like find all
accounts where the old_status and new_status in subsequent entries don't match.
> account_state_change_history and account tables not correctly updated when
> loan adjustments are made
> ----------------------------------------------------------------------------------------------------
>
> Key: MIFOS-3479
> URL: http://mifosforge.jira.com/browse/MIFOS-3479
> Project: mifos
> Issue Type: Bug
> Affects Versions: Release 1.5.1
> Reporter: Sam Birney
> Assignee: Kay Chau
> Priority: Major
>
> To repro:
> 1) make a repayment to close a loan
> 2) see that in the database there is a row showing the account has changed to
> closed_obligation_met in the account_status_change_history table, and the
> close_date of the account table for the loan has been set.
> 3) now apply an adjustment to the loan, removing the last payment, which
> makes the loan open again.
> 4) see that in the database the close_date and account_status_change_history
> tables have not been updated to reflect the adjustment
> expected behavior:
> the account_status_change_history and account tables should not show that
> this loan is closed.
> this bug makes it hard (or impossible?) to accurately get a historical count
> of active loans for a date in the past, which is very important to know for
> the business owners of an MFI.
> open question:
> should the close_date of the loan reflect the payment date or the action_date
> for the payment that closed the loan? It seems to currently show the
> action_date, but would payment_date make more sense when a backdated
> transaction is entered?
> For business purposes, the loan was closed when the final payment was made,
> not when the data was entered. If the PMs agree the close_date should be the
> payment_date and not the action_date, perhaps we should enter a separate bug
> for that?
--
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
------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
