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
