[
http://mifosforge.jira.com/browse/MIFOS-3874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=60616#action_60616
]
Gayl Kennedy commented on MIFOS-3874:
-------------------------------------
The savings product is set up as follows:
Product category: Adashe & Individual Savings
Start date: 23/08/2010
End date:
Applicable for: Clients
Type of deposits: Voluntary
Recommended Amount for Deposit: 1000.00
Amount Applies to:
Max amount per withdrawal: 10000000.00
Interest rate: 3.0 %
Balance used for Interest calculation.: Average Balance
Time period for Interest calculation.: 1 Month(s)
Frequency of Interest posting to accounts.: 3 month(s)
Minimum balance required for Interest calculation: 0.00
Taking just 2 clients with this type of savings, one had Sept interest (#
000100000000453) the other had Sept and Dec (acct number # 000200000002141)
For the person with Sept and Dec you see it in the account activity view.
Interestingly in the View transactions history log it only shows the Sept date:
Date PaymentID TransactionID Type GLCode Debit Credit
Clientname DatePosted PostedBy AdjustmentNotes
06/10/2010 3878 4142 Voluntory Withdrawal 112011020 -
10000.00 James Guy 06/10/2010 Veronica Lawrence -
06/10/2010 3878 4142 Voluntory Withdrawal 231012321
10000.00 - James Guy 06/10/2010 Veronica Lawrence
-
04/10/2010 3585 3837 Savings Interest Posting 231012321
- 42.84 James Guy 30/09/2010 null -
04/10/2010 3585 3837 Savings Interest Posting 411005636
42.84 - James Guy 30/09/2010 null -
28/09/2010 1956 2168 Voluntory Withdrawal 231012321
15000.00 - James Guy 28/09/2010 Veronica Lawrence
-
It also applied to a group savings product which is set up the same.
> Interest posting v1.6 error
> ---------------------------
>
> Key: MIFOS-3874
> URL: http://mifosforge.jira.com/browse/MIFOS-3874
> Project: mifos
> Issue Type: Bug
> Environment: version 1.6
> Reporter: Gayl Kennedy
> Priority: Major
>
> Our interest on saving accounts is set up to post quarterly so the first
> quarter end was Sept 30th.
> This week we noted that some accounts had an interest posting for Sept 30th
> but some also had it for Dec 31, 2010 which is incorrect.
> Note the 31 Dec posting had zero value.
> What will happen to those accounts on 31 Dec when they should get interest?
> I don't understand the inconsistency
> example 1 - 3% interest - see Sept & Dec date
> Date Description Amount
> 31/12/2010 Interest_Posting 0.00
> 30/09/2010 Interest_Posting 42.84
> example 2 - 3% interest - just see Sept date
> Date Description Amount
> 30/09/2010 Interest_Posting 551.52
> we ran 2 queries provided by Uday - both of which returned no results.
> # 1: to see interest posting batch job was ran twice on any day.
> select * from (select count(*) as a from scheduled_tasks where
> taskname="SavingsIntPostingTask" group by date(starttime)) d where a >1
>
> The 2nd query to see if batch job ran for any future date.
> SELECT * FROM scheduled_tasks WHERE taskname="SavingsIntPostingTask"
> AND DATE(starttime) > '2010-10-30'
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
