[
http://mifosforge.jira.com/browse/MIFOS-3417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59094#action_59094
]
Udai Gupta commented on MIFOS-3417:
-----------------------------------
since Aug 2009, there has been 4 interest postings end of sept 2009, dec 2009,
march 2010, june 2010.
1 means the june 2010 interest posting is zero
2 means june2010 and march2010
3 means dec 2009 and march, june 2010
4 means sept,dec 2009 and march, june 2010
The BALANCE_AMOUNT in savings_activity_details is the current running balance
(the AMOUNT is added into it) at the time of AMOUNT
processed(deposited/withdrawn/posted).
for zero interest posting the running balance will be same after and before
interest posting.
so here is another query which brings the wrong interest posting in terms of
time.
for sept 2009
SELECT account_id AS no_of_int_posted FROM savings_activity_details
WHERE ACCOUNT_ACTION_ID = 11 AND BALANCE_AMOUNT > 1000 AND amount = 0
AND created_date < '2009-10-01 00:00:00'
for dec 2009 (DISCTINCT as some account will have 2 interest posting as zero)
SELECT DISTINCT(account_id) AS no_of_int_posted FROM savings_activity_details
WHERE ACCOUNT_ACTION_ID = 11 AND BALANCE_AMOUNT > 1000 AND amount = 0
AND created_date < '2010-01-01 00:00:00'
for march 2010
AND created_date < '2010-04-01 00:00:00'
for june 2010
AND created_date < '2010-07-01 00:00:00'
> 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
> Assignee: Udai Gupta
> Priority: Major
> Fix For: Release E - Iteration 3, Release E
>
> Attachments: 3417txn.JPG, SavingsAcctTableRslt.txt, screenshot-1.jpg
>
>
> (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
