[
http://mifosforge.jira.com/browse/MIFOS-3417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59105#action_59105
]
jbrewster commented on MIFOS-3417:
----------------------------------
Did the following test to see what would happen if the batch job for interest
calculation and posting got another chance to calculate and post interest to
the account mentioned in this issue. Appears the interested for Q1 2010
calculated and posted a non-zero amount - 61.0. I didn't validate that number,
but it looks pretty close at a glance. The previous quarter posted 58.0.
steps to try this:
a) stopped mifos
b) altered LAST_INT_CALC_DATE, LAST_INT_POST_DATE, NEXT_INT_CALC_DATE,
NEXT_INT_POST_DATE as shown below
c) started mifos and executed batch jobs
d) viewed UI savings account activity. activity showed:
Date Activity Amount RunningBalance
30/06/2010 Interest_Posting 0.0 5136.0
31/03/2010 Interest_Posting 61.0 5136.0 <--------- see this
posting now. I set 3/31 manually. should have been 3/30??
29/06/2010 Interest_Posting 0.0 5075.0
14/06/2010 Deposit 20.0 5075.0
07/06/2010 Deposit 20.0 5055.0
31/05/2010 Deposit 60.0 5035.0
30/03/2010 Interest_Posting 0.0 4975.0
Here is what I changed the single row in savings_account of data set
timestamped 13 July 2010 prior to running test:
ACCOUNT_ID, ACTIVATION_DATE, SAVINGS_BALANCE, SAVINGS_BALANCE_CURRENCY_ID,
RECOMMENDED_AMOUNT, RECOMMENDED_AMOUNT_CURRENCY_ID, RECOMMENDED_AMNT_UNIT_ID,
SAVINGS_TYPE_ID, INT_TO_BE_POSTED, INT_TO_BE_POSTED_CURRENCY_ID,
LAST_INT_CALC_DATE, LAST_INT_POST_DATE, NEXT_INT_CALC_DATE, NEXT_INT_POST_DATE,
INTER_INT_CALC_DATE, PRD_OFFERING_ID, INTEREST_RATE,
INTEREST_CALCULATION_TYPE_ID, TIME_PER_FOR_INT_CALC, MIN_AMNT_FOR_INT,
MIN_AMNT_FOR_INT_CURRENCY_ID
29684, '2009-09-24', 5075.0000, 2, 20.0000, 2, , 1, 61.0000, 2, '2009-12-31',
'2009-12-31', '2010-03-31', '2010-03-31', '', 3, 5.0000000000, 2, 20529,
1000.0000, 2
Maybe the savingsIntCalc job didn't get some of these zero interest accounts to
process due to a problem with the list of accounts passed to the batch job?
> 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
