Zero savings interest posted for previous periods with account that has above
minimum balance.
----------------------------------------------------------------------------------------------
Key: MIFOS-3417
URL: http://mifosforge.jira.com/browse/MIFOS-3417
Project: mifos
Issue Type: Bug
Components: Savings Account
Affects Versions: Release 1.5
Reporter: jbrewster
Priority: Major
(Related to issue MIFOS-3312)
While testing fixes for MIFOS-3312, I noticed accounts were interesting_posting
in activity log for savings account shows multiple times. For example,
Individual Compulsory Fund # 000100000029684 has two zero interest postings:
30/06/2010 Interest_Posting 0 4935
31/03/2010 Interest_Posting 0 4935
Queried the production data snapshot and there are over 8,000 entries where
interest posting is zero and min balance is above 1000. Need to analyze these
other interest periods to determine whether the interest for that period is
missing or if interest posting of zero is correct. (maybe account is dormant
and that results in no interesting posting?) I see create dates in
savings_activity_details table with zero posting are from Dec 2009, March 2010,
and June 2010.
Query I used:
SELECT * FROM savings_activity_details s where amount = '0.0' and
balance_amount > '1000.0';
For example account 000100000029684, I've attached a screenshot of the activity
details and the transaction log.
--
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 Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
